RDB/VMS Relational Database Operator SHOW — VMS RDB_3.1A
Displays information about the database and database elements.
Additional information available:
ALLCOLLATING_SEQUENCECONSTRAINTSDATABASES
DATE_FORMATDICTIONARYFIELDSINDEXESLANGUAGE
MONITORPRIVILEGESPROTECTIONRADIX_POINT
RELATIONSSTORAGE_AREASTORAGE_MAPSTREAMSTRANSACTION
TRANSFERTRIGGERSUSERSVERSIONS
ALL
SHOW ALL ────┬──────────────────────────────┬───> ├───>
I
N ─┬─> db-handle ────┬──┤ │ └────── , <───────┘ │ └───>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ────────┘ Shows all the current information about the currently invoked databases.
COLLATING_SEQUENCE
SHOW COLLATINGSEQUENCE ──┬───────────────────┬──> └─> sequence-name ──┘ Displays the collating sequences for databases and fields. You can specify the name of the collating sequence you wish to display.
CONSTRAINTS
SHOW CONSTRAINTS ───────────────────────────────>────────────────┐ ┌─────────────────────────<─────────────────────────────────────┘ └────┬─────────────────────────────────────────>──────────────┬─┐ ├──>
A
L
L ─────────────────────────────────>──────────────┤ │ ├──>
S
Y
S
T
E
M ──────────────────────────────>──────────────┤ │ ├──>
U
S
E
R ────────────────────────────────>──────────────┤ │ ├──┬──> name ────┬────────────────────────>──────────────┤ │ │ └───── , <────┘ │ │ └──>
F
O
R ───────┬──┬─> relation-name ──┬─┬──────────────┘ │ │ └─> view-name ──────┘ │ │ └───────────── , ────<───┘ │ │ ┌─────────────────────────<───────────────────────────────┘ │ └──┬───────────────>───────────┬─────────────> ├──>
I
N ─┬─> db-handle ──┬──┤ │ └────── , <─────┘ │ └──>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ──────┘ Lists the names and definitions of constraints.
DATABASES
SHOW DATABASES ───┬───────────────────┬───> ├──>
A
L
L ───────────┤ └──┬──> db-name ──┬─┘ └─────── , <───┘ Shows the currently invoked database file names, with their associated database handles. SHOW DATABASES ALL displays the path name of all databases defined at the current directory in the data dictionary. You do not have to invoke a database before you use the SHOW DATABASES ALL statement.
DATE_FORMAT
SHOW DATEFORMAT Displays the value for the date-number argument of the SET DATE_FORMAT statement.
DICTIONARY
SHOW DICTIONARY Shows the current default directory in the data dictionary.
FIELDS
SHOW FIELDS ───────────────────────────────────>────────────────┐ ┌─────────────────────────<─────────────────────────────────────┘ └────┬─────────────────────────────────────────>──────────────┬─┐ ├──>
A
L
L ─────────────────────────────────>──────────────┤ │ ├──>
S
Y
S
T
E
M ──────────────────────────────>──────────────┤ │ ├──>
U
S
E
R ────────────────────────────────>──────────────┤ │ ├──┬──> name ────┬────────────────────────>──────────────┤ │ │ └───── , <────┘ │ │ └──┬─────────────┬─>
F
O
R ───┬──┬─> relation-name ──┬─┬─>─┘ │ └┬─> name ───┬┘ │ └─> view-name ──────┘ │ │ └──── , <───┘ └───────────── , ────<───┘ │ │ ┌─────────────────────────<───────────────────────────────┘ │ └──┬───────────────>───────────┬─────────────> ├──>
I
N ─┬─> db-handle ──┬──┤ │ └────── , <─────┘ │ └──>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ──────┘ SHOW FIELDS lists the globally defined fields and their attributes. SHOW FIELDS FOR relation-name lists the local names of the fields and their locally defined attributes within the relation.
INDEXES
SHOW INDEXES ───────────────────>────────────────┐ ┌─────────────────────────<─────────────────────┘ └────┬─────────────────────────>──────────────┬─┐ ├──>
A
L
L ─────────────────>──────────────┤ │ ├──>
S
Y
S
T
E
M ──────────────>──────────────┤ │ ├──>
U
S
E
R ────────────────>──────────────┤ │ ├──┬──> name ────┬────────>──────────────┤ │ │ └───── , <────┘ │ │ └──>
F
O
R ───┬────> relation-name ─────┬──┘ │ └───────────── , ────<────┘ │ ┌────────────────<───────────────────<─────┘ └───┬───────────────>───────────┬─────────────> ├──>
I
N ─┬─> db-handle ──┬──┤ │ └────── , <─────┘ │ └──>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ──────┘ Shows the names and definitions of indexes.
LANGUAGE
SHOW LANGUAGE Displays the language that will be used for date and time input and display.
MONITOR
SHOW MONITOR Displays information about the Rdb/VMS monitor and users attached to a database.
PRIVILEGES
SHOW PRIVILEGES FOR ────┐ ┌───<───────────────┘ └────┬───>
D
A
T
A
B
A
S
E ───────────>─────────────────┬───> ├───>
R
E
L
A
T
I
O
N ──> relation-name ───────────┤ ├───>
V
I
E
W ──────> view-name ───────────────┤ └───>
F
I
E
L
D ─> field-name IN relation-name ─┘ Displays the access control list entry when Rdb/VMS matches your UIC with the identifier specified in the ACL entry. Although your UIC may match many ACL entries, Rdb/VMS stops when it finds the first match and grants you those access rights.
PROTECTION
SHOW PROTECTION FOR ────┐ │ ┌───<───────────────┘ └────┬───>
D
A
T
A
B
A
S
E ───────────>─────────────────┬───> ├───>
R
E
L
A
T
I
O
N ──> relation-name ───────────┤ ├───>
V
I
E
W ──────> view-name ───────────────┤ └───>
F
I
E
L
D ─> field-name IN relation-name ─┘ Displays the access control list for the named database, relation, field or view.
RADIX_POINT
SHOW RADIXPOINT Displays the character that will be used as the radix point in output displays. The radix point is the symbol that separates units from decimal fractions. For example, in the number 98.6, the period is the radix point.
RELATIONS
SHOW RELATIONS ─┬────────────┬─┬─────────────────────────┬─> ├─>
A
L
L ─────┤ ├─>
I
N ──┬─> db-handle ──┬┤ ├─>
S
Y
S
T
E
M ──┤ │ └─────── , <────┘│ ├─>
U
S
E
R ────┤ └─>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ─────┘ └─┬─> name ─┬┘ └──── , <─┘ Lists the names of the relations and the relation-specific constraints.
STORAGE_AREA
SHOW STORAGE AREAS ───────────────>──────────────────┐ ┌───────────────────────<────────────────────────────┘ └───────┬──────────────>──────────────┬──────────────┐ ├────>
A
L
L ────────>──────────┤ │ └──┬─> storage-area-name ──┬──┘ │ └──────<───── , <───────┘ │ │ ┌────────────────────────<───────────────────────────┘ └─────┬───────────────────>─────────────┬────────────────────> ├───>
I
N ───────> db-handle ──────┤ └───>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ───────────┘ Displays information about storage areas.
STORAGE_MAP
SHOW STORAGE MAPS ──────────────────────────────>────────────────┐ ┌─────────────────────────<─────────────────────────────────────┘ └────┬─────────────────────────────────────────>──────────────┬─┐ ├──>
A
L
L ─────────────────────────────────>──────────────┤ │ ├──┬──> name ────┬────────────────────────>──────────────┤ │ │ └───── , <────┘ │ │ └──┬─────────────┬─>
F
O
R ───┬────> relation-name ────┬─>─┘ │ └┬─> name ───┬┘ │ │ │ └──── , <───┘ └───────────── , ────<───┘ │ │ ┌─────────────────────────<───────────────────────────────┘ │ └──┬───────────────>───────────┬─────────────> ├──>
I
N ─┬─> db-handle ──┬──┤ │ └────── , <─────┘ │ └──>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ──────┘ Displays information about storage maps.
STREAMS
SHOW STREAMS ───┬──────────────────────────────┬──> ├──>
I
N ──┬──> db-handle ───┬──┤ │ └─────── , <──────┘ │ └──>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ─────────┘ Identifies the streams that are currently open.
TRANSACTION
SHOW TRANSACTION Displays information about the transaction mode, transaction id (TID), transaction sequence number (TSN), and, for read/write transactions, the status of updates and the full recovery-unit journal (RUJ) file specification.
TRANSFER
[VAX Data Distributor] To get HELP on the SHOW TRANSFER statement, see the entry for SHOW_TRANSFER under the main topic Data_Distrib.
TRIGGERS
SHOW TRIGGERS ───>────────────────────────┐ ┌────────────────────────────────────────┘ └───────┬───────────────>────────────┬─┐ ├───>
A
L
L ───────────────────┤ │ ├───>
S
Y
S
T
E
M ───────────────┤ │ ├───>
U
S
E
R ─────────────────┤ │ ├┬──> trigger-name ─┬────────┤ │ │└───── , <─────────┘ │ │ └─>
F
O
R ─┬─> relation-name ─┬┘ │ └───────── , <─────┘ │ ┌─────────────────────<────────────────┘ └─┬────>─────────────────────┬─────────────> └─>
I
N ─┬─
A
L
L
D
A
T
A
B
A
S
E
S ─┬┘ └┬─ db-handle ──┬─┘ └───── , <─────┘ Displays trigger names and definitions of the specified triggers for a specified database or all invoked databases.
USERS
SHOW USERS ────┬──────────────────────────────┬─> ├─>
I
N
D
A
T
A
B
A
S
E ──> db-handle ─┤ └─>
I
N
A
L
L
D
A
T
A
B
A
S
E
S ──────────┘ Displays information about active database users on a VAXcluster node.
VERSIONS
SHOW VERSIONS Displays all versions of the Rdb/VMS components you are running.