Manualshelf

SQL/MX Comparison Guide for SQL/MP Users

ManualsBrandsHP ManualsServerHP NonStop G-Series
101102103104105106107108109110
Utility Differences
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
7-3
SHOWLABEL Command
objects. This output can be used to re-create the specified object, including its
dependent objects.
SHOWDDL is similar to SQL/MP’s INVOKE command, which produces a record
description that corresponds to a row in a specified table or view.
See “MXCI Commands” in the SQL/MX Reference Manual for more information.
SHOWLABEL Command
SQL/MX’s SHOWLABEL command displays file-label and resource-fork information for
SQL/MX tables, worktables, views, and indexes. The information includes the object
version, physical location, and other characteristics.
Every SQL object includes a logical file label to store the object’s file attributes and
information about its dependent objects. The resource fork is a new file that contains
structural descriptions of a table. When an SQL/MX object is created, two physical files
are instantiated: the data fork and the resource fork. The data fork is where the user
data resides. The resource fork contains structural information, such as the partition
map.
SHOWLABEL is similar to SQL/MP’s FILEINFO utility, which displays information
about the versions and physical characteristics of tables, indexes, views, collations,
Enscribe files, and OSS files.
For more information, see “MXCI Commands” in the SQL/MX Reference Manual.