Managing Compass data

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

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

To generate an administrative procedure:

  1. Hover over a data object name.
  2. Click on 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')