Creating SQL statements in the SQL builder by using the File menu

You can use the File menu to create an SQL statement in the SQL builder.

The SQL builder supports creating SELECT, INSERT, UPDATE, DELETE, FULLSELECT, and WITH (DB2® only) statements. A statement that you create is stored in a file with the extension .sql.

To create an SQL statement in the SQL builder by using the File menu:

  1. Open the Data perspective.
  2. Click File > New > SQL Statement. The New SQL Statement wizard opens.
  3. Complete the New SQL Statement wizard and then click Finish. On the Statement Type page, leave the SQL builder option selected. The SQL statement is added to the SQL Scripts folder of the data development project that you select in the wizard. The statement opens in the SQL builder.
  4. Use the SQL builder to specify the type of statement that you selected in the wizard:
  5. Save the statement.
Related information
New SQL Statement wizard - Statement Type page
New SQL Statement wizard - Specify a Project page

Feedback