Choosing SQL options
To choose from different standards options for the generated SQL, you must be on the
Generate SQL dialog. This task is described in
Generate SQL for database objects.
- Select the Options tab on the Generate SQL dialog.
- Select the standard that the
generated SQL will conform to.
- Select Generate labels for the generated SQL if you want comments and labels
to be inserted into the SQL statements.
- Select Format statements for readability if you want to format the
generated SQL using end-of-line characters, tab characters, and spaces.
- Select Include informational messages if you
want to include information about the generated SQL related to the object that you are creating.
This is especially important when you are generating SQL for an object originally created
using DDS.
- Select Include drop statements if you want to include
the SQL to drop the object before you create it.
Note: If you have chosen a standards option other than DB2 family with extensions,
you may get an error message telling you that your format options are
not compatible with your standard choice. You will have to edit your format options on
the Format tab or select a different standard. For more information,
see
Formats supported by the standards.
You have now chosen the options for the generated SQL.
Next, you can change the default values for:
Output options
Format options
You can do these tasks in any order. Additionally, you can:
Add or remove list objects
Once you are satisfied with these options, click Generate.