ISQL Statements
sys_chkcol_usage sys_keycol_usage Here's a page break!
.
.
.
ISQL> SET DISPLAY COST ON
ISQL>
ISQL> SELECT * FROM SYSCALCTABLE;
Estimated Cost Values :
COST | : 8080 | |
CARDINALITY | : | 200 |
TREE SIZE | : | 3072 |
FLD
100
3.7.19SHOW
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.7.8"EDIT" on page
Example
ISQL> SHOW
ISQL ENVIRONMENT
FairCom Corporation |