Incorporating Existing Databases

This chapter contains information on how to use the DMSII Client to add its data sets to an existing database. Normally, when you run the DMSII Client the first time, it creates the client database. However, if you already have a database and you want to merge the information in that database with replicated information from the primary database, you can modify the DMSII Client to do so.

The DMSII Client will not access or modify any of the pre-existing data sets. Those data sets will be updated by the application software, independently of the DMSII Client. (The DMSII Client will update any data sets that it adds to the database.)

---

Incorporating an Existing Database

To have the DMSII Client add its data sets to an existing database, complete the following steps:

1. Use CANDE or another editor to copy the DASDL source file of the existing database, as follows

   GETexisting_clientdb_sourceAS PATCH/DATABRIDGE/DMSIICLIENT/clientdbname/DASDL

2. Insert the following line after the OPTIONS parameter in the DASDL file you just created:

   $ SET INITIALIZENEW AUTOREORG

3. Declare the following structures somewhere in the DASDL file:

   AUDITLOCATION DATASET
(
AL-STRNUM NUMBER (4) INITIALVALUE 0;
AL-RECTYPE NUMBER (3) INITIALVALUE 0;
AL-MODE NUMBER (1) INITIALVALUE 0;
AL-AFN NUMBER (4) INITIALVALUE 0;
AL-ABSN REAL (S11) INITIALVALUE 0;
AL-SEG REAL (S11) INITIALVALUE 0;
AL-INX REAL (S11) INITIALVALUE 0;
AL-TIME REAL INITIALVALUE 0;
AL-HOSTINFO REAL INITIALVALUE 0;
),
BLOCKSIZE = 30 RECORDS;
ALSET SET OF AUDITLOCATION
KEY
(
AL-STRNUM,
AL-RECTYPE
)
NO DUPLICATES;


4. For any primary-side sets you want declared on the client side, declare the following somewhere above the insertion point (see step 6) in the DASDL file:

   $ SET setname1 setname2 setname3...

   Note

   Remove any hyphens from the set name. For example, if you want to include a set called BANK-ID-SET, use $ SET BANKIDSET

5. For any primary-side subsets you want declared on the client side, declare one of the following somewhere above the insertion point (see step 6) in the DASDL file:

   $ SET ALLSUBSETS

   -or-

   $ SET subsetname1 subsetname2 subsetname3...

6. Type the following line where you want the declarations for the primary-side structures to appear, which must be somewhere after the $ SET setname..., and $ SET subsetname... lines, if present.

   @ Insertion point -- Do NOT delete this line.

7. Save the DASDL.

What to Do Next

Configure and then start the DMSII Client as described in Configuring and Starting the DMSII Client. Make sure that you use the existing database name as the client database name.