ALL Access Definition

Edit online

Removes the selection criteria and SQL WHERE Clause defined for a specified table in an Access Definition, and therefore processes ALL rows in the table. If the table is the Start Table, all Point-and-Shoot and Group Selection specifications are also removed.


ALL [ table ]
table
Name of the table for which all selection criteria and SQL WHERE Clause specifications are to be removed. The Creator ID is required if the specified table has a Creator ID other than the specified default Creator ID.
  • This command is available on the Select Tables/Views for AD panel.
  • This command is cursor sensitive. If a table name is not specified, the cursor position determines the table. If the cursor is not positioned on a table, an error message is displayed unless one table is specified. When one table is specified, that table is assumed.
  • The equivalent line command is ALL.
  • The CLEAR command removes all criteria specifications for the named column in a table. This command can be entered on the Specify Archive Criteria panel. To clear the specifications for a specific column, use the line command CLR.