A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix D - Rexx/SQL for Sybase System 10/11

This port would not have been possible without the support of Pieter Leemeijer, Sybase, Brisbane and Chuck Moore, DIS, Washington State.

The documentation for this port is incomplete; as is the code!

General:

The Sybase port uses the Sybase Open Client Client-Library/C API, which is unique to Sybase.

• The username, password and database name arguments in SQLCONNECT are mandatory.

• Example of a connection with SQLCONNECT:

  The following connects to the SADEMO database running on the local machine with a connection name of MYCON and a username of dba and password of sql.

  rc = sqlconnect("MYCON","dba","sql","SADEMO")

  
  

Bind Variables:

Sybase System 10/11 uses the standard placemarker; ?. See 7. Standard placemarkers and bind variables for further details.

Data types:

The datatypes supported by Sybase System 10/11 can be determined by a call to SQLGETINFO with the DATATYPES option.