Before you begin
In the scenario, user ID db2admin is used. Ask your
database administrator for the user ID and password, and use these values for the
userID and password variables. The user must have suitable
permissions to read and create a stored procedure in the relevant database schema.
About this task
Connect information is stored in a database definition
(.dbm) file.
Procedure
- Open the IBM Integration Toolkit and
click the Data Source Explorer view.
- Right-click CLIENTS, and then select Connect. If the CLIENTS database is not listed, proceed as follows:
- Right-click Database Connections, and then
click New.
- Set the database manager to DB2 for Linux, UNIX, and
Windows.
- Set the Database to CLIENTS.
- To set up the connection to the database, complete the
following fields:
- Type db2admin as the User name.
- Type the user password in Password.
- Select Save password.
- Click Test Connection.
- If the connection succeeded, click Finish.
Results
You are now connected to the CLIENTS database. Expand the CLIENTS database to view the
schemas. Expand the ADDRESSBOOK schema, and then Stored Procedures. You should see a stored
procedure that is named EMPLOYEEDETAILS.
What to do next
Follow the steps in Creating a data development project.
Tip: Database definition files are not automatically updated.
If you modify your database, you must re-create the database definition
file that describes the connection to the database.