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.

  1. Select the Options tab on the Generate SQL dialog.
  2. Select the standard that the generated SQL will conform to.
  3. Select Generate labels for the generated SQL if you want comments and labels to be inserted into the SQL statements.
  4. Select Format statements for readability if you want to format the generated SQL using end-of-line characters, tab characters, and spaces.
  5. 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.
  6. 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.