Difference between revisions of "COPY DICTIONARY"
Helen.george (Talk | contribs) |
|||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Copy dictionary attributes to a table file | Copy dictionary attributes to a table file | ||
− | |||
==Syntax== | ==Syntax== | ||
COPY DICTIONARY TO <.xad file> [ADDITIVE] | COPY DICTIONARY TO <.xad file> [ADDITIVE] | ||
− | |||
==See Also== | ==See Also== | ||
[[BUILD]], [[COPY]], [[COPY STRUCTURE EXTENDED]], [[CREATE FROM]], [[CREATE DICTIONARY]], [[DISPLAY DICTIONARY]], [[INSTALL]], [[LIST DICTIONARY]], [[SET DICTIONARY]] | [[BUILD]], [[COPY]], [[COPY STRUCTURE EXTENDED]], [[CREATE FROM]], [[CREATE DICTIONARY]], [[DISPLAY DICTIONARY]], [[INSTALL]], [[LIST DICTIONARY]], [[SET DICTIONARY]] | ||
− | |||
==Description== | ==Description== | ||
Line 15: | Line 12: | ||
The .xad table is created with the following structure: | The .xad table is created with the following structure: | ||
− | |||
{| class="wikitable" | {| class="wikitable" | ||
Line 33: | Line 29: | ||
|- | |- | ||
|} | |} | ||
− | |||
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. | 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. | ||
Line 39: | Line 34: | ||
====ADDITIVE==== | ====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. | 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== | ==Example== | ||
Line 46: | Line 40: | ||
copy dictionary to accounts | copy dictionary to accounts | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 11:34, 12 December 2012
Purpose
Copy dictionary attributes to a table file
Syntax
COPY DICTIONARY TO <.xad file> [ADDITIVE]
See Also
BUILD, COPY, COPY STRUCTURE EXTENDED, CREATE FROM, CREATE DICTIONARY, DISPLAY DICTIONARY, INSTALL, 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
Products
Lianja Server, Lianja