News
Abstract
The GENERATE_SQL procedure generates the SQL data definition language statements required to recreate a database object.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > QSYS2.GENERATE_SQL() procedure
The GENERATE_SQL procedure generates the SQL data definition language statements required to recreate a database object. The results are returned in the specified database source file member or as a result set.
See the procedure definition for details: GENERATE_SQL procedure
- Generate DDL to tune the System Limits pruning variable:
CALL QSYS2.GENERATE_SQL ('QIBM_SYSTEM_LIMITS_PRUNE_BY_OBJECT', 'SYSIBMADM', 'VARIABLE',
REPLACE_OPTION => '0',
CREATE_OR_REPLACE_OPTION => '1');
Figure 1. Generate_SQL() example output:
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]
Document Information
Modified date:
15 January 2020
UID
ibm11164760