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.
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.
About this task
To create an SQL statement in the SQL Query Builder by
using a physical
data model:
- Open the Data perspective.
- 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.