SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-137
CREATE COLLATION Statement
CREATE COLLATION Statement
CREATE COLLATION is a DDL statement that creates a collation.
name
is a Guardian name (or an equivalent DEFINE) that is the name of the new
collation.
If SMF is installed on your node, the volume portion of name can be a virtual or
direct volume. If you specify only a subvolume, SQL creates a new collation object
in the current default volume. If the default volume is virtual, the collation resides
on the virtual volume. If the default volume is direct, the collation resides on the
physical volume as a direct file not managed by SMF.
FROM source
directs SQL to create the new collation by calling the collation compiler to compile
the definition in the EDIT file source (or an equivalent DEFINE). For information
about the contents of source, see Collation Definitions on page C-30.
If the compilation fails, SQL returns an error and does not update the catalog or
create the collation. The error message includes the name of a file that contains
diagnostic information about the compilation. For information about the diagnostic,
see the SQL/MP Messages Manual.
LIKE coll [ WITH COMMENTS ]
directs SQL to create the new collation like an existing collation coll. coll is a
collation name or an equivalent DEFINE. SQL does not include comments from
coll in the new collation unless you specify WITH COMMENTS.
CATALOG catalog
is the name of the catalog (or an equivalent DEFINE) in which to register the new
collation. If you omit the CATALOG clause, SQL uses the current default catalog.
PHYSVOL volume-name
If SMF is installed on your node, the PHYSVOL option directs SQL to override
SMF and place the collation object on the physical volume volume-name. For
volume-name, specify either a physical volume or equivalent DEFINE. Do not
include the node name in your volume name.
This option is available only if you specify a virtual volume for name. volume-
name must belong to the virtual volume you specify.
CREATE COLLATION name { FROM source }
{ LIKE coll [ WITH COMMENTS ] }
[ CATALOG catalog ] [ PHYSVOL volume-name ]