You can create, edit, and run SQL statements by using the SQL builder.
You can also create, edit, and run both SQL and XQuery statements by using
the SQL editor.
SQL statement creation in the SQL builder
You can create an SQL statement by using the SQL builder in the
Data perspective. The SQL builder supports creating SELECT, INSERT, UPDATE,
DELETE, FULLSELECT, and WITH (DB2® only) statements.
SQL statement specification in the SQL 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 builder.
Copying SQL statements
You can copy SQL statements from one data project to another data
project.
Using Visual Explain for SQL statements
You can use Visual Explain to view explained SQL statements as
a graph. You can use the information available from the graph to tune your
SQL queries for better performance. The nodes in the graph represent tables
and indexes and each operation on them. The links between the nodes represent
the flow of data.