Have you tried fully qualifying the DB names in the JOIN command or having
file equations for the DBs set up ?

Costas Anastassiades,
Intracom SA
Athens-Greece


-----Original Message-----
From: Will Townsley <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: Παρασκευή, 10 Ιουλίου 1998 3:20 μμ
Subject: Image Query - Help


>I am trying to run a query using multiple data bases from
>multiple groups. This is the 1st time anyone here has
>attempted multiple data base access. Following is the output
>from my attempt. The error indicates that one of the data
>bases specified is not open but I don't know why. Any ideas?
>I have looked at this a hundred times and can not see anything
>wrong. Everything is spelled correctly and specified as it
>should be regarding accounts and groups as far as I can tell.
>
>
>:RUN QUERY.PUB.SYS
>DATA-BASE=NEED98.FAGROUP.PROGDEV
>RW002
>5
>DATA-SETS=STD-DET-RPTD
>MULTIDB
>REGDB.COLLEGE.PROGDEV
>;
>5
>SESSION-DATA,STUDENT
>
>ASSIGN LOCKOPTION=OFF
>JOIN NEED98:STD-DET-RPTD.STD-ID-NO TO REGDB:SESSION-DATA.STD-ID-NO, &
>     REGDB:SESSION-DATA.STD-ID-NO TO REGDB:STUDENT.STD-ID-NO
>NO DATA BASE WITH THE GIVEN NAME IS CURRENTLY OPEN
>MULTIFIND NEED98:STD-DET-RPTD.STD-ID-NO > " "
>EITHER NO JOIN COMMAND HAS BEEN ISSUED OR THE
>   MOST RECENT JOIN COMMAND WAS INVALID
>