RE: Embedded SQL - count(*)

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>What is the best reference for using the
>language for RPG/ILE, and where can I find it?

I can't really say anything about 'best'; I'd bet any of the books at
http://www.midrange.com (our host) would be worth buying.  I myself learnt
SQL in the dark ages and can't remember what the stumbling blocks were
anymore.  Basically, there's not much difference between using embedded SQL
in RPG or Cobol or even ReXX.  I don't know that there's much 'special'
stuff you need in RPG to use SQL aside from /exec sql and /end-exec.  There
are some FAQ entries that might help, but it's thin.

The key thing I think is to remember that SQL likes to deal with blocks of
records and not singles.  So I would not try to replace CHAINs with FETCHes
'just because I can.'  Rather, think of places where you might have a
SETLL/READE loop and replace that with a single UPDATE.  Something along the
lines of tagging all the records between 010101 and 123101 as 'ready to
archive'.
  --buck