Question
AIG American General
IN
Last activity: 20 May 2022 10:22 EDT
where the function pr_read_from_stream would present (is it in DB?). if we get issue with the function, who will resolve? Is it DB
We have a Report definition which is using pr_read_from_stream function to extract the blob data whereas list view pull the pzpvstream and get the data accordingly. The error we got says that the function is not available.
So my question is where the function pr_read_from_stream would present (is it in DB?). if we get issue with the function, who will resolve? Is it DBA?
FOr reference
SELECT "PC0"."SAMNAME" AS "SAMName" , "PC0"."PXREFOBJECTCLASS",
CASLDATA.pr_read_from_stream('.BusinessLineComplete', "PC0".pzInsKey, "PC0".pzPVStream) AS "BusinessLineComplete" ,
CASLDATA.pr_read_from_stream('.BusinessGroupComplete', "PC0".pzInsKey, "PC0".pzPVStream) AS "BusinessGroupComplete" ,
CASLDATA.pr_read_from_stream('.SAMCurrentStatus', "PC0".pzInsKey, "PC0".pzPVStream) AS "SAMCurrentStatus" ,
CASLDATA.pr_read_from_stream('.SPFullName', "PC0".pzInsKey, "PC0".pzPVStream) AS "SPFullName" ,
"PC0"."PXCREATEDATETIME" AS "pxCreateDateTime" , "PC0"."PZINSKEY" AS "pzInsKey"
FROM CASLDATA.pc_assign_worklist "PC0" WHERE ( "PC0"."PXASSIGNEDOPERATORID" = 'S9999991' AND "PC0"."PXREFOBJECTCLASS" = 'CASL-Work-SAM' ) AND "PC0"."PXOBJCLASS" = 'Assign-Worklist'
ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC, 5 ASC, 6 ASC
***Edited by Moderator Marije to add Capability tags***