|
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 release? Is there any alternative way to do a RUNSQLSTM type process on a box without RUNSQLSTM? Thanks. +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.