News
Abstract
GENERATE_SQL_OBJECTS procedure
The GENERATE_SQL_OBJECTS procedure generates the SQL data definition language (DDL) statements required to recreate a set of database objects.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.GENERATE_SQL_OBJECTS procedure
See the IBM Documentation for details: GENERATE_SQL_OBJECTS procedure
Enhanced with IBM i 7.5 SF99950 Level 1 and IBM i 7.4 SF99704 Level 20:
- When a view or MQT references a table or view in its definition that has a long name, generate the long name in the DDL
- New option to generate the system object text as a COMMENT statement
Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:
- Add the ability to generate into an IFS stream file
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
31 March 2023
UID
ibm11118355