| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I am using FOCUS (V5.2) to do reporting from an RDB database. When
the users log on the are put into a sub-directory seperate from
the sub-directory where the database resides. The database name
happens to be longer than 8 characters so in the profile.fex I
assign a logical of 8 characters to the database name and then I
do the filedef's using the logical. The problem I am having is
that the report fex's are blowing up and giving me the following
error:
(FOC1468) EXTERNAL FILE NOT FOUND FOR FILEDEF : SHIPS88
When I run the same report fex in the directory where the database
is, the report works fine. I have also tried assigning the FOC$DIR1
to the database directory and still no luck. Any Ideas?
The PROFILE.FEX looks like this:
VMS DEFINE/JOB SHIPMENT SHIPMENTS.RDB (**I've also tried putting
the database directory
here,[directory]shipments.rdb**)
FILEDEF SHIPS88 DISK SHIPMENT:
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 168.1 | NRPUR::CHABOT | Jerry Chabot | Wed Jan 11 1989 11:53 | 17 | |
The FOCUS 5.2 Release Notes has a section on "Known Software Errors
and Limitations". Under the RDB FILE ACCESS it states:
2164 FOC1468 FOR RDB REQUEST. IF FILEDEF USES LOGICAL, FILENAME
GT 8 CHAR.
Another way to state it is : RDB filenames cannot be greater than
8 characters when they are refered to via a logical.
We ran into similar problems. After resolving them I then noticed
the reference in the release notes.
You stated the report works when the user's default is the same
as where the database resides. Did you also change the FILEDEF
to reference only the filename and not a logical?
| |||||
| 168.2 | SAME PROFILE.FEX | MSBIS2::BARTOW | Wed Jan 11 1989 12:03 | 12 | |
Hi Jerry,
Thanks for your input. The report ran fine when I used the same
profile.fex in the directory where the database resides, I still
used the logical in the filedef and it seemed to work.
I guess I may need to change the database name to 8 characters
and then see what happens.
Bill
| |||||