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:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Click Database Navigator Maps.
- Double-click the map that you want to work with.
- Right-click in the map window, select Generate SQL, then select Visible Objects.
Tips:
- You can also right-click on an object in the Locator pane to generate the SQL.
- When you generate SQL, the default is to open the
generated SQL in the Run SQL Scripts window. If
you want to specify additional criteria before generating the SQL, you can
set the preference to open the Generate SQL
dialog, which also allows you to determine where you want to save the
generated SQL. To change the preference, select User
Preferences from the Options menu, then
select Show properties dialog for generate
SQL.