Applies the source outline changes specified in the .CHG log file to the target database's outline you selected with the SELECT command.
If the database has multiple partitions of the same type to the same target database or from the same source database, use APPLYOTLCHANGEFILEEX instead, and specify the data direction.
Syntax
APPLYOTLCHANGEFILE numFiles fileName| Parameter | Description |
|---|---|
numFiles | A numeric value indicating the number of .CHG log files to read. |
Filename | The name of the .CHG log file to read. The filename must be the full path name of the desired change file on the target database. The filename must be in quotation marks (see example below). More than one file can be specified. |
Notes
When the source database outline is modified, the GETPARTITIONOTLCHANGES command records the outline changes to a .CHG file in the source database directory. Therefore, use APPLYOTLCHANGEFILE after calling GETPARTITIONOTLCHANGES. Specify the full path to the source database's .CHG file.
Example
Samppart Company, the target database, is selected. Apply outline changes from Sampeast East, the source database.
APPLYOTLCHANGEFILE "1" "C:\Hyperion\products\Essbase\EssbaseServer\app\Sampeast\East\ess00004.chg";
See Also