SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-9
VERSIONS Table
VERSIONS Table
The VERSIONS table is a catalog table that stores version information about the
catalog. The version information is also replicated in the SQL.CATALOGS table.
Table V-1 describes the contents of the VERSIONS table.
The columns SUBSYSTEMNAME through CATALOGCLASS (1 through 4) were
created in version 1. The columns CATALOGVERSION and CATALOGFORMAT
(5 through 6) were added in version 300.
Views
A view is a logical table created with the CREATE VIEW statement and derived by
projecting a subset of columns, restricting a subset of rows, or both, from one or more
base tables or other views. A view has a file label but has no actual data separate from
the data in the tables on which it is defined.
A view name must be a Guardian name. The fully expanded name of the view must be
unique among object names in the network.
A view is either a protection view or a shorthand view:

A protection view is derived from a single table and can be read, updated, and
secured.

A shorthand view is derived from one or more tables or other views. A shorthand
view can be read but cannot be updated. A shorthand view can be secured for
purge authority, but any user who has read access to the tables and views
underlying the view can read the view.
Table V-1. The VERSIONS Table
Column Name Data Type Description
1 SUBSYSTEMNAME * CHAR(30) Name of subsystem where catalog
resides
2 VERSION CHAR(4) Version of catalog: A010=1,
A011=2, ...A315=315, and so forth
3 VERSIONUPGRADETIME LARGEIN
SIGNED
Julian timestamp for last upgrade
or downgrade of catalog
4 CATALOGCLASS CHAR(1) S if system catalog
U if user catalog
5 CATALOGVERSION SMALLINTUNSIGNED Version number of catalog
6 CATALOGFORMAT SMALLINTUNSIGNED Format number of catalog (version
number of oldest software that can
read or write the catalog)
* Indicates primary key