Working with SQL statements
in the SQL Query Builder
You can create,
edit, and run SQL statements by using the SQL Query Builder.
You can also create, edit, and run both SQL and
XQuery statements by using the SQL and XQuery editor.
SQL statement creation in the SQL Query Builder
You
can create an SQL statement by using the SQL Query Builder
in the Data perspective. The SQL Query Builder supports creating SELECT,
INSERT, UPDATE, DELETE, FULLSELECT, and WITH (DB2® only)
statements.
SQL statement specification in the SQL Query Builder
When
you use the New SQL or XQuery Script wizard or window to create
an SQL statement, the statement contains the template code for the
statement
type that you select. After you create the SQL statement, you can
specify
the statement by providing the information for its clauses in the
SQL Query Builder.