SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
B-1
B
BACKUP Utility
BACKUP is a Guardian utility program, executed from TACL, that copies Guardian files
and SQL objects from disk to magnetic tape. (A complementary utility program,
RESTORE, copies Guardian files and SQL objects from the magnetic tape to the disk.)
For more information about BACKUP, see the Guardian Disk and Tape Utilities
Reference Manual.
BASETABS Table
The BASETABS table is a catalog table that describes attributes that apply to tables,
but not to views. Table B-1 describes the contents of the BASETABS table.
The BASETABS table was created in version 1, and there have been no changes in
subsequent versions.
If a table is partitioned, the BASETABS table has one entry for each partition. Guardian
names in the BASETABS table are fully qualified and use uppercase characters.
Table B-1. The BASETABS Table
Column Name Data Type Description
1 TABLENAME CHAR (34) Name of table (primary key)
2 CONSTRAINTS CHAR (1) Y if table has constraints
N if no constraints
3 ALLINDEXESHERE CHAR (1) Y if all indexes for table are described in the same
catalog
N if some indexes are described in other catalogs
4 FILENAME CHAR (34) Name of file for table
5 STATISTICSTIME LARGEINT
SIGNED
Time when statistics for table were last updated, in
GMT.
6 ROWCOUNT LARGEINT
SIGNED
Number of rows in table or partition of table
identified by TABLENAME (updated by UPDATE
STATISTICS)
7 ROWSIZE SMALLINT
UNSIGNED
Maximum byte length of a row of the table on disk
(packed record length)
8 VALIDDEF CHAR (1) Y if file has a valid definition, correct file label, and
catalog entries
N if not
9 VALIDDATA CHAR (1) Y if data in table is consistent with data in indexes
and satisfies constraints on table
N if not