Our POWERHOUSE application is not mandateable, nevertheless we need to
handle a second (and maybe third) company with the same environment
shortly.

We think of dublicating all our databases into a new account (OEKVP), do
some slight program modifications (for currency adjustments) and that
should do the trick. Nevertheless we want to "share" 2 detail datasets
(and their masters if necessary) from one central database among the
different accounts.

To be more specific:

Database OEKV has detail set RIS-D (linked to automatic master RIS-A and
VERSFALL-A) and detail FREMNR-D (linked to automatic masters RIS-A,
FREMDNR-A, FREMDBEZ-M) and many other details (some of them also link to
RIS-A) and masters.

As RIS-D contains several millions entries and the entries are the same
for all accounts (companies) it does not make sense to copy them.

1) Idea:

In the new account OEKVP we create a dictionary containing database OEKV
with all datasets except RIS-D and FREMDNR-D. And create an additional
entry for a "fake" database OEKVX with definitions for RIS-D and
FREMDNR-D and an open statement, which directs the program to the
central account OEKVC.

like
  File
OEKV
&  -> for the local copies of DB OEKV (without RIS-D)
  Organization
Database                                                      &
  Password
"XXXXXX"                                                           &
  Open OEKV.PHDB

and
File
OEKVX
& -> for the central copie of DB OEKVE with RIS-D
  Organization
Database                                                      &
  Password
"XXXXXX"                                                           &
  Open OEKV.PHDB.OEKVC                                              &

My main questions are:
a) is this possible or is it necessary to define all the master
(automatic or manual) datasets necessary to access the key items of
RIS-D and FREMDNR-D  in the fake DB too?
b) if yes - how can we differentiate them from those master (automatic
or manual) datasets, which have the same name but link to different sets
in database OEKV (instead of the sets in OEKVX), like dataset RISOBPOD-D
also is linked to RIS-A?

I added some FO PATHS information from QUERY

FREMDBEZ-M        FREMDNR-D         KZNR
FREMDNR-A         FREMDNR-D         FREMDNUMMER
RIS-A             ANBOPOS-D         RISIKONUMMER
                  ANBOPOS1-D        RISIKONUMMER
                  ANTRISOB-D        RISIKONUMMER
                  FREMDNR-D         RISIKONUMMER      KZNR
                  PROTRIS-D         RISIKONUMMER
                  RIRV-D            RISIKONUMMER
                  RIS-D             RISIKONUMMER
                  RISAUSK-D         RISIKONUMMER      BONIDAT
                  RISHIS-D          RISIKONUMMER      BONIDAT
                  RISOBPOS-D        RISIKONUMMER      DATAB
                  SOKOND-D          RISIKONUMMER
                  SOKONDTX-D        RISIKONUMMER
                  UERISOB-D         RISIKONUMMER      DATAB
                  VN-D              RISIKONUMMER
                  VSSUMMEN-D        RISIKONUMMER
                  VSUMMEN-D         RISIKONUMMER
VERSFALL-A        ANBOPOS-D         VERSFALLNR
                  ANBOPOS1-D        VERSFALLNR
                  RIS-D             VERSFALLNR
                  UERISOB-D         VERSFALLNR
FREMDNR-D         RISIKONUMMER      KZNR              RIS-A
                 !FREMDNUMMER                         FREMDNR-A
                  KZNR                                FREMDBEZ-M
RIS-D            !RISIKONUMMER                        RIS-A
                  VERSFALLNR                          VERSFALL-A



2) other Ideas????

Is there an alternative to do the same thing?

best regards
Friedrich

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