A Data Design Project is a container for storing the resources
that you will use to plan, analyze, archive, and make changes to your databases.
Projects are displayed in the Data Project Explorer view,
and they correspond to directories in the file system.
The resources that you will use to make database changes include models
and scripts. When you create a project, the following virtual subfolders are
displayed within the project to organize the following resources:
- Data Diagrams folder
- Holds the diagram files for your base and target models.
- Data Models folder
- Holds the models. Models have a file extension of .dbm.
- SQL Scripts folder
- Holds the types of script files that are shown in the following table:
Table 1. Types of scripts in the SQL scripts folderType of script |
File extension |
Description |
Change command script |
chx |
Can contain SQL statements, DB2 commands, and utility
invocations. These scripts can be used to make or undo changes to a database,
such as change the structure of a database (DDL), change the data in the database
(EXPORT, IMPORT, and DML), modify the database packages (REBIND), or run statistics. |
Deployment script |
deployxml |
Contains a set of changes to make to a database. The
deployment script brings together the specification resources (models), change
commands, and metadata about the change and organizes them into a coherent
form. |
SQL script |
sql
ddl
|
Contains SQL statements. |
You can select
Run SQL by right-clicking
a script in the
Data Project Explorer. The run options
that are available, depend on the file extension of the script. The following
list describes the available options:
- The Run SQL option is available for scripts that
contain commands that are specific to DB2® Change Management Expert.
Those scripts will have a .chx extension.
- The Run SQL option never appears for deployment
scripts with a .deployxml file extension, as those commands are issued through
the Deploy wizard.
- The Run SQL option is available for other files
in the scripts folder that only contain commands that can be deployed through
a JDBC. For example, DDL, DCL, and DML commands. These scrpits typically have
a .ddl or .sql file extension.
- Other Files folder
- Holds the files that do not belong in either the SQL Scripts or Data Models
folders. For example, the deployment log files with a file extension .log,
are placed in this folder.
The following figure shows an example of a project with its resources:
Figure 1. Example of a project in the Data Project Explorer
view
A project must exist before you can use any of the other functionality
in DB2 Change Management Expert. Some
functions in DB2 Change Management Expert will
create a project if one does not already exist. For example, when you create
a deployment script, you can specify that a project be created for you. You
can also create a project explicitly.