A Rexx interface to SQL databases
10 October 2006
This section describes features of Rexx/SQL specific to the SQLite
implementation. Support is no longer offered for SQLite prior to version 3.
- All arguments to
If no database name argument is supplied, then the SQLite3 feature of an in-memory database
will be used. With this feature the database is created on connection and all tables need to be created and can then be manipulated as
one would normally. The data in the database is lost when disconnecting.
The database name argument in
is the only argument that can be supplied. All other arguments should not be specified. The database name
argument is a file name. If the database in the specified file name does not exists, it will
- SQLite only allows tables to be described; not a SELECT statement. Therefore is you want
to use the
function, pass a table name as the parameter, not a select statement.
SQLite supports standard placemarkers and SQLite specific placemarkers. Need to document how these work; similar to Oracle.
SQLite supports transactions, but you need to explicitly execute a "BEGIN TRANSACTION" command
to start a transaction. See tester.cmd sample program for an example.
SQLite is a typeless database. All columns are stored as text, so SQLite3 allows any
datatype you want. Rexx/SQL for SQLite3 however, supports the following datatypes explicitly:
The datatypes supported by Rexx/SQL for SQLite can be determined by a call to
with the DATATYPES option.
- INTEGER PRIMARY KEY
Mark Hessling 1997-2006
Return to Table of Contents
Last updated 10 October 2006