Difference between revisions of "COPY DICTIONARY"
Yvonne.milne (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 13: | Line 13: | ||
The .xad table is created with the following structure: | The .xad table is created with the following structure: | ||
| − | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
| − | !widt=25%|Field||Type||Length||width=45%|Description | + | !widt="25%"|Field||Type||Length||width="45%"|Description |
|- | |- | ||
|XAD_TYPE||Character||3||File Type | |XAD_TYPE||Character||3||File Type | ||
Latest revision as of 08:57, 5 February 2013
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
