Hi Folks, our shop is still running on the venerable HP3000 platform, and we 
are using MB Foster's ODBC software to access data in our HP3000 Image 
databases thru Microsoft Access.  I have encountered a problem wherein the 
ODBC link is failing because of some kind of limit to the number of updates that 
can be performed in one SQL statement.  More specifically, when I run an SQL 
statement that updates 1750 rows of data, it goes thru, but when I try 
updating 1965 rows, it fails.  So, the limit is somewhere between 1751 and 
1964 row updates.  When I contacted MB Foster about this, here is the 
response I received:

"The ability to increase [the number of row updates in a single SQL statement] 
is in MPE 6.5.  It is a process that HP has put in this version.  We believe that 
you use volutil to increase something involving transaction manager.  We have 
no idea what this can be increased to, but if you wish to pursue this you will 
have to contact HP.  We believe that your best option is to limit the number 
of updates, perhaps using criteria in MS Access.  Thank you."

It seems MB Foster tech support is uncomfortable addressing this directly.  I 
no longer have HP support and this is not a critical problem--meaning yes, I 
can limit the updates by creating a dozen or so ad hoc SQL statements to 
limit the number of row updates--but I'd be happy for any advice that might 
resolve this.

Thx, as always.

Eben Yong
Health Plan of San Mateo

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *