RESTART-ROWID attribute

Specifies the ROWID of the data source row at which a FILL operation will start. Set this attribute before each FILL operation in a series of FILL operations to retrieve data source rows in batches. You typically set this attribute by assigning the value of the NEXT-ROWID attribute, which is set by the AVM after each FILL operation.

Data type: ROWID

Access: Readable/Writeable

Applies to: Data-source object handle

Syntax

RESTART-ROWID ( buffer-sequence-number | buffer-name )

buffer-sequence-number

An integer that represents the sequence number of a buffer in the list of buffers for the data-source object. Specify buffer-sequence-number to identify a buffer in the data-source object when the data-source object is defined against more than one database table buffer. The default is the first (or only) buffer in the data-source object.

Note: Sequence numbers for buffers in a data-source object start at one, where one represents the top level and subsequent numbers represent lower levels of join, if any.

buffer-name

A CHARACTER expression that evaluates to the name of a buffer in the list of buffers for the data-source object.

If an invalid buffer is specified, this attribute returns the Unknown value (?).

When specified, the next FILL operation using this data source opens its associated query and tries to reposition the query to the given ROWID. If the reposition is successful, the AVM proceeds with the FILL operation. If the reposition is not successful, the AVM sets the RESTART-ROWID attribute to the Unknown value (?) and proceeds with the FILL operation from the top of the query at the current level (that is, without repositioning the query).

This attribute is not marshalled between the client and the application server.

See also

BATCH-SIZE attribute, FILL( ) method, NEXT-ROWID attribute, RESTART-ROW attribute