SQL/MP Programming Manual for COBOL

HP NonStop SQL/MP Programming Manual for COBOL—529758-003
11-1
11
Character Processing Rules (CPRL)
Procedures
This section describes CPRL procedures that a COBOL program can call to process
these collation objects:

SQL collation—An 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
collation compiler ($system.system.NLCPCOMP)
Table 11-1 summarizes the CPRL procedures. These procedures are alphabetically
described in detail on subsequent pages in this section.
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