Format
{ source-name ,... destination-name }
CONVERT { /REPOSITORY repository-anchor-name }
{ }
1 – Parameters
1.1 – source-name
Specifies the Oracle Dictionary Management Utility (DMU)
definition you are converting. The Oracle Dictionary Management
Utility (DMU) definition must be a definition of type CDD$RECORD.
You can use either a full or relative DMU path name with the
CONVERT command. You can also substitute an asterisk (*)
wildcard character for this parameter.
1.2 – destination-name
Specifies the name that you select for the converted definition
in the CDO repository. If you specify more than one DMU
definition in the source name, the destination name must have
a wildcard character in its name.
1.3 – repository-anchor-name
Specifies the device and directory specification of the
repository to be upgraded using the CONVERT/REPOSITORY command.
2 – Qualifiers
2.1 /REPOSITORY
Specifies that the repository should be upgraded.
3 – Description
The CONVERT command copies a DMU format definition from the DMU
side of the dictionary to the CDO side of the dictionary. The
CONVERT command leaves the definition in the DMU side of the
dictionary.
The CONVERT/REPOSITORY command allows you to perform a minor
upgrade (from a Version 5.n repository to a later Version 5.n,
a Version 6.1, or a Version 7.0 repository). Using this command
requires SYSPRV or BYPASS privilege. Be sure you have an adequate
backup of the repository before issuing this command.
NOTE
The CONVERT command is not the same as the
CONVERT/REPOSITORY command, which allows you to perform a
minor upgrade of a repository. For details on upgrading
repositories using the CONVERT/REPOSITORY command, see
the Upgrade_Procedure topic in DCL level help or the
instructions for upgrading a dictionary or repository
provided in Using Oracle CDD/Repository on OpenVMS Systems.
Unless you specify a different path name, the CONVERT command
copies a DMU definition into your default CDO directory.
When you convert a DMU definition, unless you specify the version
number, CDO converts the highest version of the definition.
An error occurs if you specify a destination name that is the
name of an existing definition in the CDO destination directory.
If you convert an Oracle Dictionary Management Utility (DMU)
record definition that consists of a single field description
statement, CDO converts the record definition to a CDO field
definition.
When you convert an Oracle Dictionary Management Utility (DMU)
format definition that includes a description clause for the
definition and another description clause for a structure within
the definition, only the structure description clause appears in
the CDO format definition.
If you have a version of DIGITAL DATATRIEVE prior to Version 5.0
installed on your system, and you are converting a DMU definition
that contains a VALID FOR DATATRIEVE IF field attribute or a
COMPUTED BY DATATRIEVE field attribute clause, CDO omits these
clauses from the resulting CDO definition.
If the DMU record that you are converting has a different
processing name from the DMU directory name, then the resulting
CDO record definition retains the old processing name. However,
if both the processing and directory names are the same for the
DMU definition, then the resulting CDO record definition retains
the same name for both the processing and directory names.
When you convert an Oracle Dictionary Management Utility (DMU)
definition, CDO creates a default ACL for it. See Using Oracle
CDD/Repository on OpenVMS Systems for more information on default
protection.
To display or manipulate a converted field within a record
description with a CDO command, you must assign it a directory
name. Use the ENTER command to assign this name.
When you convert an Oracle Dictionary Management Utility (DMU)
definition to a CDO definition, CDO converts the DMU access
rights to CDO access rights. However, because DMU protection
is different from CDO protection, there is no CDO equivalent
for some DMU access rights. Therefore, CDO must convert some DMU
rights to the closest CDO access right.
Conversion of Oracle Dictionary Management Utility (DMU) Access
Rights to CDO Access Rights shows how CDO converts DMU access
rights to the closest CDO equivalent. DMU access rights that are
not listed in the table are not translated because no equivalent
CDO access right is appropriate.
Table 1-1 Conversion of Oracle Dictionary Management Utility
(DMU) Access Rights to CDO Access Rights
Oracle Dictionary
Management
Utility (DMU)
Access Right Equivalent CDO Access Right
CONTROL CONTROL
DELETE DELETE
Local or global
DTR MODIFY MODIFY (confirms that CHANGE access can be
granted)
DTR READ READ (confirms that SHOW access can be
granted)
DTR WRITE WRITE (confirms that DEFINE access can be
granted)
SEE SHOW
UPDATE CHANGE + DEFINE
4 – Examples
1.CDO> CONVERT CDD$TOP.PERSONNEL.BADGE_NUMBER BADGE_NUMBER
In this example, the CONVERT command converts the DMU BADGE_
NUMBER record definition (and any embedded field definitions)
to a CDO BADGE_NUMBER record definition in your default CDO
directory.
2.CDO> CONVERT CDD$TOP.SHIPMENTS.CUSTOMER_RECORD,
cont> CDD$TOP.SHIPMENTS.INVENTORY_RECORD *
In this example, CDO converts the DMU record definitions
CUSTOMER_RECORD and INVENTORY_RECORD into your CDO directory.
Because the asterisk (*) wildcard character was used in the
destination-name, the DMU record definitions keep the same
names after the conversion.
3.DEFINE RECORD CDD$TOP.HARBORMASTER.YACHTS
DESCRIPTION IS
/* This record contains the manufacturer, model, and
dock number of each yacht in the harbor, along
with the owner's name. */.
YACHTS STRUCTURE.
MANUFACTURER DATATYPE IS TEXT
SIZE IS 30 CHARACTERS.
MODEL DATATYPE IS TEXT
SIZE IS 30 CHARACTERS.
DOCK_NUMBER DATATYPE IS TEXT
SIZE IS 2 CHARACTERS.
NAME STRUCTURE.
LAST_NAME DATATYPE IS TEXT
SIZE IS 15 CHARACTERS.
FIRST_NAME DATATYPE IS TEXT
SIZE IS 10 CHARACTERS.
MIDDLE_INITIAL DATATYPE IS TEXT
SIZE IS 1 CHARACTER.
END NAME STRUCTURE.
END YACHTS STRUCTURE.
END YACHTS RECORD.
In this example, YACHTS is the name of a DMU record definition
and also of the STRUCTURE field description statement within
the record definition.
4.CDO> CONVERT YACHTS YACHTS_NEW
CDO> SHOW RECORD/FULL YACHTS_NEW
Definition of record YACHTS_NEW
| Contains field MANUFACTURER
| | Datatype text size is 30 characters
| Contains field MODEL
| | Datatype text size is 30 characters
| Contains field DOCK_NUMBER
| | Datatype text size is 2 characters
| Contains record NAME
| | Contains field LAST_NAME
| | | Datatype text size is 15 characters
| | Contains field FIRST_NAME
| | | Datatype text size is 10 characters
| | Contains field MIDDLE_INITIAL
| | | Datatype text size is 1 characters
CDO>
When you convert the DMU record definition YACHTS to the
CDO record definition YACHTS_NEW, the resulting CDO record
definition has YACHTS_NEW for its directory name and processing
name.