Re: Chalk one up for "The Cycle"

Yes, the same thing could be accomplished with Interactive
SQL. If I were as skilled in SQL as I am in RPG, C,
OPNQRYF, CL, MI, PL/I, BASIC, FORTRAN, HTML, &c. (which
I'm not). And if the box in question had Interactive SQL
(which it apparently doesn't). As such, even if that
option had been open to me, it obviously never occurred to
me, and even if it had occurred to me, it would have had
me poring over "SQL for Dummies" for about as long as it
took me to just do the damn thing and get it over with.

My point is that forcing a (repaired) update trigger to
trip on every record of a file, without actually changing
the file, would take a lot more lines of code to
accomplish in C, PL/I, or even a non-Cycle RPG program
(where it would take at least 6 lines, including either a
RETURN or a SETON LR, to suppress The Cycle).

And my point was aimed at those who insist that The Cycle
(which I see as one of the very few good reasons to use
RPG instead of some other language) is obsolete and
useless.

--
JHHL
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.