Question

7
Replies
1122
Views
Pavani r (Pavanir6)
Amazon

Amazon
IN
Pavanir6 Member since 2016 103 posts
Amazon
Posted: May 14, 2018
Last activity: June 6, 2018
Posted: 14 May 2018 4:01 EDT
Last activity: 6 Jun 2018 11:24 EDT
Closed

How to extract data from Blob in pgsql DB with query

Hi All,

I need to extract how many users do not have ext authentication enabled in operators tables. pyImportedUser is false it means no external authentical.

I wrote a query like below it's not working please help me.

Select pr_read_from_stream('pyImportedUser',pzInsKey,pzpvstream) from DATA.PR_OPERATORS;

SELECT data.pr_read_int_from_stream('pyImportedUser',(SELECT pzpvstream FROM DATA.PR_OPERATORS ) );

***Edited by Moderator Marissa to add SR Details***

Data Integration Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.