The SQL builder supports creating SELECT, INSERT, UPDATE, DELETE, FULLSELECT, and WITH (DB2® only) statements. A statement that you create is stored in the physical data model (.dbm) file.
Prerequisite: Before you create an SQL statement by using a physical data model, create a physical data model in a data design project in the Data Project Explorer view.
To create an SQL statement in the SQL builder by using a physical data model: