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.
About this task
To create an SQL statement
in the SQL Query Builder by
using the File menu:
- Open the Data perspective.
- 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.