 ==============================================================================
          Call-Level Interface (CLI) for mSQL 1.0.x (Unix, OS/2)
                                     and Oracle 7.x (Unix)

                 (c) 1996 by Dirk Ohme, all rights reserved
 ==============================================================================

Disclaimer:
-----------

        The programs, libraries and all other files coming with this
        archive are distributed "as is", WITHOUT ANY WARRANTY - so
        USE IT ON YOUR OWN RISK!

        The current state of these files is "Freeware", so you may use
        this CLI without paying any fees. You are allowed to give others
        the complete archive under these conditions:
                - no fee has to be payed for distribution
                - no fee has to be payed for use
                - the archive is given away in its original form
                  (i.e. re-packing and re-bundling is prohibited!)



Version notes:
--------------

        Currently these platforms are supported:
                - mSQL 1.0.x for OS/2
                - mSQL 1.0.x (various Unix platforms)
                - Oracle 7.x with Oracle's OCI (Sun Solaris)


        mSQL 1.0.x (OS/2, Unix):
        ------------------------

                - supported SQL data types are:
                        SQL_CHAR        equals CHAR on mSQL
                        SQL_INTEGER     equals INT  on mSQL
                        SQL_REAL        equals REAL on mSQL

                - implementation of CLI routines equals ODBC core level


        Oracle 7.x (Sun Solaris):
        -------------------------

                - requires Oracle Call Interface (OCI) 7020200.1
                  dated 95/02/15 or later

                - supported SQL data types are:
                        SQL_CHAR        equals VARCHAR2 on Oracle
                        SQL_INTEGER     equals NUMBER   on Oracle
                        SQL_REAL        equals NUMBER   on Oracle
                  --> maybe a later implementation of this CLI will
                      decide between Oracle's CHAR and VARCHAR2
                      datatype, when mSQL is able to decide between
                      CHAR and VARCHAR, too

                - implementation of CLI routines equals ODBC core level
                  except SQLColAttributes() which does not work properly
                  --> use SQLDescribeCol() instead



Bugs, Limitations:
------------------

        all:
        ----

                - limit on cursor string to 32 bytes (i.e. 31 chars plus
                  terminating NUL, see SQL_MAX_CURSOR_NAME)


        mSQL 1.0.x (OS/2, Unix):
        ------------------------

                - limit on colums = 64 (queries, see SQL_MAX_COLUMN)
                - limit on parameters = 16 (all, see SQL_MAX_PARAM)
                - 65536 bytes maximum size on SQL statements (incl.
                  data provided by parameter-variables,
                  see SQL_MAX_BUFFER_SIZE)


        Oracle 7.x (Sun Solaris):
        -------------------------

                - SQLDescribeCol() can only be called once for each
                  column returned by a query. This is due to a bug (?)
                  of Oracle's OCI.
                - the same bug prevents SQLColAttributes() from proper
                  working ...


History:
--------

        CLI V 1.00.0, 1996/??/??
        ------------------------
                - mSQL version: CLI routines at "ODBC core level"
                - Oracle version: CLI routines nearly at "ODBC core level"


        (unnamed),    1996/05/29
        ------------------------
                - first snapshot for mSQL (Unix)



 ==============================================================================
   (c) 1996 by Dirk Ohme, all rights reserved         last update: 1996/06/17
 ==============================================================================

