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