Re: is there a way too batch SQL scripts

Darryl

I believe you can save the script you create in iNav - and save it as a source member - I see that iNav V5R3 does not have that option, but I think you can get later versions of CA and run against V5R4.

So if you save as a source member, you have all the multiple statements that you can run using RUNSQLSTM.

It is becoming clear that you won't be able to do anything with PC batch files - those with BAT as the extension. It is not clear if that is what you mean by batch. If you mean to run attended on IBM i, then RUNSQLSTM in a CL is your ticket.

I guess what I'm suggesting is to use iNav as your editor - although, I must admit, I don't find it very nice to use - the wizard is kind of OK but limited - prompting? Not when you try something interesting.

But if you can save as a PF member, cool. Or save as a PC file, then copy to a source PF.

Others have probably made similar suggestions - hope I'm saying ANYthing that makes sense or is relevant.

Vern

On 1/6/2015 4:46 PM, Darryl Freinkel wrote:

You can run multiple sql statements in 1 script.

My scripts already contain several complex scripts so it's easier to break them into smaller scripts, more like object oriented.

In this way I can easily test and debug each script.

Sent from my iPad

On Jan 6, 2015, at 5:24 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 1/6/2015 5:03 PM, Darryl Freinkel wrote:
Let me add some clarity.

I am using v5r4 and am using the iNavigator's "Run a sql script".

So all is native in iNav.

I would like to continue running the scripts from iNav.

I would like something like

Runsql script1
Runsql script2
Runsql script3

The iNav for Windows script program is called CWBUNDBS. You should
think of it as an interactive program. There is no 'batch' mode.

If I had to do this, I'd write a Python or Java program that would read
those scripts and then submit them to IBM i via ODBC / JDBC. Map a
windows drive to your IFS (that's where I keep mine). That way you
could still maintain them interactively via iNav, and run them via a
.bat file as needed.

I know you said that you run them from the PC, but for the archives, one
could also run the same scripts on IBM i through a similar mechanism
(read the stream file in RPG / Java / Python and submit via ODBC).

On Jan 5, 2015, at 8:54 AM, rob@xxxxxxxxx wrote:

I understand that you want to run these scripts on your PC. So I think
you're looking for something like the commands IBM supplies for batch file
transfer but instead supports your PC based SQL scripts.
Most others are suggesting running commands on the IBM i to run SQL. They
might not understand what you are asking. But to put them into a positive
light, running the SQL on the IBM i might perform better by doing all the
summarizing on the big iron and just passing the results back to the PC.
Failing that, and a continuation on attempting to run SQL scripts directly
on your PC I know there is a way. We actually did this from DOS before I
discovered the old freebie RUNSQL (which was supplanted by IBM coming out
with their own a decade or so later). Now if I could only remember how...
Got a lot of work to catch up...
Maybe the ODBC connectivity stuff?
Maybe putting the SQL into excel?
Maybe just running the file transfers and then accessing the downloaded
data?

Rob Berendt

From: "Darryl Freinkel" <dfreinkel@xxxxxxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Date: 01/01/2015 05:34 PM
Subject: is there a way too batch SQL scripts
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

I have about 10 separate SQL scripts that I run from the PC command line
using the iNavigator SQL interface.

What I need to do is something like call each script in a batch(BAT) type
file.

Has anyone done this before?

I do not want to run these using a series of runsqlstm statements in a CL
program. Using RUNSQLSTM needs me to convert the scripts into source files

and the width of the source file requires me to break lines into multiple
lines which gets very messay.



Darryl Freinkel

--
--buck

'I had nothing to offer anybody except my own confusion' - Jack Kerouac
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.