ttIsql
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 |
---|---|
|
An ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings. |
|
Specifies an ODBC data source name of the database to be connected. |
|
Specifies a semicolon separated list of |
|
Read SQL statements from |
|
Prints a usage message and exits. |
|
Prints a short list of the interactive commands. |
|
Prints a full description of the interactive commands. |
|
Forces interactive mode. This is useful when running from an |
|
Specifies the character encoding method for Valid values are If no value is specified, TimesTen uses the system's native language characters. |
|
Prints the release number of |
|
Specifies the verbosity level. One of:
|
- |
Waits until successful connect. |