Question

2
Replies
60
Views
Joe Hayes (HAYESJ01)
Bank of America
VP
Bank of America
US
HAYESJ01 Member since 2013 1 post
Bank of America
Posted: October 13, 2019
Last activity: October 14, 2019
Posted: 13 Oct 2019 21:33 EDT
Last activity: 14 Oct 2019 0:32 EDT
Closed

Problem gettin data out of the Blob with SQL

I'm using Oracle 12 / Pega 7.2.2


When I do this SQL, I get back 9 rows - as the PYIDs are M-191006-000001 thru -000009

I'm using Oracle 12 / Pega 7.2.2

When I do this SQL, I get back 9 rows - as the PYIDs are M-191006-000001 thru -000009

select PYID, pzinskey, SENDERREF, RELATEDREF, MessageType ,PXCREATEDATETIME ,

gin.pr_read_from_stream('Message','pzInsKey',pzpvstream) message

from GIN.INV_WORK where PYID like 'M-191006-00000%'

The problem is the last field - message - shows the value of that tag from the 1st record on all nine rows returned. If I do this -

select gin.pr_read_from_stream('Message','pzInsKey',pzpvstream) message

from GIN.INV_WORK where pzInsKey = 'INV-GIN-WORK M-191006-000003'

I get the right value back for that record - but it only works right if I explicitly state the pzInsKey value in the where clause so I only get one row back - ie - pzInsKey = 'INV-GIN-WORK M-191006-000003' . How do I get the tag out of the blob for each case in one Sql?

Any help would be greatly appreciated.

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.