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-4
MXGNAMES Examples
MXGNAMES Examples
For these MXGNAMES examples, suppose that these SQL/MX tables and indexes
exist on the system:
create table cat.sch.t126a
(c1 int not null
, c2 timestamp default current_timestamp not null
, c3 char(4) default ’abcd’
, c4 smallint not null
, primary key (c1,c2))
location $vol1.zsd0126a.bxnl1r00
partition
(add first key (1r00) location $vol2.zsd0126a.bxnl2r00
, add first key (2r00) location $vol3.zsd0126a.bxnl3r00
, add first key (3r00) location $vol4.zsd0126a.bxnl4r00
, add first key (4r00) location $vol5.zsd0126a.bxnl5r00
, add first key (5r00) location $vol6.zsd0126a.bxnl6r00)
store by primary key;
create index t126a_ndx1 on cat.sch.t126a(c4)
location $vol1.zsd0126a.qdxwg100
partition
(add first key (100) location $vol2.zsd0126a.qdxwg200
, add first key (500) location $vol3.zsd0126a.qdxwg300
, add first key (700) location $vol4.zsd0126a.qdxwg400)
;
create table cat.sch.t126b
(c1 timestamp default current_timestamp not null
, c2 int not null
, c3 varchar (30)
, primary key (c3, c1))
location $vol1.zsd0126b.bxnw1r00
hash partition by (c4)
(add location $vol2.zsd0126b.bxnw2r00
, add location $vol3.zsd0126b.bxnw3r00
, add location $vol4.zsd0126b.bxnw4r00)
;
create unique index t126b_ndx1 on cat.sch.t126b(c2, c1)
location $vol1.zsd0126b.qdx1g100
hash partition by (c2)
(add location $vol2.zsd0126b.qdx1g200
, add location $vol3.zsd0126b.qdx1g300
, add location $vol4.zsd0126b.qdx1g400
, add location $vol5.zsd0126b.qdx1g500)
;
TMF Example 1: Input Is a List of SQL/MX Table Names
MXGNAMES -SQLNames=$VOL1.SQLSTUFF.SQLNAMES -output=NAMELIST -TMF
In this example, the input is a file list of fully qualified SQL/MX table names. If the
contents of the file SQLNAMES is:
CAT.SCH.T126A
CAT.SCH.T126B