Delete Symbol

Use this command to delete a symbol from the Data Server repository.

When you delete symbols, do so from the bottom up. In other words, delete or move each leaf symbol before you delete their parent symbol.

When you delete a symbol, you also need to delete its data. To do this, follow this process:

1. Export
2. Import system data
3. Import data
4. Run restatement

For more information, see the Longview Application Administrator Guide.

This command must be used in conjunction with Maintenance. While it is enabled, no other users can perform maintenance related activities in the Data Server repository. When you are finished, you must remember to disable the Maintenance mode, and thereby allow normal access by other users.

For more information, see Maintenance or Exclusive.

Caution: This command cannot be undone. Use with caution.

DELETE SYMBOL DimName SymName             

where:

• DimName is the dimension containing the symbol.
• SymName is the name of the symbol to delete.

MAINTENANCE ON
DELETE SYMBOL ACCOUNTS NewSales                             
MAINTENANCE OFF

Creating an ASCII input file

To delete a large number of symbols from the Data Server repository, specify the parameters for this command in an ASCII file.

Create an ASCII file containing the following information for each symbol:

SymName

DELETE SYMBOL DimName @FileName                

where:

• DimName is the dimension containing the symbols.
• FileName is an ASCII file containing the data. It can include a complete or partial folder path in the format C:\...\FileName. If FileName includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\My Data.txt"

Note: If the document is in the same location as lv_af.exe, you do not need to specify the drive or path.

MAINTENANCE ON
DELETE SYMBOL ACCOUNTS @C:\Temp\Test.asc            
MAINTENANCE OFF 

See also

• Create Symbol