Moves data definitions between an Rdb/VMS database and the data
 dictionary.  You can use the INTEGRATE DATABASE statement in either
 of these ways:

  o  To copy the data definitions from an existing database into a
     data dictionary entity (INTEGRATE DATABASE IN PATHNAME)
  o  To copy the data definitions from a data dictionary entity to a
     database (INTEGRATE DATABASE FROM PATHNAME)


 Example:

   RDO>  INTEGRATE DATABASE 'DISK2:[DEPT3]PERSONNEL'
   cont>   IN PATHNAME 'DISK1:[DICTIONARY]CORP.PERSONNEL'
   RDO> COMMIT

Additional information available:

MoreFormatExamples

 You must have the Rdb/VMS READ privilege for a database to use the
 INTEGRATE DATABASE statement.

 If the data dictionary was not installed when a particular database
 was created, you can use the INTEGRATE statement to build the
 dictionary definitions from the database.

 You can also periodically use the INTEGRATE statement to ensure that
 the database and data dictionary definitions remain synchronized with
 each other.

 INTEGRATE starts a transaction which can be completed by a COMMIT or
 cancelled by a ROLLBACK statement.

 INTEGRATE DATABASE ──────────────────>───────────────────────────────┐
                                                                      │
 ┌───────────────<────────────────────────────────────────────────────┘
 │
 ├──>source-db-filespec ─> 
I
N 
P
A
T
H
N
A
M
E ──> target-dict-pathname ─────┐
 │                                                                   │
 └──>target-db-filespec ─> 
F
R
O
M 
P
A
T
H
N
A
M
E ──> source-dict-pathname ───┤
                                                                     │
 ┌───────────────────────────────────<───────────────────────────────┘
 │
 └───────────────────┬───────────────>───────────────────┬──────────>
                     └──> 
D
B
H
A
N
D
L
E typebox (I)typebox (S) ───> db-handle ───┘

Additional information available:

source-db-filespectarget-dict-pathnametarget-db-filespecsource-dict-pathname
db-handle

 A full or partial VMS file specification, enclosed in quotation
 marks, specifying the source of the database definitions.

 The data dictionary path name for the dictionary entity in which the
 database definition will be created again.  You can specify a full
 data dictionary path name or a relative data dictionary path name.
 Enclose the data dictionary path name in quotation marks.

 A full or partial VMS file specification, enclosed in quotation
 marks, specifying where the data dictionary definition will be
 created.

 The data dictionary path name for the dictionary entity from which
 the database definition will be copied.  You can specify a full data
 dictionary path name or a relative data dictionary path name.
 Enclose the data dictionary path name in quotation marks.

 A name that you assign to the database.

 Example 1

 The following statement creates the data dictionary definitions for
 the PERSONNEL database in 'DISK1:[DICTIONARY]CORP.PERSONNEL':


 RDO> INTEGRATE DATABASE
 cont>  'DISK2:[DEPT3]PERSONNEL'
 cont>   IN PATHNAME 'DISK1:[DICTIONARY]CORP.PERSONNEL'
 RDO>  COMMIT


 Example 2

 This example shows how to specify a database handle for a database.
 Because one database is already invoked, you must specify a database
 handle with the INTEGRATE DATABASE statement.

 RDO> SHOW DATABASES
 Database with filename personnel
 RDO> INTEGRATE DATABASE 'DISK2:[DEPT3]ACCT'
 cont>  IN PATHNAME
 cont> 'DISK1:[DICTIONARY]CORP.ACCT' DB_HANDLE IS CHECKS
 RDO>  COMMIT
 RDO>  SHOW DATABASES
 Database with filename personnel
 Database with db_handle CHECKS in file acct

 Example 3

 The following example shows the steps you use to create the
 definitions in the same data dictionary entity.  Assume the corrupt
 data dictionary entity is in 'DISK1:[DICTIONARY]CORP.PERSONNEL'.  In
 the example, the RMU/DUMP/USERS command displays no active users of
 the database.


 $  RMU/DUMP/USERS  PERSONNEL
 No active users
 $  RUN SYS$SYSTEM:RDO
 RDO>  INTEGRATE DATABASE 'PERSONNEL'
 cont>  IN PATHNAME 'DISK1:[DICTIONARY]CORP.PERSONNEL'
 RDO>  COMMIT

 Example 4

 This example shows how to override the database definitions with the
 data dictionary definitions.  In this example, the definitions stored
 in the data dictionary DISK1:[DICTIONARY]CORP.NEW.PERSONNEL replace
 the definitions in the target database, PERSONNEL.


 RDO>  INTEGRATE DATABASE 'PERSONNEL'
 cont>  FROM PATHNAME 'DISK1:[DICTIONARY]CORP.NEW.PERSONNEL'
 RDO>  COMMIT