6 Using the ttIsql Utility

The TimesTen ttIsql utility is a general tool for working with a TimesTen data source.

The ttIsql command line interface is used to issue SQL statements and built-in ttIsql commands to perform various operations. Some common tasks that are typically accomplished using ttIsql include:

• Database setup and maintenance. Creating tables and indexes, altering existing tables and updating table statistics can be performed quickly and easily using ttIsql.

• Retrieval of information on database structures. The definitions for tables, indexes and cache groups can be retrieved using built-in ttIsql commands. In addition, the current size and state of the database can be displayed.

• Optimizing database operations. The ttIsql utility can be used to alter and display query optimizer plans for the purpose of tuning SQL operations. The time required to run various ODBC function calls can also be displayed.

The following sections describe how the ttIsql utility is used to perform these types of tasks:

• Using ttIsql in Batch Mode or Interactive Mode

• Customizing Startup Command Line Options for ttIsql Sessions

• Customizing the ttIsql Command Prompt

• Using the ttIsql Online Help

• Using the ttIsql 'editline' Feature for Linux and UNIX Only

• Using the ttIsql Command History

• Using the ttIsql edit Command

• Displaying Characters in ttIsql

• Displaying Database Structures Using ttIsql

• Using ttIsql to List Database Objects by Object Type

• Using ttIsql to View and Set Connection Attributes

• Using ttIsql to Manage Transactions

• Using ttIsql with Prepared and Parameterized SQL Statements

• Using, Declaring, and Setting Variables in ttIsql

• Creating and Running PL/SQL Blocks Within ttIsql

• Passing Data From PL/SQL Using OUT Parameters Within ttIsql

• Using the IF-THEN-ELSE Command Construct Within ttIsql

• Loading Data from an Oracle Database into a TimesTen Table Without Cache

• Using ttIsql to View and Change Query Optimizer Plans

• Using ttIsql to Manage ODBC Functions

• Specifying Error Recovery Within ttIsql

For more information on ttIsql commands, see the ttIsql section in the Oracle TimesTen In-Memory Database Reference.