Question
Cognizant
US
Last activity: 29 Nov 2017 9:21 EST
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
Accepted Solution
Pegasystems Inc.
US
SELECT pr_read_from_stream('pxMoveImportDateTime','pzInsKey', pzPVStream) as pxMoveImportDateTime from pr4_rule
The first argument is the property in quotes, the second is the name of the pzinskey column, the last is the pzPVStream.
Your query should be something like this
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work
If you want the specific instance for the pzInsKey add it in a where clause
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work where pzInsKey = 'KHIR-MYTESTAPPLI-WORK M-28'
SELECT pr_read_from_stream('pxMoveImportDateTime','pzInsKey', pzPVStream) as pxMoveImportDateTime from pr4_rule
The first argument is the property in quotes, the second is the name of the pzinskey column, the last is the pzPVStream.
Your query should be something like this
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work
If you want the specific instance for the pzInsKey add it in a where clause
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work where pzInsKey = 'KHIR-MYTESTAPPLI-WORK M-28'
hope this helps
Pegasystems Inc.
US
Try without the dot in front of the property, e.g. select pr_read_from_stream('FirstProperty','KHIR-MYTESTAPPLI-WORK M-28',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work;
If that doesn't work, are you sure UDFs are installed and working as expected?
Accepted Solution
Pegasystems Inc.
US
SELECT pr_read_from_stream('pxMoveImportDateTime','pzInsKey', pzPVStream) as pxMoveImportDateTime from pr4_rule
The first argument is the property in quotes, the second is the name of the pzinskey column, the last is the pzPVStream.
Your query should be something like this
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work
If you want the specific instance for the pzInsKey add it in a where clause
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work where pzInsKey = 'KHIR-MYTESTAPPLI-WORK M-28'
SELECT pr_read_from_stream('pxMoveImportDateTime','pzInsKey', pzPVStream) as pxMoveImportDateTime from pr4_rule
The first argument is the property in quotes, the second is the name of the pzinskey column, the last is the pzPVStream.
Your query should be something like this
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work
If you want the specific instance for the pzInsKey add it in a where clause
select pr_read_from_stream('FirstProperty','pzInsKey',pzPVStream) AS "StringValue" from personaledition.pc_khir_mytestappli_work where pzInsKey = 'KHIR-MYTESTAPPLI-WORK M-28'
hope this helps
Cognizant
US
Thank you all . just to add some more on the Response from JimKelly_GCS . If we are using UDF then property name is Case Sensitive. ( found out from other source and tried ) . Also this function will not work on Encrypted BLOB . And the . is property name has no significance as well .