A Rexx interface to SQL databases

Version 2.5

10 October 2006

Appendix B - Rexx/SQL for mSQL

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


Bind Variables:

mSQL has no provision for bind variables in SQL statements. The return value from SQLVARIABLE('SUPPORTSPLACEMARKERS') is always 0, so any references to bind variables in this document should be ignored for mSQL.

Column names:

If a column specification in a SQL statement passed to SQLCOMMAND or SQLPREPARE contains a table alias, eg. a.emp_id, the Rexx variables created corresponding to this column DO NOT contain the "a." prefix.

SQLDESCRIBE variables:

The mSQL implementation includes the extra variable component; PRIMARYKEY.

Copyright © Mark Hessling 1997-2006 <>

Return to Table of Contents
Last updated 10 October 2006