Generate SQL for database objects

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and Schemas.
  3. To generate SQL for a schema, right-click on the schema and select Generate SQL.
  4. 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.
  5. 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.