I am using a disconnected ADO 2.5 recordset which was returned by a DB2 stored procedure.

My problem is that many of the fields are marked with the attribute adFldUpdatable = false.

Now I understand that the provider sets this attribute to indicate that it doesn't know how to update the field should I ask it to. But I am never gonna ask it to.

I want to use my disconnected recordset - how should I say ummm.. "disconnectedly". I am never gonna ask DB2 to do an update, and I want to be able to update these fields in the recordset.

Is there any way to force this attribute? other ideas?

(currently we are copying the returned recordset into another recordset which we have built independently. This causes a HUGE performance problem for us).


thanks