CA Fast Load execution encountering following message where DB2 Load is called: DSNU1258I DSNURELD ORDER OF FIELDS NOT VALID KEYWORD SPANNED

Document ID : KB000009920
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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:

FASTLOAD
INDDN SYSULD
INPUT-FORMAT SEQ
FORMAT SPANNED YES
OUTPUT-CONTROL BUILD
RESUME NO REPLACE
STARTUP-ACCESS FORCE
SORT-CLINDX
INTO TABLE creator.tablename

Instructions:

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:

+++++
LOB Support

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.