You can use a database connection in the Database Explorer view
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.
Prerequisites: Before
you create an SQL statement by using a database connection:
- Define a database connection in the Database Explorer view.
- If you plan to save the SQL statement, create the project in which to
store the statement.
Restriction: - If you want to reopen the SQL statement in the SQL builder or the SQL
editor, save the statement in a data development project or
a data design project.
- If you save the SQL statement in a data development project, the project
must be associated with a database that contains the database tables that
you use in the statement. Otherwise, you cannot run the statement successfully.