You can use a physical data model in a data design project to create
an SQL statement in the SQL editor.
The SQL editor supports any statement that can be run by the database
to which you are connected. The 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 editor 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 Statement on the
pop-up menu.
- In the New SQL Statement window, type a name for the statement.
- Under Edit using, click SQL editor.
- In the Statement template field, select
the template for the type of statement that you want to create. If you do
not want to use a template, select None. If you want
to see sample statements, select Sample statements.
- Click OK. The SQL statement is
added to the SQL Statements folder under the database
and opens in the SQL editor.
- Complete the SQL statement in the SQL editor.
- Close the SQL statement, and then save the physical data model. When you save the physical data model, you save all the data objects
in the physical data model that have outstanding changes.
- Close the physical data model.