RE: RE: Can you do this in SQL

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Mark,

I think we agree that SQL is a shoehorn. I also think that
opnqryf is a shoehorn. So far, I think I am the only one to
propose a strait RPG method so since you ask, I think
it is likely to be as good or better than any solution involving
SQL or OPNQRYF.

David Morris

>>> mlazarus@ttec.com 01/29/02 03:05PM >>>
DAVID,

Original Message:
-----------------
I agree that this is not a good place to use SQL, but for
the same reason, OPNQRYF and a four line RPG program
are just as bad....snip...I would consider moving the rank to
another file and updating it froma short (but not four line)
trigger written in RPG.
--------------
 Why is shoehorning the functionality into SQL a better method?  What's
wrong w/ the straight RPG method?  Is your problem w/ OPNQRYF?  If yes,
why do you feel that it's so evil?

 -mark