|
|
|
SHOW
Syntax
SHOW [ show_option | SPOOL ] ;
show_option ::
HISTORY
| PAGESIZE
| LINESIZE
| COMMAND LINES
| REPORT
| ECHO
| PAUSE
| TIME
| DISPLAY COST
| AUTOCOMMIT
| TRANSACTION ISOLATION LEVEL
| CONNECTION
Description
The SHOW statement displays the values of the various settings controlled by corresponding SET and SPOOL statements. If the SHOW statement omits show_option, it displays all the ISQL settings currently in effect.
See "SET", "SPOOL", and "EDIT" for details on the settings displayed by the SHOW statement.
Example
ISQL> SHOW
ISQL ENVIRONMENT
____________________
EDITOR ..................... : vi
HISTORY buffer size ........ : 50 PAUSE ..................... : ON
COMMAND LINES .............. : 10 TIMEing command execution.. : OFF
SPOOLing ................... : ON LINESIZE .................. : 78
REPORTing Facility ......... : ON PAGESIZE .................. : 72
Spool File ................. : spool_file
AUTOCOMMIT ................. : OFF ECHO commands ............. : ON
TRANSACTION ISOLATION LEVEL. : 0 (Snapshot)
DATABASE CONNECTIONS
_______________________
DATABASE CONNECTION NAME IS DEFAULT ? IS CURRENT ?
-------- --------------- ------------ -----------
salesdb conn_1 No Yes
