Copy Data
Use this command to copy non-zero data in the Data Server repository from one symbol to another.
Use this command to directly manipulate data in the Data Server repository, based on an intersection of data specified. Copy Data From does not overwrite existing non-zero data in the target area unless there is non-zero data in the source area for that data. When copying data from a parent symbol to a child symbol, the data is copied even if the parent symbol is a virtual parent.
If a user has any symbol access that is read-only in the area defined by the lock to which the command pertains, the Copy Data command is allowed to continue and all read-only symbols will be ignored (not copied). If you try to copy to an area that is read-only, an error message appears.
Syntax:
COPY DATA FROM DimName SourceSymName TO TargetSymName [DataType] USING dataspec.lvdsp
where:
- DimName is a dimension containing the symbols to copy data.
- SourceSymName is a symbol whose data you want to copy.
- TargetSymName is a symbol that will contain the copied data.
- DataType is optional and can be one of the following:
Value Description PARENT
To copy data from (UP + AP) to UL table. The PARENT option does not copy the rollup value of a carryforward parent. If SourceSymName is a virtual parent, the value of the source symbol is recalculated before copying it.
LEAF
To copy data from UL to UL table.
CALCLEAF
To copy data from (UC + UL + AC + AL) to UL table.
CTA
To copy data from (UT, AT) to (UT, AT) table.
ADJUSTEDLEAF
To copy data from (UL + UA) to UL table.
- dataspec.lvdsp is the name of the DataSpec file.
The following table explains the abbreviations in the DataType parameters:
| Parameter | Description |
|---|---|
U |
unadjusted |
A |
adjusted |
C |
calculated |
L |
leaf |
P |
parent |
T |
CTA |
+ |
add value for the identical coordinate |
, |
the corresponding table (for example, unadjusted to unadjusted) |
Syntax example:
CREATE LOCK USER USING CopyNI.lvdsp "Copy plan income"
COPY DATA FROM TIMEPER A0312 TO P0401 CALCLEAF USING CopyNI.lvdsp
DELETE LOCK USER USING CopyNI MATCH