DSM/Tape Catalog User's Guide

Database Design of DSM/TC

DSM/Tape Catalog User’s Guide — 520233-008

9 - 14

Shorthand Views

SQL shorthand views let you make customized reports based on the fields of the

DSM/TC database described in this section. These views can be used for read access

only because the DSM/TC database cannot be updated by software other than

DSM/TC.

These shorthand views do not change. They will always reflect the original database

structure regardless of future database enhancements.

For more information on using views, see the SQL/MP Installation and Management

Guide.

Table Name Shorthand View Name

CONFIG CONFGV10

TAPEFILE TFV10

TFTOV TFTOVV10

DISKFILE DFV10

DFTOV DFTOVV10

POOL POOLV10

POOLV20

VOLUME VOLV10

VOLV20

VTOFC VTOFCV10

VTOFCV20