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.
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 builder by using any of the following approaches:
- The File menu
- A data project; that is, a data development project or
a data design project
- A physical data model in a data design project
- A database connection