Measure Reference Manual

LISTGNAME
The LISTGNAME command translates an OSS file pathname (in Measure G09 and later PVUs) or
an ANSI SQL name (in Measure H01 and later PVUs) to its corresponding Guardian file name
and creation version serial number (CRVSN). In the case of file name reuse, the CRVSN identifies
a specific instance of a Guardian file name.
If the OSS file pathname specified identifies a directory, the contents of the directory are listed.
Subdirectories of a directory are listed by their OSS file pathname, and files are listed by their
Guardian file name and fully qualified OSS file pathname.
The OSS file pathname translation is affected by the current MEASCOM session and the type of
data files being added or deleted. These examples describe how this pathname translation is
determined:
MEASCOM Session HistoryBasis for OSS File Pathname Translation
MEASCOM session is not performing an ADD MEASUREMENT command,
or MEASCOM session is performing an ADD MEASUREMENT command
OSS file-system interfaces
for an active data file or a data file from the current system that does not
contain an OSS journal segment.
MEASCOM session is performing an ADD MEASUREMENT command for
a data file that contains an OSS journal segment.
Content of the OSS journal
MEASCOM session is performing an ADD MEASUREMENT command for
a data file that does not contain an OSS journal segment, and the data file
is not from the current node. An error message appears.
Cannot be determined
Syntax
LISTGNAME [ / OUT filename / ]
{ “pathname” }
{ ‘{TABLE|INDEX} [[catalog.]schema.]object[ PARTITION partition]’ }
OUT filename
directs command output to filename. If filename does not exist, MEASCOM creates an
EDIT file by that name and writes command output to it. If filename does exist, MEASCOM
opens the file and appends the command output to it.
“pathname”
is a fully qualified and valid OSS file pathname or a partial OSS file pathname. OSS file
pathnames are case-sensitive and must be specified within double quotation marks (" ").
To get a fully qualified and valid OSS file pathname, combine name with the current OSSPATH
setting. If the OSS file pathname does not begin with a backslash (/), expand it by putting the
current setting for OSSPATH before the backslash.
'{TABLE|INDEX} [ [ catalog. ] schema. ] object [ PARTITION partition ]'
(Measure H01 and later PVUs) are ANSI SQL identifiers used in a fully qualified ANSI SQL
name. A fully qualified ANSI SQL name requires either a TABLE or an INDEX, optionally
followed by a PARTITION.
Usage Notes
• OSS file pathnames can be long and have the potential to exceed both the display width of
a screen and the maximum line length of a Guardian EDIT file. Output containing long OSS
file pathnames wraps to subsequent lines of the display or edit file in 80-character segments.
• These warning or error messages might appear:
3116 Unable to translate OSS file pathname.
98 MEASCOM Commands