This is an empty page.

Enter page contents here or click cancel to leave it empty.
Location: [http://code.google.com/p/iicmd/]
----
!!!!!!
%|  IICMD   
One-sentence summary of this page.
IICMD TCL extension
IICMD is an extension for comfortable work with Ingres DBMS from TCL programming language.
Platforms available:

Available for Linux as a shared object and for windows as a Dll

What for:

IICMD version 1.2: provides commands for connect to any Ingres database, execute any Ingres SQL, fetch data into TCL list and disconnect from database;
TCL Commands description:
-iiconnectdb:

    Usage (from TCL): iiconnectdb servername databasename ?user? ?password? 

    returns a string which contains unique database connection identifier in Ingres. 

-iisqlexec:

    Usage (from TCL): iisqlexec ?additional option? "sql_statement" 

    if executed only with "SQL text" without additional option, returns a 2-dimensioned Tcl list containing a result of SQL select statement, or nothing if SQL statement was not a select. 

    If statement was a correct select, result list will contain at least 4 elements at following order: 

    * list of column names in table; 

    * list of conversion functions for each column; 

    * list of column types; 

    * list of column length; 

    * data range list range from 4 to end). 

if command executed with additional option, then result contains what was specified in this option.

Additional options:

   1. -data - result will be range of sql data
   2. -colnames - result will be a list of table column names
   3. -length - result will be a list of table column length
   4. -types - result will be a list of table column types
   5. -functions - result will be a list of table column conversion functions 

    iidisconnectdb:

        Usage (from TCL): iidisconnectdb connection name 

    Returns nothing; disconnect from specified connection name; If no connection exists, generates an error. 

    -iifilltab:

        Usage (from TCL): iifilltab sql_select ?-numbers? ?-colnames? 

    experimental, not fully tested; 

    Returns result of select statement as a list in "array set" format; it is very useful with TkTable? and works very fast, but may be any errors yet; 

    * if "-numbers" option is specified, any row preceded by its number;
    * if "-colnames" option is specifyed, any column heads by its name in database;
    * without additional options this function returns only data; 


!!!!!!