SQLINFO File

SQLINFO exists in the SYSFILES account. A Q-pointer is created to it from each account on which SQLM is run. It contains information used by SQLM and the Reality SQL server. It does not need to be changed by the SQL user. See the item HELP in this file for latest information. (The contents of this item at the time of going to print are shown below.)

HELP
SQLINFO contains general information about the Reality data source.
Items in this file start with a prefix of the command name, followed by a hyphen and the info type.
For example, item GETINFO-1 contains information for info type 1, command GETINFO.
On Reality, each account is treated as an individual data source.
An ODBC driver may start the REALSQL server on any account.
By default, a single instance of this file exists in SYSFILES and
SQLM creates a Q-pointer whenever it is run in a new account.
=============
GETINFO items
=============
REALSQL server will retrieve an item, get the data and respond to a
driver.  If the item is missing, an error with 'Information type out of range'
will be returned to the driver.
Items in this file have the following format:
   001  Value type (see below).
   002  Info value to be returned to the driver.
   003  Info type name.
   004  Description of InfoType
   005  Description of returned value(s)
Where Value types are:
    'I' = Integer (16-bit) = decimal value
    'L' = Long    (32-bit) = decimal value
    'M' = Mask    (32-bit) = hex value
    'S' = String           = any character sequence (including
                             spaces)
    'V' = Variable         - value supplied by Server
=============
CATALOG items
=============
REALSQL server uses these items to construct SQL statements
to satisfy various catalog queries.
The SQL statement is built by processing an item one attribute,
or multi-value, at a time. Each attribute or multi-value
starts with a "type" character that determines how that attribute
or multi-value is processed.
The supported type characters and their meanings are:

     '*' = Comment, skip to end of attribute
     'H' = Text, copy to next delimiter
     'W' = Predicate, insert WHERE or AND keyword and copy to next
           delimiter
    'An' = Insert argument 'n' as quoted string
    'Nn' = Insert argument 'n' as a number
 '?n=xxx'= Test argument 'n', skip to end of attribute
 '?n#xxx'  unless argument value equal(=)/not equal(#) to 'xxx'