RE: SQL and CL Program

["Shawn Thobe" <ShawnT@xxxxxxxxxxxxxxxxxxxxxxxxxx>]

I created a source file using strsql and saving with option 4.  I then
edited it with strpdm and left only the sql statement.  I then tried to
run using runsqlstm but received the following.  I know the sql
statement works because I have ran it before
Any Ideas?  Thanks

5722SS1 V5R1M0 010525               Run SQL Statements
NATEPM      
 Record  *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 
       1 Update amflibb/itembl SET PLREQ=0 WHERE HOUSE='WHL'

                                  * * * * *  E N D  O F  S O U R C E  *
* * * * 
 5722SS1 V5R1M0 010525               Run SQL Statements
NATEPM      
 Record  *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 
 MSG ID  SEV  RECORD  TEXT

 SQL7008  30       1  Position 1 ITEMBL in AMFLIBB not valid for
operation.     
 SQL7961   0          Rollback completed.

                                                                        



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