HP c-tree-SQL ISQL and Tools Manuale Utente Scaricare il pdf (Pagina 63)

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

1 2 ... 58 59 60 61 62 63 64 65 66 67 68 ... 98 99

Nessun commento

HP c-tree-SQL ISQL and Tools Manuale Utente Pagina 63