Question

3
Replies
2843
Views
Khirod Panda (KHIRODPANDA)
Cognizant

Cognizant
US
KHIRODPANDA Member since 2010 23 posts
Cognizant
Posted: November 27, 2017
Last activity: November 29, 2017
Posted: 27 Nov 2017 13:07 EST
Last activity: 29 Nov 2017 9:21 EST
Closed
Solved

SQL Connector Getting a Property from BLOB using pr_read_from_stream

Hi ,

I am using pr_read_from_stream UDF to read a property value from a Table .I have following Query .

select pr_read_from_stream('.FirstProperty','KHIR-MYTESTAPPLI-WORK M-28',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work

This is not giving me the property value i am looking for .

but when i do a simple query the value is there

See attached doc for issue

** I am using the UDF as i have to update tons of rows and thought that will be quick that obj-open-by-handle and then get the property from that

Data Integration
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.