Generate SQL for an object in the map
To generate SQL for an object in a map:
- 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 change.
- Right-click on an object in the map and
select Generate SQL.
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.