When using the RC/Query DDL command for a trigger defined as 'NOT SECURED', the 'NOT SECURED' clause is missing from the generated DDL.
CREATE TRIGGER trigger-name
NO CASCADE BEFORE INSERT
NEW AS N
FOR EACH ROW MODE DB2SQL
Why is the 'NOT SECURED' clause not generated?
Release : 20.0
Component : CA RC/Query for DB2 for z/OS
If the GENERATE_DEFAULT_CLAUSES_IN_CREATE parameter is set to (N) in the OFS member of CDBAPARM, then default clauses in the CREATE DDL will be suppressed.
'NOT SECURED' is a default clause and so will not be generated in the DDL if this parameter is set to (N).
If you wish to generate default clauses then you need to change this parameter to (Y). This affects DDL generated by both the DDL and HDDL commands.
Further information on the OFS Parmlib member parameters can be found here.