A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix E - Rexx/SQL for Sybase SQLAnyWhere

This port would not have been possible without the support of Pieter Leemeijer, Sybase, Brisbane.

General:

The Sybase SQLAnyWhere port uses the ODBC API.

• 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 SQLAnyWhere uses the standard placemarker; ?. See 7. Standard placemarkers and bind variables for further details.

Data types:

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