Use the Generate Script wizard to generate queries, views, and
nickname objects that you can deploy on a database server.
Generate Script Options page
Use this page to select
the options to use to generate a script.
- Deployment platform
- Select the database model where you want to deploy the script. You can
deploy the script to the .dbm files that are used as sources in the mapping
model. A WebSphere® Information
Integrator database is a possible deployment platform if remote data sources
are used as sources in the mapping model.
- Query language
- Specify the query language for the generated script. You can create a
script in SQL or SQL/XML. However, if the target in the mapping model is an
.xsd file, then you can generate only an SQL/XML script.
- Query type
- Select the type of query that you want to generate. If the script is in
SQL, you can create a select statement, an insert statement, or a view statement.
If the script is in SQL/XML, then you can create only a select statement.
- Create fully qualified names
- Select the check box to include fully qualified names in the script.
- Script name
- Type a unique name for the script file that you want to generate. By default,
a script name is provided.
Schema and Nickname Options page
If the deployment
platform that you selected is a federated object, this wizard page shows the
remote tables, schemas, and nicknames of that object. You can modify the default
names for the schemas and nicknames.
- Remote table
- This field is read-only.
- Schema
- Type a schema name if you want to change the default name. The new schema
name replaces the default schema name when the schema is created in the tree
view of the Data Project Explorer.
- Nickname
- Type a new nickname if you want to change the default name. The new nickname
replaces the default nickname when the nickname is created in the tree view
of the Data Project Explorer.
Schema and View Options page
If you selected that
you want to create a view statement, this wizard page is displayed. You can
modify the default schema names and view names of the deployment platform.
- Schema
- Type a schema name if you want to change the default name. The new schema
name replaces the default schema name when the schema is created in the tree
view of the Data Project Explorer.
- View
- Type a view name if you want to change the default name. The new view
name replaces the default view name when the view is created in the tree view
of the Data Project Explorer.
Summary page
This page shows the script and the
generated remote objects in addition to the view objects that will be added
to the database model. Verify the script and the generated objects. To change
values, click Back, and modify the settings. When you are ready to
generate the script and add objects to the database model, click Finish.