Using the the IDMS XMLSERIALIZE function in a SELECT statement gives error message DB005547:
SELECT D.DIV_CODE
,XMLSERIALIZE(CONTENT
XMLELEMENT(NAME DIVCODE, DIV_CODE) AS CHAR(3))
FROM DEMOEMPL.DIVISION D;
*+ Status = -4 SQLSTATE = 42500 Messages follow:
*+ DB005000 T127 C0M324: Message for module IDMSOCF, SQL statement number : 1.
*+ DB005547 C-4M324: Procedure SYSCA.XMLSERIALIZE not found in catalog or
*+ procedure invocation syntax used in error.
Release : 19.0
Component : CA IDMS SQL
The SYSCA.XMLSERIALIZE function is missing from the catalog. This can be confirmed by using this command in OCF:
DIS FUNC SYSCA.XMLSERIALIZE;
The XMLSERIALIZE function needs to be added to the system dictionary and to secondary dictionaries where the function will be used.
Add the XMLSERIALIZE function by running step VIEWDDL in configuration job 9, found in the CAISAG.CONFIG library member JOB09.
It uses as input configuration library member CAGJSRC(VIEWDDL).