Creating SQL statements in the SQL Query Builder by using the File menu

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

The SQL Query 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 Query Builder by using the File menu:

  1. Open the Data perspective.
  2. Click File > New > Other.
  3. In the New wizard, expand Data, select SQL or XQuery Script and then click Finish.
  4. Complete the New SQL or XQuery Script wizard, clicking SQL Query Builder and selecting a statement type.
  5. Click Finish. 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 Query Builder.
  6. Use the SQL Query Builder to specify the type of statement that you selected in the wizard:
  7. Save the statement.

Feedback