Re: sql QUESTION

[Luis Rodriguez <luisro58@xxxxxxxxx>]

John,

You can use the RUNSQLSTM command. regarding what your CL would look like
depends on many things, including error monitoring and processing,
parameters, etc.
In its simple way it would be something like this:

PGM

RUNSQLSTM SRCFILE(MYLIB/SOURCEFILE)  +
          SRCMBR(SQLSRC)             +
          COMMIT(*NONE)

ENDPGM

Please be aware that, in this example, I set the COMMIT option to *NONE.
Your settings can be different... Also, you can run your RUNSQLSTM directly
from the entry of the job scheduler (although I, personally, prefer to
execute them from inside a CL)

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, May 18, 2010 at 8:53 AM, John Candidi
<jacandidi@xxxxxxxxxxxxxxxxx>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?
>
> John A. Candidi
> American European Insurance Group
> IT Systems, Application and Support Manager
> Cell  (609-922-3108)
> Office (856-779-2274)
> jacandidi@xxxxxxxxxxxxxxxxx
>
>
>
>
> --
> 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.