You can use the File menu 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.
Procedure
To create an SQL statement in the SQL Query Builder by
using the File menu:
- Click .
- In the New wizard, expand Data,
select SQL or XQuery Script and then click Finish.
- 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 development project that you select in the wizard. The
statement 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.