CLOSE command

Closes an Analytics table, index file, or log file, or ends a Script Recorder session.

Syntax

CLOSE <table_name|PRIMARY|SECONDARY|INDEX|LOG|LEARN>

Parameters

Name Description
table_name|PRIMARY|SECONDARY|INDEX|LOG|LEARN

optional

The item to close:

  • table_name the name of the Analytics table to close
  • PRIMARY closes the primary Analytics table

    Using CLOSE without any parameters also closes the primary table.

  • SECONDARY closes the secondary Analytics table
  • INDEX closes the current index applied to the Analytics table
  • LOG returns the log file to the default command log, after the SET LOG command has been used to specify another log file

  • LEARN ends the active Script Recorder session and prompts you to save the script file the session was recorded to

    LEARN can be used in scripts, but its intended use is in the command line. The Script Recorder records the ACLScript syntax for commands that are executed using dialog boxes in the Analytics user interface.

Examples

Closing a table by name

You want to close a table called Inventory:

CLOSE Inventory

Closing a table by type

You want to close the current secondary table:

CLOSE SECONDARY

Restoring the default Analytics command log

You want to restore the default command log after using a separate log file to capture the data verification phase of a script:

SET LOG TO "DataVerificationPhase.log" 
COMMENT Execute data verification commands 
CLOSE LOG

Remarks

When to use CLOSE

You typically do not need to close Analytics tables. The active Analytics table automatically closes when you open another table. The primary table also closes automatically before the OPEN or QUIT commands execute.

You cannot use CLOSE to close an Analytics project. Use QUIT instead.

Related fields and tables

When you close a primary or secondary table, all related field definitions are removed from memory. Any changes to the table layout are saved before the table is closed.

If you have defined table relations in an Analytics project, the CLOSE command closes both the primary and any secondary tables. It also closes the related tables.