Question

3
Replies
2649
Views
Close popover
Khirod Panda (KHIRODPANDA)
Cognizant

Cognizant
US
KHIRODPANDA Member since 2010 23 posts
Cognizant
Posted: November 27, 2017
Last activity: November 29, 2017
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