• Subject: RUNSQLSTM - included with v4? n
  • From: D.BALE@xxxxxxxxxxxxx
  • Date: Thu, 4 Jan 2001 14:30:00 -0500

Sorry for that last post - my nimble fingers were a little too nimble.

Dave, I'm surprised you haven't gotten a response to this yet.  While the
RUNSQLSTM command part of SQL/400 licensed product, there was published code
to be able to run SQL w/o the LPP.  Can't recall where I'd seen it.

I have code to do this - it probably originated from the published code I just
mentioned, but it has passed hands several times.  It works for me.  If you'd
like a copy, email me privately (too much to post here).

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------
I have a procedure that uses RUNSQLSTM on my v4r4 box.  In trying to run it
on a v3r2 box, I learned that his box doesn't have the RUNSQLSTM command.
It appears that on v3 it was part of SQL/400 licensed product.  I'm not sure
on the v4 box if the same is true.

I have a vague recollection that SQL is bundled with v4 but I'm not sure.

Making things more confusing is my other vague recollection that you can run
SQL type activities on this v3r2 box using something like a Rumba or other
ODBC product, but can't run it from a command line.   Hmmmmm.

Can anyone fill me in on whether RUNSQLSTM is bundled and if so, as of what

Is there any alternative way to do a RUNSQLSTM type process on a box without


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

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].