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.
1 – Format
(B)0[m[4mDEFINE[m [4mCOLLATING_SEQUENCE[m sequence-name qqk
lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqj
mqqwqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqwqqk
mq> [4mDESCRIPTION[m [4mIS[m qq> /* text */ qj x
lqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj
mq> ncs-name qwqqqqqqqqqqqq>qqqqqqqqqqwqq> .
mq> [4mFROM[m library-name qqj
1.1 – 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.
1.2 – text
Adds a comment about the collating sequence. RDO displays the
text when it executes a SHOW COLLATING_SEQUENCE statement.
1.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.
1.4 – 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;
3 – 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