RE: RPGSQL Compile

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

are you compiling with Commit(*NONE)?

-----Original Message-----
From: Michael Anderson [mailto:mike_anderson66@hotmail.com]
Sent: Monday, March 04, 2002 10:49 AM
To: RPG400-L@midrange.com
Subject: RPGSQL Compile


I have the following program:

     C/EXEC SQL
     C+ UPDATE RAR402 SET RSAL =
     C+  (SELECT CREG FROM RCM WHERE CCUST = RCUST)
     C+  WHERE RSAL > 99  OR RSAL <= 1
     C/END-EXEC
     C                     SETON                     LR

The SQL statement executes just fine in SQL.  When I compile the program
using the CRTSQLRPG, it compiles successfully.  However, when I call the
compiled program the SQL statement is not executed.

Does anyone have any idea what I am missing?

Mike Anderson


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.