You can use the SQL Scripts folder
in a data project to create an SQL statement in the SQL Query Builder.
Before you begin
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.
Prerequisite: Before
you create an SQL statement by using a data project, create a data
project in the Data Project Explorer view.
About this task
To
create an SQL statement in the SQL Query Builder by using
a data project:
- Open the Data perspective.
- In the Data Project Explorer view, expand the data
project,
right-click the SQL Scripts folder, and then
click on the pop-up menu.
- Complete the New SQL or XQuery Script wizard, clicking SQL
Query
Builder and selecting a statement type.
- Click Finish. The
SQL statement is added to the SQL Scripts folder
of the data project and opens in the SQL Query Builder.
- Use the SQL Query Builder to specify the type of
statement that
you selected in the wizard:
- Save the statement.