RDBPROD: How to extract the description on a field or record in the CDD using SQL? (Doc ID 552219.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
Oracle CDD/Repository - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
HP OpenVMS VAX

Goal

Given a CDD dictionary defined as follows:

$ mc cdo
CDO> define dictionary USER_DB:[CDDPLUS].
%RMU-W-PREVACL, Restoring the root ACL over a pre-existing ACL.
This is a normal condition if you are using the CDO utility.
CDO> exit


Define a field and a record with a description:

$ assign USER_DB:[CDDPLUS] cdd$default
$ mcr cdo
CDO> define directory cdd$default.veld.
CDO> define directory cdd$default.rec.
CDO> define field cdd$default.veld.fld1
cont> description /* this is the description */
cont> datatype text 4.
CDO> define record cdd$default.rec.rec1
cont> description /* this is the record description */.
cont> cdd$default.veld.fld1.
cont> end record.
CDO> exit

Is it possible to extract the description of a field or record in the CDD using SQL?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms