Please re-read my message very carefully.
By converting the stored procedure into a SELECT procedure it makes it so
that between each fetch he interrupts to the client giving it an opportunity
to perform a commit.

You would want to use a TIB_Cursor component and include the FOR SELECT
clause so that it wouldn't try and stack a buffer with fetches but instead
send each fetch (interrupt) immediately to the client.

Hope this clears it up and unveils the genius of my idea. <g>

Regards,
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: "Alan McDonald" <alan@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 28, 2003 8:21 PM
Subject: RE: [IBO] Commit in Stored Procedure


> Jason - I think he's doing all the processing on the server - there's no
> records coming back to the client.
> Alan
>
> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Wednesday, 29 January 2003 8:43 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Commit in Stored Procedure
>
>
> 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