Problem Resolved!

The file equate did it. Thank you.




Will Townsley
Southwestern Michigan College



>At 07:53 AM 7/10/98 -0700, you wrote:
>>     Hi, Will --
>>
>>     Like Costas said, you need to use a couple :FILE equations.
>>
>>     Notice, for example, that you initially specified the first DB
>>     as "NEED98.FAGROUP.PROGDEV" but later referred to it only as
>>     "NEED98".
>>
>>     Use        :FILE NEED98=NEED98.FAGROUP.PROGDEV
>>     then
>>                DATA-BASE=NEED98
>>
>>     Do a similar thing for the other DB and all should be well.
>>
>>     --Glenn
>>
>>
>>______________________________ Forward Header
__________________________________
>>Subject: [HP3000-L] Image Query - Help
>>Author:  Non-HP-hp ([log in to unmask]) at HP-Boise,mimegw2
>>Date:    7/10/98 6:22 AM
>>
>>
>>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
>>