Generate the SQL for all objects in the map

When you generate the SQL statements for all objects in the map, the statements appear in a Run SQL Scripts window. The statements sent are delimited with semicolons and have a blank line separating them for readability. The statements in the Run SQL Scripts window can be saved to a PC file.

To show the SQL for all the objects in a map:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Click Database Navigator Maps.
  4. Double-click the map that you want to work with.
  5. Right-click in the map window, and select Generate SQL, then select All Objects.

Tips: