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.
To meet the work process
of multiple roles, the workbench provides
several approaches for creating SQL statements. You can create an
SQL statement in the SQL Query Builder by using any of the following
approaches:
- The File menu
- A
data project
- A physical
data model in a data design project