SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-138

Consideration—CREATE COLLATION

CREATE COLLATION requires read and write authority for the catalog in which the

new collation is registered. The FROM clause requires read authority for the source

file. The LIKE clause requires read authority for the existing collation coll and for the

associated catalog tables.

Example—CREATE COLLATION

This example statement creates a collation named TRANSL2 from the definition in the

EDIT file $DATA.COLL.TRANSL2:

CREATE COLLATION TRANSL2 FROM $DATA.COLL.TRANSL2;