Re: is there a way too batch SQL scripts

[Bdietz400 <bdietz400@xxxxxxxxx>]

You might be able to do this from a VBS script on the pc. Myou would need IBM I access installed.   Should be able to find some info on using VBS script and oledb or odbc.

--
Bryan

> On Jan 1, 2015, at 5:38 PM, Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:
>
> 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.