This is an empty page.
Enter page contents here or click cancel to leave it empty. Location: [L1 ]
%| 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:
if command executed with additional option, then result contains what was specified in this option.
Additional options:
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;