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.