search cancel

DB005547 Procedure SYSCA.XMLSERIALIZE not found in catalog

book

Article ID: 227046

calendar_today

Updated On:

Products

IDMS

Issue/Introduction

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.                                 

Cause

The SYSCA.XMLSERIALIZE function is missing from the catalog. This can be confirmed by using this command in OCF:

DIS FUNC SYSCA.XMLSERIALIZE;

 

Environment

Release : 19.0

Component : CA IDMS SQL

Resolution

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).