David Years back NEWS400 published a utility for doing this . It made use of the standard query tools to extract the SQL functionality iut the the DB400 database. I have been using it for years and if you email me offline I could send you a copy of the source . Michael Kenney IT Services University of Windsor email@example.com "Shea, David" <DShea@arctools.com To: "'firstname.lastname@example.org'" <email@example.com> > cc: Sent by: Subject: RUNSQLSTM - included with v4? not v3? owner-midrange-l@mi drange.com 01/04/2001 09:54 AM Please respond to MIDRANGE-L 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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.