NO KEY LABEL statement generated for some objects after RC/Query upgrade
search cancel

NO KEY LABEL statement generated for some objects after RC/Query upgrade

book

Article ID: 280915

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

Why is the NO KEY LABEL DDL statement generated for some objects after upgrade on release r20?

Resolution

KEY LABEL clause support was introduced on r20.

RC/Query can generate DDL that contains the KEY LABEL or NO KEY LABEL clauses in the following CREATE and ALTER statements on Db2 subsystems running at Db2 12 function level M502 (V12R1M502):

CREATE STOGROUP
CREATE TABLE
ALTER STOGROUP
ALTER TABLE

Additional Information

Further documentation regarding this new feature can be found here.