A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix H - Rexx/SQL for Solid Server

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

General:

The username, password and database name arguments in SQLCONNECT are mandatory.
Examples of connections with SQLCONNECT:
The following connects to the Solid Server DSN REXXSQL with a username of scott and password of tiger.
rc = sqlconnect("MYCON","scott","tiger","REXXSQL")
The following connects to the Solid Server DSN REXXSQL with no username or password. The REXXSQL DSN must specify the username and password.
rc = sqlconnect("MYCON","","","REXXSQL")

Bind Variables:

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

Data types:

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

Return to Table of Contents
Last updated 10 October 2006