Thank You!!
John A. Candidi
American European Insurance Group
IT Systems, Application and Support Manager
Cell (609-922-3108)
Office (856-779-2274)
jacandidi@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck
Sent: Tuesday, May 18, 2010 9:35 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: sql QUESTION
On 5/18/2010 9:23 AM, John Candidi wrote:
Novice SQL. If I have an SQL SRC file and I want to call that with a simple CL program to execute via job scheduler, what would the CL program look like?
RUNSQLSTM works in a CL program as well as the command line. There's
nothing special needed to set up RUNSQLSTM, so the CL program would look
quite similar to
pgm
runsqlstm...
endpgm
What would go on RUNSQLSTM would depend on where your SQL source is
stored. The other parameters depend upon your environment, especially
commitment control. But since RUNSQLSTM runs from the command line, you
can quickly test your RUNSQLSTM command without needing an
edit/compile/run cycle.
--buck
--
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.
midrange.com
