RE: SQL and CL Program

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

Use the strpdm command, take option 3, specify the file library and member.
you should only see the desired member in a list.  Put a 2 (to edit)the
member.  place a "D" in the first position of each record that is not part
of the desired SQL.  Press f3.  press enter to save and you should be ok.

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


Thanks for all of your help.  I misspoke before.  When I used strsql
then saved it to a source file using option 4 it saved more than just
the sql statement.  So when I ran it using runsqlstm it failed.  How do
you save just the sql statement.  thanks

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

No problem.  There should be a file on your system that contains source
members.  you can try to use QCLSRC.  If you are not sure where QCLSRC
is
located on your 400, use *libl for the library.  If that doesn't get it
for
you, you will need to ask your i.t. support people where you can keep
the
SQL statement...

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


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




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

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