Before you create routines or other database development objects,
create a data development project to store your objects. A data development
project is linked to one database connection in the Database Explorer.
A data development project is used to store routines and queries.
You can store and develop the following types of objects in a database development
project:
- DB2® and
Derby stored procedures
- DB2 user-defined
functions
- SQL scripts
You can also test, debug, export, and deploy these objects from a data
development project. The wizards that are available in a data development
project use the connection information that is specified for the project to
help you develop objects that are targeted for that specific database.
Using
the New Data Development Project wizard, you specify basic information about
the project including the name and current schema. You also specify which
database connection to use for the project. You can use an existing connection
or create a new connection.
To create a data development project:
- Switch to the Data perspective.
- On the main menu bar, click , then
expand the Data node and click Data Development
Project. If you do not see the Data node
or the Data Development Project option,
click Show All Wizards. The New Data
Development Project wizard opens.
- On the first page of the wizard, specify basic project information,
then click Next.
- On the second page of the wizard, specify a database connection
to link to the project. You can select an existing connection from
the list, or select Create new connection to create
a new database connection. If you select the option to create a new connection
then you must specify connection and filtering information on the next two
pages of the wizard. If you choose to connect to a DB2 UDB for z/OS® and OS/390® or DB2 for z/OS database, you must specify additional
options in the wizard.
- Click Finish. The data
development project is displayed in the Data Project Explorer view.
If the database connection that you specified for your project is
deleted from the Database Explorer or becomes disconnected, you will be prompted
to reconnect before you can create or modify objects in your data development
project.