SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-131
CPRLSRCE Table
CPRLSRCE Table
The CPRLSRCE table is a catalog table that contains source definitions for each
collation described in the CPRULES table. Table C-9 lists the contents of the
CPRLSRCE table.
The CPRLSRCE table was added in version 300.
Guardian names in the CPRLSRCE table are fully qualified and use uppercase
characters.
CPRULES Table
The CPRULES table is a catalog table that contains one row for each collation.
Table C-10 describes the contents of the CPRULES table.
The CPRULES table was added in version 300.
Guardian names in the CPRULES table are fully qualified and use uppercase
characters.
Table C-9. The CPRLSRCE Table
Column Name Data Type Description
1 CPRULESNAME * CHAR(34) Collation name
2 SEQNUMBER * SMALLINT
UNSIGNED
Sequence number for the source line; first line has
SEQNUMBER = 1
3 TEXT VARCHAR
(256)
Source text
* Indicates primary key
Table C-10. The CPRULES Table
Column Name Data Type Description
1 CPRULESNAME * CHAR(34) Collation name
2 CHARACTERISTICS CHAR(1) Properties of the collation: O, if only
identical strings sort equal N, if some
nonidentical strings sort equal
3 CPRULESCLASS CHAR(1) Always U.
4 CPROBJSIZE INTEGER
UNSIGNED
Minimum size of buffer needed to store
object
5 CHARACTERSET CHAR (30) Name of character set assumed by the
collation
6 CPRULESVERSION SMALLINT
UNSIGNED
Version number of most recent version
feature used in collation
* Indicates primary key