PI87397: ABEND04E RC00E70006 AT DSNXICVT P075 ON DECLARE GLOBAL TEMP TABLE WITH INCLUDING COLUMN DEFAULTS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70006 at DSNXICVT P075 occurred for a DECLARE
  GLOBAL TEMPORARY TABLE (DGTT) statement that included the
  INCLUDING COLUMN DEFAULTS and INCLUDING IDENTITY COLUMN
  ATTRIBUTES clauses.
  

Local fix

• Remove the INCLUDING COLUMN DEFAULTS clause.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 or 12 for z/OS users who                          *
  * declare global temporary table based                         *
  * on the column definitions from the                           *
  * result of a query expression.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00E70006 at DSNXICVT P075                         *
  * may occur when DECLARE GLOBAL                                *
  * TEMPORARY TABLE satisfies the                                *
  * following conditions:                                        *
  * 1. The table definition is based on                          *
  * the column definitions from the                              *
  * result of a query with nested joins                          *
  * where outer join is involved.                                *
  * 2. INCLUDING COLUMN DEFAULTS clause                          *
  * is specified.                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The following example can help to illustrate the problem.
  
  CREATE TABLE T1(COL INT);
  
  CREATE TABLE T2(COL INT);
  
  DECLARE GLOBAL TEMPORARY TABLE DGTT AS
  (SELECT T1.COL
  FROM T1
  JOIN T2 ON T1.COL  = T2.COL
  LEFT JOIN T2 ON T1.COL  = T2.COL
  )
  DEFINITION ONLY
  INCLUDING COLUMN DEFAULTS ;
  
  ABEND04E RC00E70006 at DSNXICVT P075 may occur with above
  DECLARE GLOBAL TEMPORARY TABLE statement.
  

Problem conclusion

• DB2 has been modified to process the DECLARE GLOBAL TEMPORARY
  TABLE statement correctly.
  
  Additional keywords: SQLDGTT DGTT
  

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:

  UI51632 UI51634

Modules/Macros

• DSNXOVD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI51632

     UP17/11/17 P F711

• RB10 PSY UI51634

     UP17/11/17 P F711

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.