The DEFINE COLLATING_SEQUENCE statement identifies a collating
 sequence that has been defined using the VMS National Character Set
 (NCS) Utility.  Use the DEFINE COLLATING_SEQUENCE statement to
 identify collating sequences other than the database default
 collating sequence that you plan to use with certain global fields.
 (The default collating sequence for a database is established by the
 COLLATING_SEQUENCE IS clause in the DEFINE DATABASE statement; if you
 omit that clause at database definition time, the default sequence is
 ASCII.)

 You must enter a DEFINE COLLATING_SEQUENCE statement specifying a
 collating sequence before you enter the name of that sequence in any
 of the following statements:

  o  DEFINE FIELD...COLLATING_SEQUENCE

  o  CHANGE FIELD...COLLATING_SEQUENCE


 You must execute this statement in a read/write transaction.  If
 there is no active transaction and you issue this statement, Rdb/VMS
 starts a read/write transaction implicitly.

 Other users are allowed to be attached to the database when you issue
 the DEFINE COLLATING_SEQUENCE statement.

Additional information available:

FormatMoreExamples

 DEFINE COLLATINGSEQUENCE sequence-name ──┐
   ┌───────────────────<───────────────────┘
   └──┬────────────────>─────────────────┬──┐
      └─> 
D
E
S
C
R
I
P
T
I
O
N 
I
S ──> typebox (/)typebox (*) text */ ─┘  │
          ┌────────────────<────────────────┘
          └─> ncs-name ─┬────────────>──────────┬──> .
                        └─> 
F
R
O
M library-name ──┘

Additional information available:

sequence-nametextncs-namelibrary-name

 Specifies the name by which the collating sequence named in the
 ncs-name argument will be known to the database.  The sequence-name
 and ncs-name arguments can be the same.

 Adds a comment about the collating sequence.  RDO displays the text
 when it executes a SHOW COLLATING_SEQUENCE statement.

 Specifies the name of a collating sequence in the default NCS
 library, SYS$LIBRARY:NCS$LIBRARY, or in the NCS library specified by
 the argument library-name.  You can view the collating sequence names
 by using the command NCS/LIST at DCL level.

 The collating sequence can be either one of the pre-defined NCS
 collating sequences or one that you have defined yourself using NCS.

 Specifies the name of an NCS library other than the default.  The
 default NCS library is SYS$LIBRARY:NCS$LIBRARY.

 To define a collating sequence using the DEFINE COLLATING_SEQUENCE
 statement, you must have the Rdb/VMS DEFINE privilege for the
 database.

 The DEFINE COLLATING_SEQUENCE statement is the first step in
 specifying an alternate collating sequence.  After you define the
 collating sequence, you must specify that it will apply to a
 particular field or database.  The following list shows abbreviated
 forms of the statements that will associate the collating sequence
 with a particular field or database:

  o  DEFINE FIELD ...  COLLATING_SEQUENCE sequence-name;

  o  DEFINE DATABASE ...  COLLATING_SEQUENCE sequence-name;

  o  IMPORT ...  COLLATING_SEQUENCE sequence-name;

 Use the complete form of the following statement to alter a collating
 sequence after you have associated it with a field:

  o  CHANGE FIELD ...  COLLATING_SEQUENCE sequence-name;

 The following example creates a collating sequence using the
 pre-defined collating sequence FRENCH.  It then shows the defined
 collating sequence by using the SHOW COLLATING_SEQUENCE statement:

 RDO> INVOKE DATABASE FILENAME 'MF_PERSONNEL'
 RDO> DEFINE COLLATING_SEQUENCE FRENCH FRENCH.
 %RDO-W-NOCDDUPDAT, database invoked by filename, the CDD will not be
 updated
 RDO> !
 RDO> SHOW COLLATING_SEQUENCE
 User Collating Sequences in Database with filename mf_personnel
      FRENCH