Revision as of 04:24, 12 March 2009

SET DICTIONARY

Class

Table Organization

Purpose

Change or deactivate the active dictionary

Syntax

SET DICTIONARY ON | OFF | (<expL>)

SET DICTIONARY TO [<.dbd filename> | (<expC>) ]

See Also

CREATE, MODIFY STRUCTURE

Description

The SET DICTIONARY ON | OFF command enables or disables the use of Recital’s Data Dictionary (.dbd) files. By default SET DICTIONARY is ON. When SET DICTIONARY is OFF, and a table is opened that has an associated data dictionary, the data dictionary is ignored. To disable a dictionary file after the table has opened, use the SET DICTIONARY TO command.

The SET DICTIONARY TO <.dbd filename> command can be used to change the current dictionary. The filename can be substituted with an <expC>, enclosed in round brackets, which returns a valid filename. If no file extension is specified, ’.dbd’ is used. This command will change the active dictionary to the specified <.dbd filename>. The dictionary must have been created from the current table.

The dictionary file is created from the CREATE or MODIFY STRUCTURE work surface. It is created with the same basename as the table, but with a ’.dbd’ extension. To create another dictionary for the same table, the current dictionary should be copied to a new name first.

The SET DICTIONARY TO command will deactivate the current dictionary.

NOTE: SET DICTIONARY TO will not deactivate triggers or field and table protection.

Example

set dictionary off
use customer.rdb
copy to cust2
use cust2
set dictionary to customer

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer