Version 6 of IICMD

Updated 2008-06-08 12:35:22 by koyott

IICMD - TCL extension for INGRES DBMS

Location: http://code.google.com/p/iicmd/

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;