Re: is there a way too batch SQL scripts

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Darryl

I did a lookup of CWBUNDBS and found a post from Kent Milligan on 
developerworks - he said that the opsNav interface is intended for 
interactive use only.

Now I did find that I could save a statement from the runner - it got an 
SQL extension.

When I double-clicked on the SQL file, it opened the OpsNave statement 
runner - no connection - it prompted for one - but that's no good for 
batch work.

Looks as is we need a different tool.

Vern

On 1/6/2015 4: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
>
> Thanks
>
> Sent from my iPad
>
> > 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
> > --
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to:  2505 Dekko Drive
> >           Garrett, IN 46738
> > Ship to:  Dock 108
> >           6928N 400E
> >           Kendallville, IN 46755
> > http://www.dekko.com
> >
> >
> >
> >
> >
> > 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
> >
> > Assignment 400 Group, Inc.
> >
> > Tel: 770.321.8562 ext 111 | Fax 770.321.8562 | 2247 La Salle Dr, Marietta
> > GA, 30062, USA | PO Box 72556, Marietta, GA 30007-2556
> >
> >
> >
> > --
> > 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.
> >
> >
> > --
> > 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.