RE: Call Query

["Mark A. Manske" <mmanske@xxxxxxxxxxxxxxxxxx>]

IMHO - it is true that you cannot force or even cost justify SQL on
companies;
however; I have seen "programmers" butcher opnqryf to the point of
uselessness
and some code has come to my attention from software vendors as well -

All in all, I feel that a well designed system (physical file, properly
designed logical files
can alleviate the need for opnqryf and even SQL; as I have seen my code run
much quicker
over a file coded as in setll, reade, if and when statements and is easier
to read
than the convoluted selections, and the creation of "temporary" logical
files.) is the
best way to go.  Unfortunately, I like most of us out here, have inherited
code that at the
time it was written, dinosaurs walked the earth (according to my teenage
daughter, so did I)
- so do your best with what you have, but
try to make it easier for the next person than it was for you.
Remember the first thing to do is document - not the last thing four months
after the project was implemented... ;)

Mark A. Manske
[mailto:mmanske@minter-weisman.com]
Sr. Project Lead
Minter-Weisman




-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Alan Addison
Sent: Monday, October 23, 2000 3:13 PM
To: RPG400-L@midrange.com
Subject: Re: Call Query


When you work with a software company that has companies from verrrrry small
to
large as clients, one can not "force" them to do anything they don't want
to.
So one has to deal with what you know will work on all machines.

Alan

rob@dekko.com wrote:

> All the more reason to avoid OPNQRYF.  There is no ease of maintenance.
> Instead use SQL.  People who stick with OPNQRYF belong to one of few
> categories.
> 1)  Work for cheap company which refuses to buy SQL.
> 2)  Create vendor software with mandate not to force customers to purchase
> SQL.  (When they've already had to purchase 400, rpg compiler, etc.)
> 3)  Have no s*e*x life and last conquest was figuring out OPNQRYF.
> 4)  Love to use primary files and can do that if they use OPNQRYF instead
> of SQL.
>
> Rob Berendt

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---