SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-96
CONVERT Command
MAP NAME[S] { map }
{ ( map [ ,map ] ... ) }
overrides the default names (and locations) used to generate names for secondary
partitions of tables and for indexes.
map is:
simple-fileset-list TO files
simple-fileset-list
is a simple fileset list that specifies the secondary partitions and alternate-key
files of the Enscribe file to map. For more information about simple fileset lists,
see Filesets
on page F-29.
TO files
specifies the names and locations for the new partitions and indexes.
files is a Guardian name that can optionally contain an asterisk to indicate
that the portion of the name in which the asterisk appears should be the same
as the name of the corresponding portion of the source element in
simple-fileset-list. For example,
$VOL1.SUBV2.* TO *.PERSNL.*
specifies that the partitions or indexes will be on the volume and subvolume
$VOL1.PERSNL and will have the same names as the source objects.
If you specify more than one map and one conflicts with another, CONVERT uses
the first map.
If you do not specify the MAP NAMES option, CONVERT produces a command to
create a secondary partition on the same volume and subvolume as its
corresponding Enscribe file partition. CONVERT produces a command to create
indexes on the same volume and subvolume as the new table.
CATALOG[S] { catalog-spec }
{ ( catalog-spec [, catalog-spec ]...) }
specifies the catalogs in which to describe the target objects. catalog-spec is:
catalog-name [ FOR simple-fileset-list ]
catalog-name identifies the catalog to hold the descriptions of the objects.
FOR simple-fileset-list specifies which target objects to describe in the
catalog. Use the names of the converted objects, not the source objects or files. If
you omit this clause, the catalog is used for the descriptions of all target objects.
If you omit the CATALOGS option, SQL describes the new table and indexes in the
current default catalog.