If you're knowledgeable about RPG, C, OPNQRYF, CL, MI, PL/I, BASIC, FORTRAN,
HTML, and C, why haven't you learned SQL yet?
I suppose he could have countered with:
"Why haven't you learned to delegate yet? After all, I can update a file without
writing a single line of code." <tic>
Sometimes it is important to use a backhoe to dig a hole in the grown.
Sometimes a shovel is best.
If you have a large hole to dig, a shovel can do it, but it is a stupid tool to
use.
If you have a 10 inch hole to dig, a backhoe is a stupid tool to use.
Having said that, for one-off thing, SQL is almost always the right tool to use.
But if you have RPG skills, or C skills or whatever, use that tool. The goal
isn't the tools it's the results. (Unless you're talking about .Net, then it is
almost always the wrong tool for the job.)
-Bob Cozzi
www.i5PodCast.com
Ask your manager to watch i5 TV
-----Original Message-----
From: rpg400-l-bounces+bob=rpgworld.com@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces+bob=rpgworld.com@xxxxxxxxxxxx] On Behalf Of Wilt,
Charles
Sent: Thursday, April 26, 2007 7:09 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Chalk one up for "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.
And everybody else point is that what you did in two lines with the cycle could
have been done in 1
with SQL.
If you're knowledgeable about RPG, C, OPNQRYF, CL, MI, PL/I, BASIC, FORTRAN,
HTML, and C, why haven't
you learned SQL yet? It's certainly not new and who knows, you may find that it
can often reduce your
effort by 50%.
Has far as not having STRSQL, that's not a big deal. You could have simply used
iSeries Navigator's
"Run SQL Scripts". Before you say anything, no you don't need a iSeries Access
license to use iSeries
Navigator. Many third party options also exist that allow you to run SQL
statements against the
iSeries from you PC.
Charles
This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a named
addressee you are hereby notified that you are not authorized to read, print,
retain, copy or disseminate this communication without the consent of the sender
and that doing so is prohibited and may be unlawful. Please reply to the
message immediately by informing the sender that the message was misdirected.
After replying, please delete and otherwise erase it and any attachments from
your computer system. Your assistance in correcting this error is appreciated.
midrange.com
