COPY DICTIONARY

From Lianjapedia
Jump to: navigation, search

Purpose

Copy dictionary attributes to a table file

Syntax

COPY DICTIONARY TO <.xad file> [ADDITIVE]

See Also

COPY, COPY STRUCTURE EXTENDED, CREATE FROM, CREATE DICTIONARY, DISPLAY DICTIONARY, LIST DICTIONARY, SET DICTIONARY

Description

The COPY DICTIONARY command is used to import attributes in an Application Data Dictionary (ADD) into a table file. A new dictionary may be created by using the CREATE DICTIONARY command.

The .xad table is created with the following structure:

Field Type Length Description
XAD_TYPE Character 3 File Type
XAD_FILE Character 255 File Name
XAD_ID Character 32 Object ID
XAD_OBJECT Character 10 Object Type
XAD_SEQNO Character 3 Object Value Sequence #
XAD_VALUE Character 255 Object Value

The records of the tale define the ADD attributes from the source table. These may be modified using any of the standard 4GL record editing commands (EDIT, REPLACE etc) if required.

ADDITIVE

If the <.xad file> already exists, the ADDITIVE keyword can be used to append records. If the ADDITIVE keyword is not specified, any records in the existing <.xad file> will be overwritten.

Example

use accounts
copy dictionary to accounts