| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 481.1 | Accessing an RdB view | EVTDD1::CARRIERE | Jean-Claude Carriere | Tue Nov 19 1991 05:21 | 29 |
|
There are two ways in FOCUS to perform this type of operation :
1) Using RdB itself, the FOCUS-RDB interface access transparently
a table or a view, therefore if a view exists which contain
the UNION ALL clause, you'll be able to describe it by just
referencing its name in the access file (.ACX)
2) Focus has an operation similar to UNION ALL in this case which
is MATCH FILE, and will consist of running a series of requests
against each table (therefore multiple master files) appending
the result together. Probably not as easy but doable.
As far as an online manual is concern, I unfortunetaly don't think
there is one. However the AUTORDB tool lets you build quickyl the
FOCUS description (Master file and Access File) for an RdB table or
view.
(Though I haven't used for a view in a long time ...)
How to use it : -type at the FOCUS prompt >EX AUTORDB
-chose to build one master (or a multi-segment one)
-type focus master file name, The rdb filename and location
the relation name (or name of the view if still working)
and the focus ddname (8 characters FOCUS name for the database
file usefull if you plan to do join should be unique for a
particular RdB database)
Jean-Claude
|
| 481.2 | It's in FOCUS, but it can run any reports | SHALOT::LANPHEAR | Test the water or turn the tide? | Tue Nov 19 1991 10:17 | 14 |
| Hi Jean-Claude,
Thanks for the help. I used the EX AUTORDB function and built my
Rdb database into FOCUS. However, when I use tabletalk to build a
report, the execution always reports:
> JOININT CALLED TO READ DATA
(FOC1451) FILEDEF MISSING FOR EXTERNAL FILE : RDBFIL
>
My manual only has error messages through FOC1123... I have tried
building just a single master, but it also reports 1451. How do I make
it work?
Thanks in advance, Dan'l
|
| 481.3 | the FILEDEF theory | BIS1::SCHYNS | | Tue Nov 19 1991 12:24 | 20 |
| The filedef command is used to link a database to a master file.
By default, when entering tabletalk, FOCUS will look to a data file
in the working directory with the same name than the master file.
So if your rdb database is in another directory, you should tell focus
where to find the data related to a master file.
The syntax is as follows :
FILEDEF xxxxx DISK []yyyyyyy
where xxxxx is you master file name and []YYYYYY is the directory and
database name.
You could type this instruction at the focus prompt, include it in a
FEX file, or have it automatically performed when accessing focus.
In this last case, you have to create a file called PROFILE.FEX
where you put the FILEDEF command. When accessing FOCUS, the tool
will search for that file such as DCL search for a LOGIN.COM file.
Herve.
|
| 481.4 | FILEDEF solves the problem | SHALOT::LANPHEAR | Test the water or turn the tide? | Tue Nov 19 1991 13:43 | 12 |
| Hi Herve,
Thanks! That helps a lot. I had just used SET WATCH FILE and found
that it was looking for RDBFIL.RDB (and .SNP of course) but obviously
my database name isn't RDBFIL. The FILEDEF command will straighten
everything out. I had hoped that EX AUTORDB would put the
appropriate FILEDEF commands into the master files it created :-) Is
this a bug or just a feature?
I'll try to obtain the FOCUS/RDB documentation for future reference.
Thanks, Dan'l
|