Question

2
Replies
10654
Views
Guhanathan Member since 2010 13 posts
Tata Consultancy Services Limited
Posted: February 10, 2016
Last activity: March 16, 2016
Closed
Solved

Query Blob column (pr_read_from_stream)

Hello All,

Is there any way to query the blob column and get the property value.

I am using the below query. It is working for the property which are directly on the pyWorkPage.

Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE

But I want to know the property resides inside one of the pages under pyWorkPage.

I tried the below syntaxes and none of them are working..

"Page\Property"

"Page/Property"

"/Page/Property"

"\Page\property"


Kindly advice.


Thanks,

Guhan!

Data Integration
Moderation Team has archived post
Share this page LinkedIn