Rexx/SQL

2.5 - Added SQLDataSource(), SQLTables() and SQLColumns(). Documentation and original ODBC implementation courtesy of Lorne Sunley. Not all of these functions completed on all platforms. tester.cmd changed to test these functions. - Rexx/SQL is now thread-safe. Thread-safety of a Rexx/SQL application is dependent now on whether the database client is thread-safe. Where it is known that the database client is thread-safe, the new Rexx/SQL variable; SUPPORTSTHREADS is set to 1. - Fixed bug with SQLCA.ROWCOUNT when calling SQLFETCH; it now sets the value as documented. - Updated documentation to state that SQLCA. stem is read-only; don't change values or DROP the variables. You have been warned! - Added support for SQLite and SQLite3. Support for placemarkers in SQLite3 is now supported. - Fixed bug with following sequence of calls: SQLPREPARE SQLOPEN SQLFETCH (in loop) SQLCLOSE SQLOPEN SQLFETCH (in loop) SQLCLOSE SQLDISPOSE Previously, the second SQLOPEN/SQLFETCH/SQLCLOSE sequence would not work on all database platforms. Added test in tester.cmd "fetch" to test this case. - Added MYGETINSERTID() fo MySQL to return the value generated for an AUTO_INCREMENT column as a result of the last INSERT or UPDATE statement. - Added LITE3GETINSERTID() for SQLite3 to return the last identifier from an INSERT of NULL into a column defined as INTEGER PRIMARY KEY. - Added support for Open Object Rexx. - Fixed bug with Oracle and SQLGETDATA. Now no longer crashes. - Added extra bind variable capability to Oracle bind by name. Allows LONG data to be bound from a Rexx variable or a file; similar to bind capability with standard placemarkers.