Creating a data source using the sample application

This example uses a DB2 database named MYSAMPLE. You need to manually create the MYSAMPLE database.

Procedure

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.

Related concepts

• The remote query and stored procedure adapter

Related tasks

• Creating an AgentAdapter subscription
• Creating the Agent Adapter subscription for the sample application
• Creating an application using the remote query and stored procedure adapter

Related reference

• Sample application code
• Creating a stored procedure using the sample application
• Creating a DB2 Everyplace application
• Supported data types for stored procedures
• CLI functions and restrictions for result sets