Automap fails with RCM00043: SQL error Db2 V12 DDL00002: Invalid token
search cancel

Automap fails with RCM00043: SQL error Db2 V12 DDL00002: Invalid token

book

Article ID: 199692

calendar_today

Updated On: 12-29-2024

Products

RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite RC/Migrator for DB2 for z/OS

Issue/Introduction

RC Compare Automap process failed with RCM00043: SQL errors found in import dataset:
DDL00002: Invalid token NO.  Valid tokens are:                           
            IN  EDITPROC  VALIDPROC  AUDIT  OBID                           
            DATA  RESTRICT  CCSID  NOT  VOLATILE                           
            PARTITION  APPEND                  

or

DDL00002: Invalid token KEY.  Valid tokens are:
        IN  EDITPROC  VALIDPROC  AUDIT  OBID
        DATA  WITH  CCSID  NOT  VOLATILE
        PARTITION  APPEND  LOGGED  DSSIZE         

On - DB2 V12    SSIDVERF (V12R1M500) 

 

 

Environment

Release : 20.0

Component : RC/Compare for DB2 for z/OS

Cause

The DDL contains a DB2 function regarding KEY LABELS that is available at a minimum from  DB2 V12R1M502 where this problem is seen on a V12R1M500 system. 

Resolution

This error is due to the SSIDVERF of the target subsystem. It must be a minimum of V12R1M502 and above for support of Key Label.  

The DDL contains a NO KEY LABEL statement or a KEY LABEL "YOUR.TEST.KEY" statement. 

    CREATE TABLE AUTHID.KEYLABEL
        (COL01 SMALLINT WITH DEFAULT NULL
        ,COL02 SMALLINT WITH DEFAULT NULL
        ,COL03_CLOB CLOB(100) FOR MIXED DATA
        INLINE LENGTH 0 WITH DEFAULT NULL
        )
        IN KEYLABEL.KEYLABEL
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE NONE
   AUDIT NONE
   CCSID EBCDIC
   PARTITION BY RANGE
        (COL01 NULLS LAST ASC)
        ( PARTITION 1 ENDING (MAXVALUE) INCLUSIVE )
   NO KEY LABEL ;

 

Additional Information