PK99733: GEN COMMAND TRIGGER ISSUES MESSAGE SYNTAX ERROR IN INSERT STATEMENT ADB1847E WARNINGTOKEN REASON CODE = 28 TOKEN = (

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function issues a
  message:
  Syntax error in INSERT statement
  Error occured when parsing the following stmt :
  CREATE TRIGGER...
  ADB1847E WARNING : Error parsing DDL TRIGGER statement. Please
  verify the generated DDL
  Reason code = 28
  Token number =     nn, Token = (
  The DDL for the CREATE TRIGGER is present.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS who use qualified column            *
  *                 references in a column list of an            *
  *                 INSERT statement.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error occurred when            *
  *                      parsing a DDL statement that            *
  *                      contained a qualified column            *
  *                      reference in an INSERT                  *
  *                      statement:                              *
  *                        Syntax error in INSERT                *
  *                      statement                               *
  *                                                              *
  *                      e.g.                                    *
  *                      CREATE TRIGGER TRIGGER1                 *
  *                        AFTER INSERT ON                       *
  *                           QUAL1.TABLE1                       *
  *                        FOR EACH STATEMENT                    *
  *                        MODE DB2SQL                           *
  *                          BEGIN ATOMIC                        *
  *                          INSERT INTO                         *
  *                          QUAL2.TABLE2                        *
  *                           (QUAL2.TABLE2.COL1)                *
  *                            VALUES(1) ;                       *
  *                          END ?                               *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not correctly parse the qualified
  column reference.
  

Problem conclusion

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

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK55638

     UP10/03/31 P F003

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.