IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1


Using the remote query and stored procedure adapter in an application

The remote query and stored procedure adapter enables some unique capabilities of the DB2 Everyplace database engine. The following sections detail the requirements and techniques for using the remote query and stored procedure adapter in a DB2 Everyplace application.

Passing parameters

DB2 Everyplace supports calling stored procedures on a remote DB2 server through the CLI 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.

Using the result set

Result sets are a useful way to retrieve data from a stored procedure. If a client application runs a stored procedure that generates a result set, it can then use the regular CLI functions such as SQLFetch() and SQLGetData() to retrieve the data. DB2 Everyplace does not support multiple result sets.

Current limitations

Supported platforms

The remote query and stored procedure adapter supports the Win32 and Palm OS client platforms. The remote query and stored procedure adapter requires that the stored procedures are registered to DB2.

Programming tips


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]