PI65086: DB2 ADMIN TOOL LINE COMMAND DDL/GEN ON XML TABLE DEFINED WITH XMLSCHEMA ID FAILS WITH SQLCODE-305

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Line command DDL/GEN on XML table defined with XMLSCHEMA ID
  returns:
  ADB1223E ADB2REM:  Unexpected sqlcode in : Fetch c_xml_typemod
  
  DSNT408I SQLCODE = -305, ERROR:  THE NULL VALUE CANNOT BE
            ASSIGNED TO OUTPUT HOST VARIABLE NUMBER 4 BECAUSE
            NO INDICATOR VARIABLE IS SPECIFIED
  DSNT418I SQLSTATE = 22002 SQLSTATE RETURN CODE
  DSNT415I SQLERRP  = DSNXROHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD  = -115  0  0  -1  0  0 SQL DIAGNOSTIC
            INFORMATION
  DSNT416I SQLERRD  = X'FFFFFF8D'  X'00000000'  X'00000000'
            X'FFFFFFFF' X'00000000'  X'00000000' SQL DIAGNOSTIC
            INFORMATION
  
  SQLCODEN305
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the DDL/GEN line command        *
  *                 on an XML table.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DDL/GEN line command     *
  *                      on an XML table, error message          *
  *                      ADB1223E / msgadb1223e and a            *
  *                      SQLCODE=-305 / SQLCODEN305 are          *
  *                      encountered.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the DDL/GEN line command on an XML table, error
  message ADB1223E / msgadb1223e and a SQLCODE=-305 /
  SQLCODEN305 are encountered:
  
  ADB1223E ADB2REM: Unexpected sqlcode in : Fetch
  c_xml_typemod
  
  DSNT408I SQLCODE = -305, ERROR:
  THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT
  HOST VARIABLE NUMBER 4 BECAUSE NO INDICATOR
  VARIABLE IS SPECIFIED
  DSNT418I SQLSTATE   = 22002
  SQLSTATE RETURN CODE
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI42389 UI42390

Modules/Macros

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI42389

     UP16/11/19 P F611

• RB20 PSY UI42390

     UP16/11/19 P F611

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.