Generate Script wizard

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.


Feedback