RE: is there a way too batch SQL scripts

Subject: Re: is there a way too batch SQL scripts
From: dhfreinkel@xxxxxxxxx
Date: Tue, 6 Jan 2015 18:07:15 -0500
To: midrange-l@xxxxxxxxxxxx

I'll check this option again. The last time I did that there was a width restriction.

If it works, that would be great using with RDP.

T

Sent from my iPad

On Jan 6, 2015, at 5:53 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

Guy's

a source file is not resticted to neither 92 or 112 char so it should be
simple ...

Store the SQL in as STMF and import it to a source file and run RUNSQLSTM

On Tue, Jan 6, 2015 at 11:50 PM, Darryl Freinkel <dhfreinkel@xxxxxxxxx>
wrote:

INavigator is your IBM_i client access utility we all get with iAccess.

Sent from my iPad

On Jan 6, 2015, at 5:38 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

I wasn't aware of the unavailability of the stream file option of

RUNSQLSTM

at 5.4

At 5.4, I would create an RPG utility to read scripts from stream files

and

pass them to the sqlExecDirect() procedure, which is documented under the
SQL CLI reference.

By "iNav", I assume that you are referring to the Windows product. I'm

not

sure why you would use a PC for "batch". But you could call a program

that

submits a Job from the PC.

Nathan.
--
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.

--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
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.