× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2015

Re: is there a way too batch SQL scripts

Guy's

read what Darryl wrote - his problem with source files was the statement
length
since his script has longer length that "normal" source length (92/112) and
he don't want to break it up.

SEU supports statements up to 240 char length, EDTF can edit a source file
that
has a char length of thousands, RDi I dont know ...

But the main issue here is if RUNSQLSTM on V5R4 supports source file input
in any
length.



On Wed, Jan 7, 2015 at 1:29 PM, <rob@xxxxxxxxx> wrote:

Easy then, store the scripts into a source file and use runsqlstm on it.
See also: CRTQMQRY and STRQMQRY. The former "compiles" a source file
into a *QMQRY object and the latter executes. You do not need to have the
57##ST1 program to use these. I wrote an article about these long before
V5R4 even existed.


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 <dhfreinkel@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/06/2015 05:44 PM
Subject: Re: is there a way too batch SQL scripts
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Apologies, I meant to add, the data updates data on the as/400. The output
is to new or existing tables on the system. Nothing is downloaded to the
PC's.

The user interface in iNavigator is more friendly than trying to use
source files.


Sent from my iPad

On Jan 6, 2015, at 5:24 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

I think you really need to add some information about what type of
output
you expect and where it will be used.

Sounds like you need a PC tool more than an i tool - something capable
of
connecting to the database and running SQL scripts, but I don;t know how
you expect to use the output so I can't really say.

On Wed, Jan 7, 2015 at 11:03 AM, Darryl Freinkel <dhfreinkel@xxxxxxxxx>
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.
--
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
Evan Harris
--
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.


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





As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.