Question

3
Replies
2436
Views
KHIRODPANDA Member since 2010 23 posts
Cognizant
Posted: 2 years ago
Last activity: 2 years 9 months ago
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
Share this page LinkedIn