Executing CA Fast Load for DB2 for z/OS (PFL) to load a table with XML column(s) and encountering the following DB2 Load utility message with SWITCH-TO-IBM (YES) specified in UTIL member of hlq.CDBAPARM. In this instance PFL is calling the DB2 Load utility to perform the load due to XML column(s).
DSNU1258I DSNURELD - ORDER OF FIELDS IS NOT VALID FOR KEYWORD SPANNED.
CA Fast Load syntax specified:
FORMAT SPANNED YES
RESUME NO REPLACE
INTO TABLE creator.tablename
The DB2 Load utility has a restriction where LOB / XML columns must be last within the input file when a VBS file is used as input. CA Fast Unload for DB2 for z/OS (PFU) must create the unload file as VBS when dealing with LOB and XML columns.
The PFU documentation has the following note which would apply to both XML and LOB columns:
The OUTPUT-FORMAT VARIABLE,DB2LOAD parameter produces output that
meets some of the unique IBM LOAD requirements for the VBS formatting.
However, CA Fast Unload for DB2 for z/OS does not verify that the LOB
columns are coded last. CA Fast Load for DB2 for z/OS can load the
resulting output. IBM LOAD cannot load the output unless you manually
code the LOB columns at the end. For more information about the IBM VBS
formatting requirements, see the IBM Utility Guide and Reference.
The recommendation is that when you perform the PFU execution where the XML column is not the last column of the table SELECT * cannot be utilized. You will need to code the SELECT statement listing each column specifying the XML column(s) last in the column list. Make certain to use the new load control cards generated from this new PFU execution.