View and Set Attributes

You can view and set attributes with the show and set commands.

Use show all command to display the setting for all set/show attributes.

Command>show all; 
Connection independent attribute values: 
  - autoprint = 0 (OFF)
  - autovariables = 0 (OFF
  - columnlabels = 0 (OFF)
  - define = 0 (OFF)
  - echo 1 (ON)
  - editline = 1 (ON)
  - FEEDBACK ON
  - LONG 80
  - LONGCHUNKSIZE 65536
  - multipleconnections = 0 (OFF)
  - ncharencoding = LOCALE (AL32UTF8)
  - prompt = 'Command> '
  - rowdelimiters = 1 (ON) before:'< ', after:' >', separator:', '
  - showcurrenttime = 0 (OFF)
  - termout = 1 (ON)
  - timing = 0 (OFF)
  - verbosity = 2
  - vertical = 0 (OFF)

Connection specific attribute values:

  - autocommit = 1 (ON)
  - Client timeout = 0
  - Connection String DSN=<database name>;UID=<uid>; DataStore=<database path>;
 DatabaseCharacterSet=AL32UTF8; ConnectionCharacterSet=US7ASCII;
 DRIVER=/sw/tthome/install/lib/libtten.so; PermSize=20;TempSize=20; 
  - No failover messages.
  - PL/SQL Errors: No errors.
  - isolation = READ_COMMITTED
  - Prefetch count = 5
  - Query threshold = 0 seconds (no threshold)
  - Query timeout = 0 seconds (no timeout)
  - Query timeout = 0 seconds (no timeout)
  - serveroutput OFF
  - SESSION_ACTION = 
  - SESSION_CLIENT_INFO = 
  - SESSION_MODULE = _ttIsql@phoenix92527

Current Optimizer Settings:
  - Scan: 1
  - Hash: 1
  - Range: 1
  - TmpHash: 1
  - TmpRange: 1
  - TmpTable: 1
  - NestedLoop: 1
  - MergeJoin: 1
  - GenPlan: 0
  - TblLock: 1
  - RowLock: 1
  - HashGb: 1
  - Rowid: 1
  - FirstRow: 0
  - IndexedOr: 1
  - PassThrough: 0
  - BranchAndBound: 1
  - ForceCompile: 0
  - ShowJoinOrder: 0
  - TransparentLoad: 0
  - UseBoyerMooreStringSearch: 0
  - DynamicLoadEnable: 1
  - DynamicLoadErrorMode: 0
  - NoRemRowIdOpt: 0
  - FastPrepare: 1
  - VectorProcess: 1
  - Rewrite: 1
  - DynamicLoadMultiplePKs: 1
  - DynamicLoadRootTbl: 0
  - TmpIdxForMatRes: 0

Current Join Order:
        <>
Command

To view the setting for the Passthrough attribute, enter:

Command>show passthrough;
PassThrough = 0

To change the Passthrough setting, enter:

Command>set passthrough 1;

You have the help attributes command to list the help for all the attributes that could be set or shown. See Help Commands.

To view the detailed attribute help:

Command> help attribute clienttimeout

Attribute usage: clienttimeout

Command Usage: clienttimeout [<timeout seconds>]
Command Aliases: (none)
Description: Sets the client timeout (in seconds) for the current connection.
If the optional argument is omitted then the current client timeout is
reported. The client timeout can take a value between 0 and 99999 inclusive.
Requires an active connection: YES
Requires autocommit turned off: NO
Reports elapsed execution time: YES
Works only with a TimesTen data source: YES
Example: show clienttimeout; -or- set clienttimeout 10;
Used with Set: YES
Used with Show: YES