| Object Code Only - Compatible with OS/400 V5R2M0 and Later | Source Code - Compatible with any Release of OS/400 |
SQL Lite is available for a one-time charge per company (site license) for $295.
SQL Lite is available in source code form for a one-time charge per company of $1295.00 (US). Source code license includes one object code license. Also, the code should compile on any version and release of i5/OS or OS/400. This would allow you to, for example, buy IBM's SQL/400 for your development box and then compile SQL Lite with a target release that is compatible with your other systems. This will allow you to install it on those systems and have SQL available without licensing the IBM SQL/400 product for those systems.
To compile SQL Lite source license on your AS/400 or iSeries you must have a license for IBM's SQL/400 product installed.
After you pay for your license, you'll be returned to this page.
You may also mail your payment to the following address:
Cozzi Productions, Inc.
P.O. Box 106
North Aurora, IL 60542
SQL Lite allows you to run SQL statements from the Command Entry Display or within CL programs.
A new version of SQL, compiled to run on RISC-based AS/400 systems is being released for new or existing customers. This new version runs on either PowerPC (RISC) based or CISC-based AS/400 systems.
Run virtually all SQL statements from within a CL program or from the Command Entry Display.
SQL Lite is compiled to restore on either the original CISC-based AS/400 systems, or the new Power PC RISC-based AS/400. Code is compiled to OS/400 Version 3, Release 2. It will restore on all subsequent OS/400 versions and release levels.
SQL Lite for System i is available immediately from The RPG Developer Network and Robert Cozzi, Jr.
The price of an SQL Lite license is as follows:
$295 - One-unit, one AS/400 iSeries, System i License.
$1295 - Site license and source code.
You can order SQL Lite by following these instructions:
If you need SQL Lite right away, send your payment with your order to the address below. If you must be invoiced, we will ship SQL Lite upon receipt of payment. You can e-mail your request to us email me We will e-mail an Adobe PDF file to you containing our invoice. Upon receipt of payment, SQL Lite will be shipped to your location.
PLEASE NOTE:
- All orders must be prepaid. Be sure to send payment along with your order.
- Orders usually ship within a day or two of receipt of your order.
- Software is shipped Internet download, oremail (as an attached .ZIP)
Send your order for "SQL Lite" along with payment (payable to "Cozzi Productions, Inc.") to:
Cozzi Productions, Inc.
P.O. Box 106
North Aurora, IL 60542
Be sure to indicate that the order is for SQL Lite.
© Copyright 1989 by Robert Cozzi, Jr.
To install the SQL Lite onto your AS/400 or iSeries, you will need access to both a PC display and an AS/400 command entry display.
Before transfer the SQL Lite savefile to your AS/400 or iSeries create a save file on your AS/400 or iSeries system. The save file is named SQLLIB (which is also the library name where SQL Lite is installed). Sign on to your AS/400 or iSeries and go to a command entry display or command line window. From there enter the following OS/400 CL command to create the save file.
CRTSAVF SAVF(QGPL/SQLLIB)
From you PC (any PC platform should work) start FTP and connect to your AS/400 or iSeries.
FTP myhost.domain.com/* where myhost.domain.com is the name of your AS/400 or iSeries domain*/
Enter your FTP user ID and Password (same as you AS/400 User ID and Password) when prompted. Then enter the following FTP commands:
quote site namefmt 1BINARYcd /qsys.lib/qgpl.lib
At this point the target location is ready. Now you need to determine where the save file is located on your PC. A good place to store this type of file is in a directory named C:\QTEMP or C:\TEMP or similar, since shorter directory names are easier to work with in FTP. If you haven't already done so, make sure the SQL Lite.SAVF you downloaded is stored in a known directory on your PC.
Enter the following FTP command to switch to the directory containing the SQL Lite save file.
LCD c:\temp
/* where c:\temp is the name of the directory where the SQLLIB.savf file is stored. */
You are now ready to begin the transfer. Remember, the save file is a binary image so if you forgot to enter the BINARY command, it will not upload correctly. In addition, the save file must be previously created in order for this procedure to work correctly.
Enter the following FTP command to start the transfer.
PUT SQLLIB.savf SQLLIB.savf
This command will start the transfer. Depending on the FTP software you're using you may or may not see a status message indicating the progress.
After a successful FTP session, you should end your FTP session by closing the window.
Enter the following FTP command:
QUIT
On the AS/400 or iSeries, enter the following CL command:
RSTLIB LIB(SQLLIB) DEV(*SAVF) SAVF(QGPL/SQLLIB)
You may restore the library to another library name, but the SQL Lite commands may need to be changed to point their command processing programs to the new library. They should, however, have been created with a CPP of *LIBL so that may not be necessary.
At this point the SQL Lite for OS/400 is loaded onto your system and ready to be used.
The primary command is RUNSQL, press F4 to prompt and enter any SQL statement.