Filter
Top Products
ISQL Statements
FairCom Corporation 3-37
sys_chkcol_usage
sys_keycol_usage
Here's a page break!
.
.
.
ISQL> SET DISPLAY COST ON
ISQL> -- Select from the one-record SYSCALCTABLE table:
ISQL> SELECT * FROM SYSCALCTABLE;
Estimated Cost Values :
-----------------------
COST : 8080
CARDINALITY : 200
TREE SIZE : 3072
FLD
---
100
3.7.19 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 Section 3.7.18 "
SET" on page 3-34, Section 3.7.20 "SPOOL" on page 3-38, and Section
3.7.8 "EDIT" on page 3-25 for details on the settings displayed by the SHOW statement.
Example
ISQL> SHOW
ISQL ENVIRONMENT