Creating a data development project

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:

  1. Switch to the Data perspective.
  2. On the main menu bar, click File > New > Project, 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.
  3. On the first page of the wizard, specify basic project information, then click Next.
  4. 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.
  5. 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.
Related reference
New Data Development Project wizard- Data Development Project page
New Data Development Project wizard - Specify z/OS Connection page
Related information
Overview of database connections

Feedback