The following variables are used for maintaining and querying the status of key lists.

Variable

Description

@CURSORS

A list of active cursors.

@LIST_ACTIVE

The flag that indicates whether there is an active select list in cursor 0, and what type of list it is.

Flag

Value

 0

 No select list active.

 1

Latent table-based list active.

 2

Latent index-based list active.

 3

Resolved list active.

@PRI_FILE

The file handle for the table represented in cursor zero.

@QUERY_DICT

The file handle for the dictionary represented in cursor zero.

@RECCOUNT

If there is an active, resolved select list, this variable contains the number of keys in the list.

@REDUCTION_DONE

Contains 1 if the key list in cursor 0 is completely resolved, otherwise it is null.

@RN_COUNTER

The ReadNext counter. Incremented for each row examined by the ReadNext statement. It must be initialized by the procedure to a starting value (usually zero).

  • No labels