Make it a select procedure and have it return a "fetch" every 50,000 records
and then the client can simply do a commit-retaining for each fetch that
comes back.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Bayu" <bayu@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Monday, January 27, 2003 7:36 PM
Subject: [IBO] Commit in Stored Procedure


> Hi all,
>
> My production system is about processing update about 300.000 records
every
> night.
> And this processing is in stored procedure
>
> If i execute the sp on this records it takes a long time ... and then
> commited
> But when execute with divide this record and processing about 50.000
records
> in each execute sp, this takes a short time.
>
> How can i set the sp which every 5.000 will commit this update with IBO ?
>
> Sorry for my english
>
> regards