ttIsql

Use ttIsql to run SQL statements and call TimesTen built-in procedures from this utility. Additionally, you can run SQL interactively from the command line and call a TimesTen built-in procedure with call procedure-name.

The ttIsql command attempts to cancel an ongoing ODBC function when the user presses Ctrl-C.

On UNIX and Linux systems, this utility is supported for TimesTen Data Manager DSNs. Use ttIsqlCS for client/server DSNs.

The ttIsql utility starts with AUTOCOMMIT turned on, even when running a script. You can turn AUTOCOMMIT off and back on as necessary.

For a detailed description on running SQL from ttIsql, use the -helpfull option.

For more details on the ttIsql utility, see Oracle TimesTen In-Memory Database ttIsql User's and Reference Guide.

Required Privilege

This utility requires no privileges.

Syntax

ttIsql {-h | -help | -? | -helpcmds | - helpfull}
ttIsql {-V | -version}
ttIsql [-f inputFile] [-v verbosity] [-e commands | sql_statement] 
[-interactive] [-N ncharEncoding] [-wait] [-restrict] {-connStr connStr | DSN}

Options

ttIsql has the options:

Option	Description
`-connStr` `connStr`	An ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings.
`DSN`	Specifies an ODBC data source name of the database to be connected.
`-e` `commands`	Specifies a semicolon separated list of `ttIsql` commands to run on startup.
`-f` `filename`	Read SQL statements from `filename`.
`-h` `-help` `-?`	Prints a usage message and exits.
`-helpcmds`	Prints a short list of the interactive commands.
`-helpfull`	Prints a full description of the interactive commands.
`-interactive`	Forces interactive mode. This is useful when running from an `emacs comint` buffer.
`-N` `ncharEncoding`	Specifies the character encoding method for `NCHAR` output. Valid values are `LOCALE` or `ASCII`. `LOCALE` (the default) sets the output format to the locale-based setting. If no value is specified, TimesTen uses the system's native language characters.
`-restrict`	The following commands are blocked, and an error message is displayed: `cachesqlget` `connect` `edit` `host` `putenv` `savehistory` `set signalbehavior 1` `set signalbehavior waitfordebugger` `spool` See Use ttIsql with Restrict Mode in the Oracle TimesTen In-Memory Database Security Guide.
`-V \| -version`	Prints the release number of `ttIsql` and exits.
`-v` `verbosity`	Specifies the verbosity level. One of: `0` - Shows error information only. If all commands succeed, there is no output. `1` - The basic output generated by commands is displayed. `2` (default) - Same as level 1, plus it shows more detailed results of commands.At this level simplified SQL error and information messages are displayed. In addition, `ttIsql` commands that are read from an external file are echoed to the display. `3` - Same as level 2, with more detailed error and information messages. `4` - Same as level 3, plus complete error and information messages are displayed. Also displayed are messages about prepared commands, "`success`" messages for each command that succeeded and content of XLA records.
-`wait`	Waits until successful connect.

For more details, see Get Started with ttIsql in the Oracle TimesTen In-Memory Database ttIsql User's Guide and Reference.