Question

2
Replies
11642
Views
Guhanathan Vijayanarayanan (Guhanathan)
Tata Consultancy Services Limited
Assistant Consultant
Tata Consultancy Services Limited
GB
Guhanathan Member since 2010 13 posts
Tata Consultancy Services Limited
Posted: February 10, 2016
Last activity: March 16, 2016
Posted: 10 Feb 2016 7:31 EST
Last activity: 16 Mar 2016 15:15 EDT
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, 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.