DSNTIAUL and XML
The DB2 sample program DSNTIAUL is dynamic SQL processing application that is often used to unload data from DB2 tables to an externalized format.  DSNTIAUL also generates a LOAD control statement that can be used in by  the DB2 LOAD utility to load the externalized data back into DB2.
Currently DSNTIAUL cannot create LOAD statements for XML columns: If the LOBFILE option is specified in the DSNTIAUL parameter list, data in XML columns is fully unloaded into CLOB reference files. Â Otherwise, data in XML columns, up to 32 KB per row, is unloaded in record format and indicated as CLOB the generated LOAD statement. Â But this format, can not be loaded with DB2 Load utility, because LOAD does not support loading XML columns from input record fields specified as CLOB. LOAD expects XML to have a 2-byte length field and a CLOB has a 4-byte length field. This causes the DB2 LOAD utility to terminate with return code 8 and message …
 DSNU390I -DSN1 hh:mm:ss.nn DSNURWUF -
     INVALID CONVERSION FOR FIELD
     -  field-name Â
where field-name is the name of an XML column in the table being loaded.
APAR PM86927 modifies DSNTIAUL to provide a load statement to load XML data as XML when the LOBFILE option is not specified.
Comments
Comments are closed.