SQL/MP Programming Manual for C

Character Processing Rules (CPRL) Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
11-2
cextdecs Header File
cextdecs Header File
The cextdecs header file contains source declarations for CPRL procedures, which
are written in TAL. Use the #include directive as shown in this example to copy the
declarations from the cextdecs header file for the procedures you want to call in your
program:
#include <cextdecs ( FILE_OPEN_ , /
WRITEREAD , /
FILE_CLOSE_ , /
CPRL_INFO_ , /
CPRL_UPSHIFT_ )> nolist
...
CPRL Return Codes
Each CPRL procedure returns specific codes, which are listed in each procedure
description. A return code of zero (0) indicates that the operation was successful.
All other CPRL return codes are negative, so they can be distinguished from
file-system errors, which are always positive. The condition code (CC) setting has no
meaning after the execution of a CPRL procedure.
CPRL_GETCHARCLASSTABLE_ Extracts character class information from an SQL
collation or collation object
CPRL_GETDOWNSHIFTTABLE_ Extracts downshift information from an SQL collation
or collation object
CPRL_GETFIRST_ Finds the first string of a specified length according
to an SQL collation or collation object
CPRL_GETLAST_ Finds the last string of a specified length according
to an SQL collation or collation object
CPRL_GETNEXTINSEQUENCE_ Finds the next string after a specified string
according to an SQL collation or collation object
CPRL_GETNUMTABLE_ Extracts numeric character class information from an
SQL collation or collation object
CPRL_GETSPECIALTABLE_ Extracts SPECIALS character class information from
an SQL collation or collation object
CPRL_GETUPSHIFTTABLE_ Extracts an array that might be used for upshifting
CPRL_INFO_ Returns information about a collation contained in an
SQL collation or collation object
CPRL_READOBJECT_ Reads an collation object (with file code 199) from a
Guardian file into a buffer
CPRL_UPSHIFT_ Upshifts a character string according to the upshift
rules in the specified SQL collation or collation object
Table 11-1. Character Processing Rules (CPRL) Procedures (page 2 of 2)