Create a data source

This example uses a DB2 database named MYSAMPLE. You need to manually create the MYSAMPLE database. To create the MYSAMPLE database, enter the following statements at the DB2 command prompt:

CREATE table db2e.MYACCOUNT ( Name char(16), Saving int, Checking int)
INSERT into db2e.MYACCOUNT values('Michael', 5000, 5000)
INSERT into db2e.MYACCOUNT values('Frank', 5000, 5000)
 

After creating the database, create a stored procedure to modify the data in the database.