SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Using Guardian Names With TMF, RDF, and
Measure
HP NonStop SQL/MX Installation and Management Guide—523723-004
B-7
MXGNAMES Examples
NAME PART_A_Z_1
)
;
The resulting contents of file NAMELST would be:
(-- Table CAT.SCH.T126A -- &
$vol1.zsd0126a.bxnl1r*,&
$vol2.zsd0126a.bxnl2r*,&
$vol3.zsd0126a.bxnl3r*,&
$vol4.zsd0126a.bxnl4r*,&
$vol5.zsd0126a.bxnl5r*,&
$vol6.zsd0126a.bxnl6r*,&
&
-- index T126A_NDX1 on CAT.SCH.T126A -- &
$vol1.zsd0126a.qdxwg1*,&
$vol2.zsd0126a.qdxwg2*,&
$vol3.zsd0126a.qdxwg3*,& $vol4.zsd0126a.qdxwg4* &
-- end of Table CAT.SCH.T126A) --
TMF Example 3: Input Is an SQL/MX Table Name
MXGNAMES CAT.SCH.T126A -output=NAMELSTX -TMF
In this case, the contents of NAMELSTX would be identical to the output file of the
previous example.
TMF Example 4: Input Is a List of SQL Names with File
Length Specified
MXGNAMES -SQLNames=$VOL1.SQLSTUFF.SQLNAMES -output=NAMELIST –TMF
–length=28000
The -length option specifies that output files should be limited to a length of 28000
bytes or 900 names, whichever comes first. If the output exceeds 28000 bytes, the first
additional file generated would be called NAMELIS2. If ten output files are needed, the
tenth output file would be called NAMELI10. If an output file reaches a total of 900 file
names, output to that file stops, and output to another file is started, regardless of the
specified output file length. Each additional output file name is displayed to standard
output as that file is started.
The file length can be used to allow additional text to be added to the TMF command
file (in addition to the text generated by MXGNAMES), without exceeding TMF’s
28000-byte limit.
Additional files will or will not contain comments, depending on the use of the
-nocomment option. If comments are present, each continuation file will contain one