Eben

Yes, You need to check the find count--->
CALL "DBFIND"                 USING DB-BASE-HIST
                                  DB-DATA-SET
                                  DB-MODE
                                  DB-STATUS
                                  ITEM-YMDBATCH-LIST
                                  DB-ARGUMENT

 IF  (DB-CONDTN-WORD = 17) OR (DB-FIND-COUNT < 1)


The find count will tell you if you find any records in the DETAIL you
searched.

Good Luck 
Kent Wallace

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Eben Yong
Sent: Tuesday, August 16, 2005 1:32 PM
To: [log in to unmask]
Subject: [HP3000-L] image conundrum

We have just located a potential problem and would appreciate some
answers
from the image gurus.

Given an automatic master dataset, and two detail datasets.  Both
details
are linked to the automatic master by the very first field in the
dataset.  Given key XXXXX, and a record existing in dataset #1,
performing
a DBFIND on dataset #2 yields a hit (DBFIND DB-STATUS = 0).  But of
course, the DBGET yields nothing.  Does anyone have experience with this
and/or knows the reasons for it?  Is this normal?

We can repeat this problem with multiple databases and datasets.

Thanks in advance for your assistance!

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 *

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