HP3000-L Archives

June 2008, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
TurboIMAGE Error -- DBLOCK Mode5 -- 62 error code
From:
Brian Donaldson <[log in to unmask]>
Reply To:
Brian Donaldson <[log in to unmask]>
Date:
Sun, 22 Jun 2008 22:50:04 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (38 lines) 
My app DBOPEN's two databases, lets call them BASE-1 and BASE-2

The logic goes like this --

DBOPEN base-1
DBOPEN base-2

A single DBXBEGIN across BASE-1 and BASE-2

BASE-1 is DBLOCKed @ mode3 level
BASE-2 is DBLOCKED @ mode5 level

Loop here for as many entries in dataset of BASE-1

BASE-1 dataset is DBUPDATEd
BASE-2 dataset is DBPUT

end of loop 

DBXEND across both bases
DBUNLOCK BASE-1
DBUNLOCK BASE-2
DBCLOSE BASE-1
DBCLOSE BASE-2

Works great when processing just a few hundred entries, but when trying to
do a mass update (processing a number of entries whose entry count > 2600)
then the DBLOCK mode5 on BASE-2 fails with a 62 error code (DBG Full)

Anyone have an idea how to get around this problem?


TIA as always,
Brian.

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

ATOM RSS1 RSS2