RE: SQL and CL Program

["Gregory A. Garner" <ggarner_gds@xxxxxxxxxxxxxx>]

Use a member name that you will recognize and remember.  I.E. itemasasql

*** 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 4:32 PM
To: MAPICS ERP System Discussion
Subject: RE: SQL and CL Program


I think I may have figured out the saving to source file ( used strsql
and the took option 4).  My issue now is that it asks for the member

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




_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.