2 Use ttIsql

You can use the ttIsql utility in running various SQL statements and built-in ttIsql commands. You can run the ttIsql commands either in the interactive mode or in the batch mode.

This chapter includes the following topics:

• About Using ttIsql in Interactive or Batch Mode
• Help Commands
• View and Set Attributes
• Use, Declare, Set Variables and Parameters
• Run SQL Statements
• Display Database Structures
• List Database Objects by Object Type
• View and Change Query Optimizer Plans
• Create and Run PL/SQL Blocks Within ttIsql
• Manage ODBC Functions
• 'editline' Feature for Linux and UNIX Only