How to adjust DDL generation for a view without the column names listed when using RC/Query for Db2 for z/OS (RCQ).
Check member CDBAPARM(OFS) for variable GENERATE_COLUMN_NAMES_WITH_SELECT(*)
Y-Yes, To generate all the column names in a CREATE VIEW statement with select *
N-No, To suppress all the column names in a CREATE VIEW statement with select *
Example:
· 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.VIEW
;
· 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.VIEW
;