SQL/MP Programming Manual for C

HP NonStop SQL/MP Programming Manual for C—429847-008
11-1
11
Character Processing Rules (CPRL)
Procedures
A C program can call character processing rules (CPRL) procedures to process these
collation objects:

SQL collation––A NonStop SQL/MP object with file code 941 generated
by the CREATE COLLATION statement

Collation object––A Guardian file with file code 199 generated by the
NLCP compiler
Table 11-1 summarizes the CPRL system procedures. These procedures are listed
alphabetically.
Table 11-1. Character Processing Rules (CPRL) Procedures (page 1 of 2)
Procedure Description
CPRL_ARE_ Determines if all characters in a string are in the
character class defined by the specified SQL
collation or collation object
CPRL_AREALPHAS_ Determines if all characters in a string are in the
ALPHAS character class according to the specified
SQL collation or collation object
CPRL_ARENUMERICS_ Determines if all characters in a string are numeric
according to the specified SQL collation or collation
object
CPRL_COMPARE1ENCODED_ Compares two strings (one encoded) according to
the collation defined by an SQL collation or collation
object
CPRL_COMPARE_ Compares two strings (neither encoded) according
to the collation defined by an SQL collation or
collation object
CPRL_COMPAREOBJECTS_ Compares two SQL collations or collation objects
CPRL_DECODE_ Decodes a string that has been encoded by
CPRL_ENCODE_
CPRL_DOWNSHIFT_ Downshifts a character string according to the
downshift rules in the specified SQL collation or
collation object
CPRL_ENCODE_ Encodes a character string for comparison purposes
CPRL_GETALPHATABLE_ Extracts ALPHAS character class information from
an SQL collation or collation object