Managing Compass data

You can generate administrative procedures to manage the Compass data storage.

To generate an administrative procedure:

  1. Rest on a data object name.
  2. Click the ellipsis icon.
  3. Select Generate > Admin.
  4. Select one of the available administrative commands:
    • Clear Table – Remove Formatted Data

      exec infor.clear_table('Order_TSV', 'true')

    • Clear Table – Retain Formatted Data

      exec infor.clear_table('Order_TSV', 'false')

    • Clear Data

      exec infor.clear_data('Order_TSV', 'YYYY-MM-DD')

    For more details on the administrative command functionality see Data administration stored procedures.