RE: RPG chain = ?? in VB

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>This should position the cursor to JOHNSON and the recordset will
>contain all last names after JOHNSON. 

IMHO, one of the most important differences between native (RPG, Cobol,
etc.) programming and client/server programming is what we tell the
system.

In "classic" server programming we told the system where to start and we
simply read the records until we were finished; that might be until the
end of the file, or it might just be until the last name changed. In
client/server it's important to tell the system where we want to start
AND where we want to end. 

You could open a server-side cursor and simply read until you were done,
however that has two disadvantages, first the system may chose a
different access plan if it knows you're only reading some records, and
second, server-side cursors hold the connection open the whole time
you're reading rows. If you're VB app is client/server in the sense that
each PC will have it's own copy that's not a big deal, since each PC
will have a connection to the iSeries anyway. But if your VB app is part
of a web based system where many clients will be sharing the connection
object you want to use the release that connection object as fast as you
can so the next client can use the same connection. To do this you want
to use client side cursors (adUseClient constant) and that results in a
download of all rows that meet your selection criteria. If your
selection criteria is too broad you'll waste time downloading rows you
don't care about.

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)