PK31042: SQLCODE199 DSNT408I SQLCODE -199 ILLEGAL USE OF KEYWORD SQLCODEN199 SQLCODE199N BAD SYNTAX MISSING SEMICOLON

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User does Object Compare beween catalog and a DDL file where the
  only difference is a comment on two tables. In the DDL file
  generated for CREATE there is a missing semicolon after the
  COMMENT statement which leads to sqlcode199 ( sqlcode -199
  sqlcoden199 sqlcode199n ) at execution time.
  SQLERROR ON COMMENT    COMMAND, PREPARE    FUNCTION
   DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD COMMIT.
                       TOKEN <END-OF-STATEMENT> WAS EXPECTED
   DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = 506  0  0  -1  72  0 SQL DIAGNOSTIC
                         INFORMATION
   DSNT416I SQLERRD    = X'000001FA'  X'00000000'  X'00000000'
                         X'FFFFFFFF'  X'00000048'  X'00000000'
                         SQL DIAGNOSTIC INFORMATION
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 run Object Compare between Catalog and a     *
  *                 DDL file, may be affected.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running  Object Compare  beween catalog *
  *                      and a DDL file with the only difference *
  *                      being  a   comment  on  two  tables,  a *
  *                      missing  semicolon  after  the  COMMENT *
  *                      statement  occurred  in  the  DDL  file *
  *                      generated  for  CREATE,  which  led  to *
  *                      SQLCODE -199 at execution time.         *
  *                      .*                                      *
  *                      Compare  runs  and  completes rc=04 and *
  *                      then generated CREATE job runs  to give *
  *                      the error of RC=8 and message ADBT144I. *
  *                      .*                                      *
  *                      Delimiter was not  added to the end of  *
  *                      the  statement when length of the line  *
  *                      is more than 70 characters.             *
  *                      .*                                      *
  *                      Additional fixes for:                   *
  *                      * Foreign  Key  is  not  being dropped  *
  *                        from the  Target when  SUPPRESS DROP  *
  *                        OF  OBJECT  is  set  to  "YES",  and  *
  *                        Source  does  not  have  any Foreign  *
  *                        Key. The problem  is that table name  *
  *                        and  reftable  were  taken  from the  *
  *                        source RL record, which in this case  *
  *                        simply doesn't exist. Table name and  *
  *                        Reftable  name  should be taken from  *
  *                        the target.                           *
  *                      * Garbage  added  to  the Changes file  *
  *                        when compare indexes with long names. *
  *                      * Truncated long STOGROUP name.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK18812

     UP06/10/19 P F610

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.