suppress column names in a view for ddl command

book

Article ID: 38241

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

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 ;                                  

 

 

 

 

Environment

Release:
Component: RCQ