10 October 2006
The following connects to the TEST database running on the local machine with a connection name of MYCON.
rc = sqlconnect("MYCON",,,"TEST")
rc = sqlconnect(,,,"MINERVA","xyz.my.org")
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.
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.
The mSQL implementation includes the extra variable component; PRIMARYKEY.