Re: SQL & Query (was AS/400 undeserved "closed system" moniker)

I have used STRSQL ... is that the command line interactive SQL you are
referring to.

STRSQL is more flexible than WRKQRY in terms of all the stuff you can do, but
perhaps due to me having more practice with WRKQRY it seems like I have to
jump through more hoops with STRSQL to get equivalent amount of work done.

Recently I figured out what I think is some rather sophisticated BPCS stuff
using purely Query against earlier data bases, using a series of query work
files, to get at a list of raw materials we have in inventory that are used
only by specific end customer parts, listed with date of last shipment, that
are not on schedule right now ... at run time the user selects cut-off of
last shipment of end items to get list of raw materials unique to those
parts.  I developed it interactively, but by the time I am done it will be
completed via JOBQ.

If I have a requirement that is more involved than can be done in RUNQRY, I
usually write an RPG program to run it & often have embedded SQL in the RPG.

I have written a few OPNQRYF but not yet experienced at it.
Seemed to me like an enormous amount of work to perfect the software, not as
intuitively obvious as other programming methods.

> >>database access:
>  >>Can you write a 3rd party query tool that has the same performance as
>  >RunQry?
>  >I have a command line interactive SQL.  Does that count?
>
>  How does it work?
>
>  Does it call the undocumented qdm* pgms that rpg400 calls?
>
>  Is performance comparable to opnqryf and query?

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)