Introduction:
RC/Query DDL line command for a VIEW generate a row for each column name which make the listing for large objects unnecessarily big.
Question:
How to get rid of the column names listing in a DDL generation? Which settings are necessary therefore?
Answer:
There exists two CDBAPARM library members (ENABLExx and OFS) which need to be configured therefore.
Please have a look at the following examples and find out, what settings match for your using:
· CDBAPARM(ENABLExx): (RCQ_OFS(YES)) and CDBAPARM(OFS) : GENERATE_COLUMN_NAMES_WITH_SELECT(*) (N)
The ddl is generated by OFS and columns names are suppressed.
.CONNECT SSID
SET CURRENT SQLID = 'USER10';
SET PATH = "SYSIBM","SYSFUN","SYSPROC","USER04";
CREATE VIEW CREATOR.VIEW AS
SELECT * FROM CREATOR.TABLE
;
· CDBAPARM( ENABLExx): (RCQ_OFS(YES)) and CDBAPARM(OFS) : GENERATE_COLUMN_NAMES_WITH_SELECT(*) (Y)
The ddl is generated by OFS and columns names are not suppressed.
.CONNECT SSID
SET CURRENT SQLID = 'USER10';
SET PATH = "SYSIBM","SYSFUN","SYSPROC","USER04"
CREATE VIEW CREATOR.VIEW
( COL1
, COL2
) AS
SELECT * FROM CREATOR.TABLE
;
· CDBAPARM(ENABLEXX) : (RCQ_OFS(NO))
The DDL is generated by LEGACY
.CONNECT SSID
SET CURRENT SQLID ='USER10';
CREATE VIEW CREATOR.VIEW ( COL1 , COL2 ) AS SELECT * FROM
CREATOR.TABLE ;