Generate the SQL for the visible objects only

When you generate the SQL statements for only the visible 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 the visible objects in the map only:

  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, select Generate SQL, then select Visible Objects.

Tips: