RE: subfile page up & down using embedded SQL

I've never experimented, so couldn't tell you about the relative
performance.

The FETCH RELATIVE does use the ORDER BY sequence and if there are fewer
available records than specified, the SQLCOD field should be updated with a
non-zero value.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx


<clip>
AWESOME!  Can I presume that a "FETCH RELATIVE -20" is more efficient than
doing a "FETCH PRIOR" in a loop 20 times?  And, just to clarify, is it
RELATIVE to the access path defined by the ORDER BY? (And _not_ by RRN?)

What happens if it causes the cursor to hit BOF (or EOF when using RELATIVE
+nn)?
<clip>