Supported data types for stored procedures

DB2 Everyplace supports calling stored procedures on a remote DB2 server through the CLI or JDBC interface. The client application uses the CALL statement to run the remote stored procedure. The CALL statement names the procedure to be called and specifies its parameters. The following types are supported: INTEGER, SMALLINT, DECIMAL, CHAR, VARCHAR, DATE, TIME, TIMESTAMP and BLOB.

Related concepts

• The remote query and stored procedure adapter

Related tasks

• 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
• CLI functions and restrictions for result sets