Having just looked at the programmers code...
Yep thay are doing a cursor open and not using a select loop. The cursor statement is not being specified with readonly.
Mystery solved.
Marty
From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 17 June 2011 10:20
To: Ingres and related product discussion forum
Subject: [Info-Ingres] OpenAPI select and locking
Hi All,
Quick question...before I start hacking some code togethor...
Does anyone know if the cursor opened by iiapi_query for a select is openedwith readonly set.
Quote:
From what I can tell it is not, and hence my select is flagged as taking anIX lock and hence stalling.
|
Martin Bowes
[Info-Ingres] OpenAPI select and locking -
06-17-2011
, 04:20 AM
Linear Mode
