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)
Release : 20.0
Component : RC/Compare for DB2 for z/OS
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.
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 ;