Generate the SQL for only selected objects in a map

When you generate the SQL statements for selected 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 selected 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. Click the objects in the map for which you want to display the SQL that was used to create the object.
  6. From the Map menu, select Generate SQL, then select Selected Objects.

Tips: