Rexx/SQL

A Rexx interface to SQL databases

Version 2.5

10 October 2006

5. Implementation Notes

To enable multiple database access on those platforms that support the dynamic loading of Rexx external functions, implementation-specific function names and status values should be provided as a compile-time option. It is expected that a separately built library be provided with the standard function names together with the a library containing the database platform-specific functions and status values.

For example, the Win32 Oracle implementation provides a dynamic library called REXXSQL.DLL which contains the standard function names like SQLCONNECT and standard status values like SQLCA.SQLCODE. It also provides an implementation-specific dynamic library called REXXORA.DLL with an equivalent ORACONNECT and ORACA.SQLCODE. This use of standard and implementation specific names also applies to default statement names and stem variable names. Basically, wherever the string SQL appears in function names or Rexx variables names, an implementation specific abbreviation will be used.

This provision of database platform specific external functions will enable access to different vendor databases in the one Rexx program.

The following database-specific abbreviations are used or recommended:

Copyright © Mark Hessling 1997-2006 <mark@rexx.org>

Return to Table of Contents
Last updated 10 October 2006