[@more@]

All commands must end with a semicolon character.
Arguments in <> are required.
Arguments in [] are optional.

Command Usage: ?
Description: Print brief help information for all commands.

Command Usage: !
Description: Executes a command in the history list.

Command Usage: autocommit [0|1]
Description: Turns the autocommit feature off(0) or on(1).

Command Usage: cachegroups
[[cache_group_owner_pattern.]cache_group_name_pattern]
Description: Reports information on cache groups defined in the currently
connected data source.

Command Usage: cggensql has been decrecated.
Description: Deprecated feature. Use cacheSqlGet instead.

Command Usage: cachesqlget [[INCREMENTAL_AUTOREFRESH] [[cache_group_owner.]cache_group_name]>]
[filename]
Description: Generates an Oracle SQL*Plus compatible script for the
installation or uninstallation of Oracle objects associated with a cache group
using the incremental autorefresh or asynchronous writethrough feature.

Command Usage: close [[connect_id.]command_id] (command_id is an integer
between 0 and 255 inclusive, connect_id is used with multiple connections)
Description: Closes a result set on the specified prepared SQL statement.

Command Usage: closeall
Description: Closes a result set on all the prepared SQL statements.

Command Usage: columnlabels [0|1]
Description: Turns the columnlabels feature off(0) or on(1).

Command Usage: commit
Description: Commits the current transaction.

Command Usage: commitdurable
Description: Commits the current transaction durably.

Command Usage: compact
Description: Compacts the data source.

Command Usage: connect [DSN|connection_string] [as ]
Description: Connects to the data source specified by the optional DSN or
connection string argument.

Command Usage: describe [[owner_name_pattern.]table_name_pattern|
procedure_name_pattern| sql_statement| [connect_id.]command_id | *]
Description: Reports column definitions and statement parameters associated
with the command's argument.

Command Usage: disconnect
Description: Disconnects from the currently connected data source.

Command Usage: dssize [k|m]
Description: Reports data source size information in kilobytes or megabytes.

Command Usage: e:
Description: Echo the specified message on this line.

Command Usage: exec [[connect_id.]command_id] (command_id is an integer between
0 and 255 inclusive, connect_id is used with multiple connections)
Description: Executes the specified prepared SQL statement.

Command Usage: execandfetch [[connect_id.]command_id] (command_id is an integer
between 0 and 255 inclusive, connect_id is used with multiple connections)
Description: Executes the specified prepared SQL statement and fetches all
result rows associated with the statement.

Command Usage: exit
Description: Exits the program.

Command Usage: fetchall [[connect_id.]command_id] (command_id is an integer
between 0 and 255 inclusive, connect_id is used with multiple connections)
Description: Fetches all result rows associated with the prepared SQL statement.

Command Usage: fetchone [[connect_id.]command_id] (command_id is an integer
between 0 and 255 inclusive, connect_id is used with multiple connections)
Description: Fetches one result row associated with the prepared SQL statement.

Command Usage: free [[connect_id.]command_id] (command_id is an integer between
0 and 255 inclusive, connect_id is used with multiple connections)
Description: Frees the specified prepared SQL statement.

Command Usage: help [command [command...]|all|comments]
Description: Print brief or detailed help information for commands.

Command Usage: history [-r] [num_commands]
Description: Lists previously executed commands.

Command Usage: host
Description: Executes an operating system command.

Command Usage: indexes [[owner_name_pattern.]table_name_pattern]
Description: Reports indexes associated with the table names of all tables
matching the pattern.

Command Usage: isolation [SERIALIZABLE|0|READ_COMMITTED|1]
Description: Sets the transaction isolation level for the current connection.

Command Usage: monitor
Description: Reports the contents of the SYS.MONITOR table for easy viewing.

Command Usage: multipleconnections [1|ON]
Description: Reports or turns on multiple connections.

Command Usage: ncharencoding [ASCII|LOCALE|UTF8]
Description: Sets the encoding method for native character input/output.

Command Usage: optfirstrow [0|1]
Description: Disables(0) or enables(1) First Row optimization.

Command Usage: passthrough [0|1|2|3]
Description: Sets the Oracle Connect pass through level.

Command Usage: optprofile
Description: Reports the current query optimizer hint settings and join order.

Command Usage: prefetchcount [prefetch_count_size]
Description: Sets the prefetch count size for the current connection.

Command Usage: prepare [[connect_id.]command_id] (command_id is
an integer between 0 and 255 inclusive, connect_id is used with multiple
connections)
Description: Prepares the specified SQL statement.

Command Usage: procedures [procedure_name_pattern]
Description: Reports built-in procedure names that match the given pattern.

Command Usage: repschemes [[scheme_owner_pattern.]scheme_name_pattern]
Description: Reports information on replication schemes defined in the
currently connected data source.

Command Usage: retryconnect [0|1]
Description: Disables(0) or enables(1) the connection retry feature.

Command Usage: rollback
Description: Rolls back the current transaction.

Command Usage: run
Description: Executes ttIsql commands in the specified file.

Command Usage: setjoinorder
Description: Sets the join order hint for the query optimizer.

Command Usage: setuseindex
Description: Sets the index hint for the query optimizer.

Command Usage: sequences [[owner_name_pattern.]sequence_name_pattern]
Description: Reports the attributes of sequences matching the pattern.

Command Usage: showplan [0|1]
Description: Disables(0) or enables(1) the display of the query optimizer plan
after SELECT, UPDATE or DELETE SQL statements.

Command Usage: sleep [n] (n must be an integer greater than or equal to 0)
Description: Suspends execution for n seconds.

Command Usage: sqlcolumns [[owner_name_pattern.]table_name_pattern]
Description: Reports the results of an ODBC call to SQLColumns ().

Command Usage: sqlgetinfo
Description: Reports the results of an ODBC call to SQLGetInfo ().

Command Usage: sqlquerytimeout [timeout_seconds]
Description: Sets the query timeout in seconds.

Command Usage: sqlstatistics <[owner_name.]table_name>
Description: Reports the results of an ODBC call to SQLStatistics ().

Command Usage: sqltables [[owner_name_pattern.]table_name_pattern]
Description: Reports the results of an ODBC call to SQLTables ().

Command Usage: statsclear [[owner_name.]table_name]
Description: Clears statistics for the specified table.

Command Usage: statsestimate [[owner_name.]table_name]
Description: Estimate statistics for the specified table.

Command Usage: statsupdate [[owner_name.]table_name]
Description: Updates statistics for the specified table.

Command Usage: tables [[owner_name_pattern.]table_name_pattern]
Description: Reports the owner qualified table name of all tables matching the
pattern.

Command Usage: timing [0|1]
Description: Disables(0) or enables(1) the display of command execution timing
information.

Command Usage: tryhash [0|1]
Description: Disables(0) or enables(1) the use of hash indexes by the query
optimizer.

Command Usage: trymaterialize [0|1]
Description: Disables(0) or enables(1) the use of an intermediate results table
by the query optimizer.

Command Usage: trymergejoin [0|1]
Description: Disables(0) or enables(1) the use of merge joins by the query
optimizer.

Command Usage: trynestedloopjoin [0|1]
Description: Disables(0) or enables(1) the use of nested loop joins by the
query optimizer.

Command Usage: tryserial [0|1]
Description: Disables(0) or enables(1) the use of serial scans by the query
optimizer.

Command Usage: trytmphash [0|1]
Description: Disables(0) or enables(1) the use of temporary hash indexes by the
query optimizer.

Command Usage: trytmptable [0|1]
Description: Disables(0) or enables(1) the use of an intermediate results table
by the query optimizer.

Command Usage: trytmpttree [0|1]
Description: Disables(0) or enables(1) the use of temporary t-tree (range)
indexes by the query optimizer.

Command Usage: tryttree [0|1]
Description: Disables(0) or enables(1) the use of t-tree (range) indexes by the
query optimizer.

Command Usage: tryrowid [0|1]
Description: Disables(0) or enables(1) the use of rowid scans by the query
optimizer.

Command Usage: tryrowlocks [0|1]
Description: Disables(0) or enables(1) the use of row locks by the query
optimizer.

Command Usage: trytbllocks [0|1]
Description: Disables(0) or enables(1) the use of table locks by the query
optimizer.

Command Usage: unsetjoinorder
Description: Clears join order advice for the query optimizer.

Command Usage: unsetuseindex
Description: Clears the index hint for the query optimizer.

Command Usage: use
Description: Displays or selects the given connection ID.

Command Usage: verbosity [level] (level=0,1,2,3 or 4)
Description: Changes the verbosity level.

Command Usage: version
Description: Reports version information.

Command Usage: vertical [0|1|on|off|]
Description: Controls printing of results vertically or horizontally.

Command Usage: views [[owner_name_pattern.]view_name_pattern]
Description: Reports the attributes of materialized views.

Command Usage: xladeletebookmark [xla_bookmark_id]
Description: Deletes a persistent XLA bookmark.

Command Usage:
Description: Executes the specified SQL statement.

Usage: ttIsqlCS [-h | -help | -helpcmds | -helpfull | -V]
ttIsqlCS [-f ] [-v ] [-e ]
[-interactive] [-N ] [-wait]
[{ | -connstr }]

-h Prints this message and exits.

-help Prints this message and exits.

-helpcmds Prints a brief description of ttIsqlCS commands and exits.

-helpfull Prints a full description of ttIsqlCS commands and exits.

-V Prints version information and exits.

, The ODBC connection string or DSN to use as an
argument to the connect command. The connect command
will then be the first command executed when
starting ttIsqlCS.

-f Specifies an input file of ttIsqlCS commands to be
executed on start up.

-v Specifies the output verbosity level. The output
verbosity level argument takes a value of 0, 1, 2,
3 or 4.

If verbosity = 0 then only error messages are displayed.

If verbosity = 1 then the basic output generated by
commands is displayed.

Verbosity = 2 is the default verbosity level. At this level
simplified SQL error and information messages are
displayed. Command output includes additional information,
and commands that are read from an external file are
echoed to the display.

If verbosity = 3 then more detailed SQL error and
information messages are displayed.

If verbosity = 4 then the most detailed SQL error and
information messages are displayed. At this level
additional informational messages are displayed depending
upon the command executed.

-e Specifies a semicolon-separated list of ttIsqlCS commands
to execute on start up.

-N Specifies the character encoding method for native
character input/output. Valid values are ASCII,
LOCALE, and UTF8. The default encoding method (LOCALE)
is derived from the current environment locale settings.

-wait Forces the program to wait during a connection attempt
until the connection attempt is successful.

-interactive Forces interactive mode. This is useful when running from
an emacs comint buffer.

Default command line options can be set by exporting an environment
variable called TTISQL. The value of the TTISQL environment variable
is a string with the same syntax requirements as the ttIsqlCS command
line. If the same option is present in the TTISQL environment
variable and the command line, then the command line version always
takes precedence.

Examples:

ttIsqlCS -connStr "DSN=mydsn" -v 4
ttIsqlCS -helpfull
ttIsqlCS -connStr "DSN=mydsn" -e "autocommit 0; showplan 1;"
ttIsqlCS -connStr "DSN=mydsn" -f script.sql -N UTF8
--------------------------------------------------------------------------

ttAdmin
ttAdminCmd
ttAdoptStores
ttAdoptStoresCmd
ttBackup
ttBackupCmd
ttBulkCp
ttBulkCpCS
ttBulkCpCSCmd
ttBulkCpCmd
ttCapture
ttCheck
ttCheckCmd
ttDaemonAdmin
ttDaemonAdminCmd
ttDaemonLog
ttDaemonLogCmd
ttDestroy
ttDestroyCmd
ttIsql
ttIsqlCS
ttIsqlCSCmd
ttIsqlCmd
ttMigrate
ttMigrateCS
ttMigrateCSCmd
ttMigrateCmd
ttRepAdmin
ttRepAdminCmd
ttRestore
ttRestoreCmd
ttSchema
ttSchemaCS
ttSchemaCSCmd
ttSchemaCmd
ttSize
ttSizeCmd
ttStatus
ttStatusCmd
ttSyslogCheck
ttSyslogCheckCmd
ttTail
ttTailCmd
ttThunk
ttTraceMon
ttTraceMonCmd
ttUser
ttVersion
ttXactAdmin
ttXactAdminCmd
ttXactLog
ttXactLogCmd
ttadmin
ttadoptstores
ttbackup
ttbulkcp
ttbulkcpcs
ttcapture
ttcapture.20090208.2005.log
ttcheck
ttcserver
ttdaemonadmin
ttdaemonlog
ttdestroy
ttenv.csh
ttenv.sh
ttisql
ttisqlcs
ttmigrate
ttmigratecs
ttmodinstall
ttpatchinst
ttrepadmin
ttrestore
ttschema
ttschemacs
ttsize
ttstatus
ttsyslogcheck
tttail
tttracemon
ttuser
ttversion
ttxactadmin
ttxactlog