Re: SQL solution for copying subset of one file to another, based on a third's contents?

On 1/19/07, Buck <kc2hiz@xxxxxxxxx> wrote:

>> Look in the FAQ for RUNSQLSTM and you'll find an old but useful utility
>> that lets you run any SQL statement from a CL command line.
>> http://faq.midrange.com
>
> I realize this is stretching way back, since it appears you were limited
to
> old RPG, but do you remember if there was a reason why you (or the
original
> author, in case you didn't touch that part of it) did not use the
maximum
> number of values on STRQMQRY's SETVAR parameter?  SETVAR allows up to 50
> variables, and each variable can hold 55 characters.

I honestly don't recall.  It could be something as goofy as a limitation
of V2 CL :-)

In the intervening 80 minutes since I posted my previous response, I had a
dumbfounding epiphany.  Why the h*ll am I attempting enhance something
created out of constraint-driven necessity from 20 years ago, when I could
create a command that could just take a statement, up to 5000 characters
(command's *CHAR max), and pass it to an RPG program and process it there?
No having to split the statement into 50-character blocks (good grief)!
Leave QMQRY totally out of the process!  Certainly, someone's invented that
wheel, don't you think?  If not, it shouldn't be difficult.  I'm thinking a
PREPARE thingy and monitoring for and returning messages from the SQL
processor.

Any thoughts before I take the dive?

- Dan