SQL/MP Programming Manual for C

Character Processing Rules (CPRL) Procedures

HP NonStop SQL/MP Programming Manual for C—429847-008

11-19

CPRL_GETSPECIALTABLE_

The CPRL_GETSPECIALTABLE_ procedure extracts SPECIALS character class

information from an SQL collation or collation object, if the SPECIALS character class

exists.

If the SPECIALS character class does not exist, CPRL_GETSPECIALTABLE_ creates

it. In this case, characters are considered SPECIALS if they are not ALPHAS or

NUMERICS. (The ALPHAS and NUMERICS character classes exist in all SQL

collations or collation objects.)

The CPRL_GETSPECIALTABLE_ procedure returns these values:

array

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

is a pointer to the SQL collation or collation object.

#include <cextdecs(CPRL_GETSPECIALTABLE_)>

short CPRL_GETSPECIALTABLE_ (

char *array /* o */

,long cprladdr ); /* i */

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 SPECIALS character class.

0 The corresponding character code in the SQL collation or collation object

is not in the SPECIALS character class.