Generate SQL for database objects
- In the System i Navigator window, expand the system you want to use.
- Expand Databases and Schemas.
- To generate SQL for a schema, right-click on the schema and select
Generate SQL.
- To generate SQL for an object contained within a schema, click
on the schema that contains the object that you want to generate the SQL
for.
- Right-click the object you want to generate the SQL for and select Generate SQL.
On the Generate SQL dialog, you can:
Add or remove list objects
Change the default options for:
Output options
SQL options
Format options
You can do these tasks in any order.
Once you are satisfied with these options, click Generate.