PQ61425: SQLCODE811 WHEN RUNNING AUO#LOAD, SQLCODE104 ILLEGAL SYMBOL WH-EN RESTORING A VIEW, AND MISPLACED QUOTATION MARKS IN TABLE DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. "Fixes a problem in generated restore DDL where quotation
  marks were incorrectly positioned around table names and/or
      column names that contained embedded  blanks/spaces within
      the name."
  2. Fixes SQLCODE811 that occurs in the TABAUTH jobstep of the
      repository load job.
  3. Fixed a problem in which a create VIEW statement which used
     an SQL terminator other than a semicolon was being rebuilt
     improperly by AUO.  Each create view statement is now precede
     with a "--#SET TERMINATOR #" statement to set the SQL
     terminator to a #.  The view description is then followed by
     another "--#    SET TERMINATOR ;"  to reset the current SQL
     terminator value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Object Restore Users                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. "Fixes a problem in generated        *
  *                         restore DDL where quotation marks    *
  *                         were incorrectly positioned around   *
  *                         table names and/or column names that *
  *                         contained embedded blanks/spaces     *
  *                         within the name."                    *
  *                      2. Fixes SQLCODE811 that occurs in the  *
  *                         TABAUTH jobstep of the repository    *
  *                         load job.                            *
  *                      3. Fixed a problem in which a create    *
  *                         VIEW statement which used an SQL     *
  *                         terminator other than a semicolon    *
  *                         was being rebuilt improperly by AUO. *
  *                         Each create view statement is now    *
  *                         precede   with a "--#SET TERMINATOR  *
  *                        " statement to set the SQL terminator *
  *                        to a #.  The view description is      *
  *                        then followed by another "--#         *
  *                        SET TERMINATOR ;" to reset the        *
  *                        current SQL terminator value.         *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code change have been made to correct these issuses.
  

Problem conclusion

• APPLY 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:

Modules/Macros

•    AUO#TAUL AUO#TBGN AUO#TVGN AUO@DSQL H23L120J
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R120 PSY UQ66745

     UP02/07/11 P F207

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.