PQ70677: SQLCODE104 INCORRECT DDL FROM OBJECT RESTORE WHEN ZPARM OF DECIMAL=COMMA IS SET, AUOTERUN CLIST, TABLE CREATE STATEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. On DB2 OS/390 with ZPARM of DECIMAL=COMMA you get a SQL error
  if parameters in SQL delimited by commas aren't separated
     from the comma by a space.
  
  2. Adjusts SAUOSAMP member AUOTERUN to reflect the changes that
     were made in DB2 TABLE EDITOR 4.3’s PTF UQ69936.  In order
     to use the Table Editor feature within AUO, you must have
     ETI ptf UQ69936 applied as well as this AUO PTF.
  
  3. Views were showing up as tables in the table listing.
  
  4. Fixes incorrect table create statement in generated ddl for
     tables that reside in IMPLICIT table spaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore for Z/OS.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: On DB2 OS/390 with ZPARM of             *
  *                      DECIMAL=COMMA you get an SQL error      *
  *                      if parameters in SQL delimited by       *
  *                      commas aren't separated from the comma  *
  *                      by a space.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to address this issue.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UQ77267

Modules/Macros

•    AUO$DPDS AUO$DPTB AUO#ACGN AUO#DTGN AUO#EFGN
  AUO#SFGN AUO#SRGN AUO#TBGN AUO@DSQL AUO@FRTV AUO@IODS AUO@IOTB
  AUO@RECV AUODSN1  AUOTERUN
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R130 PSY UQ77267

     UP03/06/07 P F306

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.