Rexx/SQL

Version:

2.5

Release date:

Monday, 16 October, 2006

Home:

http://rexxsql.sourceforge.net/index.html

Categories:

License:

GPL

Interface:

PMShell
Workplace Shell
VIO

Italiano

Authors/Port authors:

Mark Hessling

Rexx/SQL provides Rexx programmers with a consistent, simple, yet powerful interface to SQL databases. Multiple connections to different databases from different vendors can be made in the one Rexx program. Multiple statements can be open on each database connection at the one time.
Databases supported by Rexx/SQL include Oracle, DB2, MySQL, and SQLite. Rexx/SQL also supports access to ODBC datasources. This means that you can use Rexx/SQL to access databases such as SQL Server and Access, as well as other products such as Excel.

This software is distributed as compressed package. You have to download and manually install it; if prerequisites are required, you will have to manually install them too.

Manual installation

Program is distributed as ZIP package: download to temporary directory and unpack to destination folder. See below for download link(s).

Following is a list of prerequisites that you have to manually install in order to have the program working:

You can install the prerequisites with rpm running the following string in a command line:

yum install libc lemon sqlite sqlite-devel sqlite-doc

Online documentation:

A Rexx interface to SQL databases - Mark Hessling (in English)
In close collaboration: MySQL and OS/2 Part 1: MySQL installation - Wolfgang Draxler (in English)
In close collaboration: MySQL and OS/2 Part 2: MySQL installation - Wolfgang Draxler (in English)
In close collaboration: MySQL and OS/2 Part 3: MySQL installation - Wolfgang Draxler (in English)
In close collaboration: MySQL and OS/2 Part 4: MySQL installation - Wolfgang Draxler (in English)
In close collaboration: MySQL and OS/2 Part 5: MySQL installation - Wolfgang Draxler (in English)
In close collaboration: MySQL and OS/2 Part 6: MySQL installation - Wolfgang Draxler (in English)

Following ones are the download links for manual installation:

Rexx/SQL for MySQL 5.0.x v. 2.5 (16/10/2006, Mark Hessling)	Readme/What's new	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.
sourceforge.net/projects/rexxsql/files/rexxsql/2.5/rxsql25_my_os2.zip/download	local copy
Rexx/SQL for SQLite v. 2.5 (16/10/2006, Mark Hessling)	Readme/What's new	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.
sourceforge.net/projects/rexxsql/files/rexxsql/2.5/rxsql25_lite_os2.zip/download