SQL/MP Programming Manual for C

Character Processing Rules (CPRL) Procedures

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

11-16

CPRL_GETLAST_

The CPRL_GETLAST_ procedure finds the last string of a specified length according

to an SQL collation or collation object.

This procedure replaces the practice of using a string of binary ones to generate the

last string of a specified length, which does not work correctly for nonbinary collating

sequences.

The CPRL_GETLAST_ procedure returns these values:

laststring

is an array in which CPRL_GETFIRST_ returns the last string.

laststringmaxlength

specifies the maximum length of laststring.

laststringlength

specifies the number of bytes of laststring that were scanned. (If

CPRL_GETLAST_ is successful, laststringlength and

laststringmaxlength are equal.)

cprladdr

is a pointer to the SQL collation or collation object.

#include <cextdecs(CPRL_GETLAST_)>

short CPRL_GETLAST_ (

char *laststring /* o */

,short laststringmaxlength /* i */

,short *laststringlength /* 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.