<SQL_command> &

Spawns a new copy of ISQL as a background OS process to execute the command. The new copy will make its own connection and will terminate after the command completes. The isql instance which received the command prompts for the next command without waiting for the spawned isql instance

! <command> (;|&)

Executes an OS command

SET <ISQL_OPTION>( |=)<VALUE>

sets the ISQL variable or associative array U value, if it is recognized as such. Otherwise passed to the server.

Example 7.1. Examples

SET U{test} 5; sets the associative array U's 'test' to have value of 5

SHOW [<ISQL_OPTION>]

shows the value of an ISQL option, if it is recognized as such. Otherwise passed to the server.

NOP

no-operation. Useful sometimes in an $IF command.

(ECHO|ECHOLN) [STDOUT|STDERR|ERROR_STREAM|BOTH] string1 string2 ...

echoes it's arguments into the specifies output stream (defaults to STDOUT if not specified) If ECHOLN is used it appends a new line after the last character printed.

WAIT_FOR_CHILDREN

Waits for background ISQL subcommands spawned by specifying an & instead of ; at the end of the statement.

LOAD <file_name>

Executes each statement of the specified file. Statements end in a semicolon or at the closing curly brace for procedure or trigger definitions.

HELP [<isql-command>]

Prints general or command specific help texts.

(EXIT|QUIT) [NOT]

Exits ISQL

EXIT NOT is a NO-OP, allowing statements like: EXIT $IF $EQU $ARGV[0] 10 $ARGV[0] NOT; which exits with exit code 10 if $ARGV[0] is ten (presumably keeping a some-kind of failure counter) but otherwise does nothing special, and continues from the next statement.

SLEEP [<seconds>]

sleeps for the specified number of seconds or until an OS signal arrives. If seconds is not specified it's considered 0 and the behavior is OS dependent (the OS sleep function on Unixes, Sleep() in the Windows API).

CONNECT [<conn_str>]

Without arguments forces the connection to be made with an ordinary way with SQLConnect and so-far specified connection details. With an argument uses SQLDriverConnect, giving that argument as a connection string (e.g. "DSN=Virtuoso;UID=DBA,PWD=DBA") If we are already connected, then is just NO-OP which is silently ignored.

TableQualifiers

Returns all defined table qualifiers.

TableOwners

Returns existing table owners list.

TableTypes

Returns list of current table types.

RECONNECT [<User_ID>]

If the ISQL is already connected then disconnects. After that it tries connecting to the same data source, but with using its argument as a user name. If none specified it gets the user name/password from the UID and PWD ISQL variables.

FOREACH [LINE|INTEGER|BLOB|TIMESTAMP|DATE|TIME]
        [FOLLOWING|IN (-|-b|<file_name>)|BETWEEN <n1> <n2>]
        <statement_with_params> <statement_with_params> ... [END]

This command executes the <statement_with_params> in a loop, after binding the parameters specified in it to values specified in the command.

Parameters are specified as follows :

? - an ordinary parameter bound to the foreach value
?C - the count of successful operations
LINE processes the input line by line
INTEGER converts the input into integer and then processes it.
BLOB reads the entire input and sets it as an blob parameter using SQLPutData
TIMESTAMP is the same as LINE, bit binds to a TIMESTAMP SQL Type
DATE is the same as LINE, but binds to a DATE SQL Type
TIME is the same as LINE, bit binds to a TIME SQL Type
IN specifies a set of items terminated by an END
BETWEEN specifies integer set starting from n1 and ending on n2
FOLLOWING as as IN but skips the input till the END keyword

Example 7.2. Examples:

foreach integer between 1 10 insert into num_tb values (?);

Inserts 10 rows from 1 to 10 into the num_tb

foreach line in my_text_file.txt insert into str_tb (line_no, data) values (?C, ?);

Inserts each line of the text file my_text_file.txt into str_tb's data column and puts line number in line_no column

foreach blob in my_text_file.txt insert into file_tb values (?);

inserts a row into the file_tb with the contents of the my_text_file.txt as a single blob value.


SHUTDOWN

Passes this through to the server as a command

CALL <SQL statement>

Tries to bind & print the SQL_RETURN_VALUE and display multiple resultsets (if any) after executing the statement.

COLUMNS [<table_mask>][/<column_mask>]

Calls SQLColumns ODBC

TABLES [<table_mask>]

Calls SQLTables ODBC

PRIMARYKEYS [<table_mask>]

Calls SQLPrimaryKeys ODBC

COLUMNPRIVILEGES [<table_mask>]/[<procedure_column_mask>]

Calls SQLColumnPrivileges ODBC

PROCEDURES [<procedure_mask>]

Calls SQLProcedures ODBC

PROCEDURECOLUMNS [<procedure_mask>]/[<procedure_column_mask>]

Calls SQLProcedureColumns ODBC

TABLEPRIVILEGES [<table_mask>]

Calls SQLTablePrivileges ODBC

GETTYPEINFO

Calls SQLGetTypeInfo (SQL_ALL_TYPES) ODBC

STATISTICS [<table_mask>] [/U]

Calls SQLStatistics ODBC. U means show only unique indexes otherwise all

SPECIALCOLUMNS [<table_mask>] [/(B?S?T?N?)]

Calls SQLSpecialColumns ODBC.

B means BEST_ROWID, otherwise ROWVER.
S means Session scope, T means transaction scope, otherwise current row.
N means No Nulls, otherwise Nullable.