A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix C - Rexx/SQL for DB2

This section describes features of Rexx/SQL specific to the DB2 implementation.


The DB2 port uses the Call Level Interface (CLI) provided by DB2. This CLI is based on the X/Open CLI and is very similar to the ODBC API.

Bind Variables:

DB2 uses the standard placemarker; ?. See 7. Standard placemarkers and bind variables for further details.

Data types:

The datatypes supported by DB2 can be determined by a call to SQLGETINFO with the DATATYPES option.

Copyright © Mark Hessling 1997-2006 <>

Return to Table of Contents
Last updated 10 October 2006