Clears data values from the database and sets them to #MISSING
.
CLEARDATA mbrName;
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
The CLEARDATA command clears a well-defined section of a database's cells and changes the values of those cells to #MISSING
values. This command is useful when you need to clear existing data values before loading new values into a database. CLEARDATA can only clear a section of a database. It cannot clear the entire database. To clear the entire database,
alter database <dbs-name> reset; or
CLEARDATA does not clear blocks, even if all data values in a block are #MISSING. Use CLEARBLOCK if you wish to clear blocks from the database, which can improve performance.
CLEARDATA does not work if placed in an IF statement.
CLEARDATA Budget;
clears all Budget data.
CLEARDATA Budget->Colas;
clears only Budget data for the Colas product family.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |