PI73723: DB2 OBJECT COMPARISON TOOL - LONG VARCHAR/LONGVAR DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD LONG.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When comparing tables where the source table has a column type
  LONG VARCHAR and the same column in the target is VARCHAR the
  resulting ALTER TABLE contains:
     ALTER TABLE TOTXDBA0.OITB810
       ALTER MUTATIE_INHOUD SET DATA TYPE LONG VARCHAR;
  
  ALTER TABLE does not support  DATA TYPE LONG VARCHAR, the
  following error occurs:
     sqlerror on ALTER      command, PREPARE function
     DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD LONG.
            TOKEN SMALLINT, INT(EGER), DEC(IMAL), FLOAT, VARCHAR,
            CHAR(ACTER), ... WAS EXPECTED
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool          *
  *                 for z/OS who compare tables where the        *
  *                 source table has a column with LONG          *
  *                 VARCHAR type and target has the same         *
  *                 column with VARCHAR type.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ALTER TABLE statement is             *
  *                      generated to alter a column to          *
  *                      LONG VARCHAR and causes                 *
  *                      a SQLCODE=-199 / SQLCODEN199.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing two tables, an ALTER TABLE statement to Alter
  a column type to LONG VARCHAR is generated, Compare reports:
  
    Column >column name<
      (A)Type changed from VARCHAR(nnnn) to LONG VARCHAR.
  
  ALTER TABLE does not support DATA TYPE LONG VARCHAR
  
  Running the generated WSL, a SQLCODE=-199 / SQLCODEN199 is
  observed:
  
   DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD LONG.
           TOKEN SMALLINT, INT(EGER), DEC(IMAL), FLOAT, VARCHAR,
           CHAR(ACTER), ... WAS EXPECTED
  

Problem conclusion

• Problem has been solved. The target column will not be altered.
  

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:

  UI47477 UI47478 UI47479

Modules/Macros

•    ADB2CMT  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI47477

     UP17/05/25 P F705

• RB20 PSY UI47478

     UP17/05/25 P F705

• RC10 PSY UI47479

     UP17/05/25 P F705

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.