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 the chapter Using the ttIsql Utility in Oracle TimesTen In-Memory Database Operations Guide.

Required Privilege

This utility requires no privileges.

Usage in TimesTen Scaleout and TimesTen Classic

This utility is supported in both TimesTen Classic and TimesTen Scaleout.

Syntax

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

Options

ttIsql has the options:

Option	Description
`-connStr` `connection_string`	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.
`-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.