1  DEFINE_COLLATING
   The DEFINE COLLATING_SEQUENCE statement identifies a collating
   sequence that has been defined using the OpenVMS 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,
   Oracle Rdb starts a read/write transaction implicitly.

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

2  Format

 (B)0DEFINE COLLATING_SEQUENCE sequence-name qqk
   lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqj
   mqqwqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqwqqk
      mq> DESCRIPTION IS qq> /* text */ qj  x
          lqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj
          mq> ncs-name qwqqqqqqqqqqqq>qqqqqqqqqqwqq> .
                        mq> FROM library-name qqj

 

3  sequence-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.
 

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

3  ncs-name
   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.
 

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

2  More
   To define a collating sequence using the DEFINE COLLATING_
   SEQUENCE statement, you must have the Oracle Rdb 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;
 

2  Examples
   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 data dictionary will not be
   updated
   RDO> !
   RDO> SHOW COLLATING_SEQUENCE
   User Collating Sequences in Database with filename mf_personnel
        FRENCH