You can use a physical data model in a data design project
to create an SQL statement in the SQL Query Builder.
Before you begin
The SQL Query 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.
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.
Procedure
To create an SQL statement in the SQL Query Builder by
using a physical data model:
- In the Data Project Explorer view, expand a data design
project, and then double-click the physical data model to open it.
- In the Data Project Explorer view, expand the physical
data model, and then expand the database.
- Right-click the SQL Statements folder
under the database, and then click New SQL or XQuery Script on
the pop-up menu.
- In the New SQL or XQuery Script window, type a name for
the statement.
- Click SQL Query Builder.
- Select the type of statement that you want to create.
- Click OK. The SQL statement
is added to the SQL Statements folder under
the database and opens in the SQL Query Builder.
- Use the SQL Query Builder to specify the type of statement
that you selected in the New SQL Statement window:
- To save the SQL statement, save the physical data model
(.dbm) file. When you save the physical data model, you
save all the data objects in the physical data model that have outstanding
changes.