Creating SQL statements in the SQL builder by using a data project

You can use the SQL Scripts folder in a data development project or a data design project 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.

Prerequisite: Before you create an SQL statement by using a data project, create a data development project or a data design project in the Data Project Explorer view.

To create an SQL statement in the SQL builder by using a data project:

  1. Open the Data perspective.
  2. In the Data Project Explorer view, expand the data development project or the data design project, right-click the SQL Scripts folder, and then click New > SQL Statement on the pop-up menu.
  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 project and 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 tasks
Creating a data development project
Creating a data design project
Related information
New SQL Statement wizard - Statement Type page
New SQL Statement wizard - Specify a Project page

Feedback