You can create, edit, and run SQL statements by using the SQL builder
and 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 Statement 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.