RE: SQL Update in RPGLE.

It can be done using cursors then on the update statement it would look
like this:

C/EXEC SQL
C+   UPDATE MYFILE SET MYFIELD = :MYNEWVALUE WHERE CURRENT OF MYCURSOR
C/END-EXEC


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Troxclaire
Sent: Thursday, March 30, 2006 2:23 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL Update in RPGLE.

So, it can't be done using SQL? or is it just that doing it the way
Michael 
suggested is an efficient way to do this. I have an extremely
complicated 
SQL query with lots of files but I was just testing it on a simple file
if 
it works.

Thanks,

Mike.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/