background image
<< stored-procedure | guidelines >>
<< stored-procedure | guidelines >>

To automatically retrieve the final row

Creating Vuser Scripts
Chapter 10, page 166
Database Vuser Scripts · Correlating Database Statements
In
The correlation functions have the following syntax:
lrd_save_col (cursor, col_number, row_number, option, "parameter_name");
lrd_save_value (
&descriptor, index, 0, "parameter_name");
lrd_save_ret_param (
cursor, return_param, option, "parameter_name");
If you specify a row number that does not exist, lrd_save_col retrieves the last
row in the result set. To automatically retrieve the final row in the result set, specify
0 for the row_number parameter.
The option parameter for lrd_save_col specifies whether to set the specified
parameter by the immediately following lrd_fetch only, or by all subsequent calls to
lrd_fetch:
0
Following
: Set the parameter by the immediately following
lrd_fetch only (default).
1
Any
: Set the parameter by all lrd_fetch calls for the current
statement (advanced users).