RE: sql QUESTION

[Jerry Adams <Jerry@xxxxxxxxxxxxxxx>]

Something like:

PGM                                                           
                                                              
RUNSQLSTM  SRCFILE(PROJ1086/QSQLSRC) SRCMBR(AUGQUAL)         +
             COMMIT(*NONE) DFTRDBCOL(TEMPQRY)                

ENDPGM

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email:  jerry@xxxxxxxxxxxxxxx

If it's properly done (not aimed at anyone or anyone's shoes) it's part of the charm.  It's a terribly basebally thing to do. -Miss Manners on spitting in baseball


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Candidi
Sent: Tuesday, May 18, 2010 8:24 AM
To: 'Midrange Systems Technical Discussion'
Subject: sql QUESTION

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