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.
Before you create an SQL statement by using
a data project, create a data project in the Data Project Explorer
view.
Procedure
To create an SQL statement in the SQL Query Builder by
using a data project:
- 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.