RE: SQL and CL Program

["Shawn Thobe" <ShawnT@xxxxxxxxxxxxxxxxxxxxxxxxxx>]

Thanks for the info.  Sorry for not being up on this but how do I " Save
it to a source physical file.  (i.e. rpg or cl).  "

-----Original Message-----
From: Gregory A. Garner [mailto:ggarner_gds@xxxxxxxxxxxxxx] 
Sent: Tuesday, March 30, 2004 4:14 PM
To: MAPICS ERP System Discussion
Subject: RE: SQL and CL Program

Save it to a source physical file.  (i.e. rpg or cl).  Then process the
"runsqlstm" command specifying the source file and member...

*** Electronic Forms Solutions ***
*** iSeries Contract Programming ***
Gregory A. Garner
Garner Data Systems, Inc.
4270 Grand Teton Parkway
Suwanee, Georgia 30024
Phone 770.845.9636   Fax 770.614.3496
e-mail: ggarner_gds@xxxxxxxxxxxxxx



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Shawn Thobe
Sent: Tuesday, March 30, 2004 3:59 PM
To: MAPICS ERP System Discussion
Subject: SQL and CL Program


How do I save an update SQL statement then call it with a CL Program.



Shawn Thobe

Network Administrator

Fort Recovery Industries Inc.

419-375-4121