RE: Update the first 1500 records that need updating

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

This might need to be a SQL stored procedure....  Open a cursor, then loop for n rows......  I suppose you could accept your SQL statement as parm, along with the rows value so that you could use this proc for any update statement....

Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Alan Shore
Sent: Tuesday, December 04, 2007 3:24 PM
To: RPG programming on the AS400 / iSeries
Subject: Update the first 1500 records that need updating


Hi everyone
(Hopefully) A quick sql question.
I have a simple SQL update
UPDATE FILEA SET FIELDA = 'N' WHERE FIELDA = 'X'

However there are thousands of records that will be updated. I only need to
update the first 1500 of these records (no other selection criteria, just
the first 1500)

Is this possible?
If so, how?

Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill