SQL/MP Programming Manual for C

Character Processing Rules (CPRL) Procedures

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

11-20

CPRL_GETUPSHIFTTABLE_

The CPRL_GETUPSHIFTTABLE_ procedure extracts upshift information from an SQL

collation or collation object.

The CPRL_GETUPSHIFTTABLE_ 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 to the

upshifted version of the corresponding character code in the SQL collation or

collation object.

If the call is unsuccessful, array is not modified.

cprladdr

is a pointer to the SQL collation or collation object.

CPRL_INFO_

The CPRL_INFO_ procedure returns information about an SQL collation or collation

object. (The SQL CREATE COLLATION statement uses this procedure to determine

the characteristics of SQL collations.)

#include <cextdecs(CPRL_GETUPSHIFTTABLE_)>

short CPRL_GETUPSHIFTTABLE_ (

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.

#include <cextdecs(CPRL_INFO_)>

short CPRL_INFO_ (

long cprladdr /* i */

, [ short *cprlsize ] /* o */

,[ short *is1to1 ] /* o */

,[ short *lengtheningfactor ] /* o */

,[ short *characterset ] /* o */

,[ short *version ] ); /* o */