Table of Contents

• Title and Copyright Information
• About This Content
• 1 Get Started with ttIsql
  • About ttIsql
  • Starting ttIsql
  • Customizing the ttIsql Command Prompt
  • Command Shortcuts
• 2 Use ttIsql
  • About Using ttIsql in Interactive or Batch Mode
  • Help Commands
  • View and Set Attributes
  • Use, Declare, Set Variables and Parameters
    • Declaring and Setting Bind Variables
    • Automatically Creating Bind Variables for Retrieved Columns
    • Parameters
  • Run SQL Statements
    • Prepare a SQL Statement for Subsequent Runs
    • Manage Transactions
  • Display Database Structures
    • describe Command
    • cachegroups Command
    • repschemes Command
    • dssize Command
    • tablesize Command
    • monitor Command
  • List Database Objects by Object Type
  • View and Change Query Optimizer Plans
    • Use the showplan Command
    • View Commands and Explain Plans from the SQL Command Cache
      • View Commands in the SQL Command Cache
      • Display Query Plan for Statement in SQL Command Cache
  • Create and Run PL/SQL Blocks Within ttIsql
    • Pass Data From PL/SQL Using OUT Parameters Within ttIsql
  • Manage ODBC Functions
    • Canceling ODBC Functions
    • Timing ODBC Function Calls
  • 'editline' Feature for Linux and UNIX Only
    • Emacs Binding
    • vi Binding
• 3 ttIsql Command Reference
  • accept
  • allfunctions
  • allindexes
  • allpackages
  • allprocedures
  • allsequences
  • allsynonyms
  • alltables
  • allviews
  • builtins
  • bye
  • cachegroups
  • cachesqlget
  • cd
  • clearhistory
  • clienttimeout
  • close
  • cmdcache
  • commit
  • commitdurable
  • compare
  • connect
  • createandloadfromoraquery
  • define
  • describe
  • dssize
  • e:
  • edit
  • exec
  • execandfetch
  • explain
  • fetchall
  • fetchnext
  • fetchone
  • free
  • grid
  • help
  • history
  • host
  • if-then-else
  • monitor
  • remark
  • retryconnect
  • rpad
  • run
  • savehistory
  • setjoinorder
  • setuseindex
  • setvariable
  • showjoinorder
  • sleep
  • sqlcolumns
  • sqlgetinfo
  • sqlstatistics
  • sqltables
  • statsclear
  • statsestimate
  • statsupdate
  • tablesize
  • use
  • variable
  • version
  • waitfor
  • waitforresult
  • whenever sqlerror
  • xlabookmarkdelete