The GENERATE_SQL_OBJECTS procedure generates the SQL data definition language (DDL) statements required to recreate a set of database objects.
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
Was this topic helpful?
31 March 2023