SQL Update statement for 50,000 entries

[DanielJ]

I'm new to using SQL and in my current position I am doing some basic uploading to a Oracle database, to a sinlge table with approx 1.4 million rows. IBM is supporting the database and have provided me a solution for updating the table, but for some reason the update only allows 1000 rows to be updated at a time?

Here is the basic script that has been provided. The script has normally 1000 entries normal, but its been cut down for posting

update uphs.hu_codes
set code_date = '15-sep-06'
where code_id in (
'352124012484632',
'352124012484657',
'352124012484723',
'352124012484780',
'352124012484814',
'352124012484822',
);
commit;
exit;

Does update have in general a limitation of 1000 entries for update or iwould this be something IBM have implemented because when I try to do more then 1000 entires the script fails and produces a error?

If I have 50,000 entries to be updated is there a better way of doing this, instead of preparing 50 scripts?

[pks00]

Dont know, might have something to do with rollbacks.


Have u considered changing this to using PL/SQL ?

Create a cursor and a count
Loop thru the cursor and update records, perform a commit, say every 100 records