A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix F - Rexx/SQL for ODBC and UDBC

General:

• The arguments to SQLCONNECT can be in one of two different combinations:
  1. username, password and database name must all be supplied
  2. Only host supplied. host in an ODBC connection is actually a connect string which takes the form of a number of keyword/value pairs
  otherwise you will get an error -76: <connect string> must be only argument. The contents of a connect string are dependent on the ODBC driver and/or database.
  The username and password arguments are required if you have not set these values when you created your Data Source Name(DSN) using ODBC Manager.
  The database name argument is the DSN name you specified when you created your DSN using ODBC Manager.

• Examples of connections with SQLCONNECT:

  The following connects to the ODBC/UDBC DSN REXXSQL with a username of scott and password of tiger.

  rc = sqlconnect( "MYCON", "scott", "tiger", "REXXSQL" )

  
  

  The following connects to the ODBC/UDBC DSN REXXSQL with no username or password. The REXXSQL DSN must specify the username and password.

  rc = sqlconnect( "MYCON", , , "REXXSQL" )

  
  

  The following connects to the ODBC/UDBC database with a connect string only

  connect_string = "Driver={SQL Server};Server=MyServer;db=pubs;uid=scott;pwd=tiger" rc = sqlconnect( "MYCON", , , , connect_string )

  
  

Bind Variables:

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

Data types:

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

Known errors:

• The Win95/NT ODBC 3.0 drivers sometimes return inconsistent results for queries.
• The Win95/NT Access driver always returns 1 for the nullable column when a statement is described.