SQL/MP Programming Manual for COBOL

Character Processing Rules (CPRL) Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
11-12
CPRL_GETALPHATABLE_
encodedstringmaxlength pic S9(4) input
specifies the maximum length of encodedstring.
encodedstringlength pic S9(4) output
is the number of bytes of decodedstring that were encoded. CPRL_ENCODE_
pads the remainder of decodedstring with encoded blanks up to
decodedstringmaxlength.
cprladdr pic S9(9) input
is a pointer to the SQL collation or collation object.
CPRL_GETALPHATABLE_
The CPRL_GETALPHATABLE_ procedure extracts ALPHAS character class
information for single-byte character sets from an SQL collation or collation object.
The CPRL_GETALPHATABLE_ procedure returns these error codes:
array pic X(256) output
is a 256-byte array specified by the user. If the call is successful,
CPRL_GETALPHATABLE_ sets each byte in array as follows:
If the call is unsuccessful, array is not modified.
cprladdr pic S9(9) input
is a pointer to the SQL collation or collation object.
ENTER TAL "CPRL_GETALPHATABLE_" USING
array,
cprladdr
GIVING errorcode.
Code Description
0 The operation was successful.
–2 The SQL collation or collation object is invalid.
–4 The version of the SQL collation or collation object is not supported.
1 The corresponding character code in the SQL collation or collation object
is in the ALPHAS character class.
0 The corresponding character code in the SQL collation or collation object
is not in the ALPHAS character class.