Difference between revisions of "SET DICTIONARY"

Revision as of 08:01, 8 December 2012

Purpose

Change or deactivate the active dictionary

Syntax

SET DICTIONARY ON | OFF | (<expL>)

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

See Also

ALTER TABLE, CREATE DICTIONARY, CREATE TABLE, DISPLAY DICTIONARY, LIST DICTIONARY

Description

The SET DICTIONARY ON | OFF command enables or disables the use of Lianja’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 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