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 Data Source 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:
| 
|
| SQL scripts |
|
|
|
| DB2 and Derby stored procedures |
|
|
|
| DB2 user-defined functions |
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 specified for the project to help you develop objects that are targeted for that specific database.
To create a Data Development project, follow these steps:
| In the Data perspective, Data Project Explorer, select File Æ New Æ Data Development Project (alternatively right-click in the Data Project Explorer and select New Æ Data Development Project). Click Next. |
|
| In the New Data Development Project page of the wizard, type RAD75DataDevelopment for the project name. Clear Omit current schema in generated SQL Statements. Click Next. |
|
| In the Select Connection page, select ITSOBANKderby from the connections list (Figure | 1-6). |
Figure 11-6 Data Development Project: Select Connection
|
| Click Finish. The data development project is displayed in the Data Project Explorer view. |
|
ibm.com/redbooks |