DDL command on a View generates different results based on the release of the product

Document ID : KB000056672
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In r15, issuing the DDL command on a View results in the following:

CREATE VIEW GCAPV.VENTTAB1 AS SELECT * FROM GCAP.TENTTAB ;

In r17, issuing the DDL command on a View results in the following:

CREATE VIEW GCATA.VENTTAB1 
        ( NOM_TABLE_PARAM  
        , COD_ENTRE_TABLE  
        , DAT_DEBUT_EFFECT 
        , DAT_FIN_EFFECT   
        , VAL_ENTRE_TABLE  
        , SYS_RESP_TABLE   
        , MOT_PASSE        

        ) AS                     
SELECT * FROM GCATA.TENTTAB      
;      

 

Resolution:

This difference is caused by the setting of the RCQ_OFS parameter as defined in the hilvl.CDBAPARM dataset in the ENABLExx member.    

If the setting is RCQ_OFS(NO) then you will get the following DDL: 
CREATE VIEW GCAPV.VENTTAB1 AS SELECT * FROM GCAP.TENTTAB ;         

If the setting is RCQ_OFS(YES) then you will get the following DDL:  

CREATE VIEW GCATA.VENTTAB1 
        ( NOM_TABLE_PARAM  
        , COD_ENTRE_TABLE  
        , DAT_DEBUT_EFFECT 
        , DAT_FIN_EFFECT   
        , VAL_ENTRE_TABLE  
        , SYS_RESP_TABLE   
        , MOT_PASSE        

        ) AS                     
SELECT * FROM GCATA.TENTTAB      
;