CAST Engineering Dashboard - Information - Setting objects as external

This page describes step by step approach to setting an object(s) as external

Objects can be set as external by adding an SQL tool job in CMS by following the below steps :

1.  In CMS Double click on the application
2. Goto "Modules" tab
3. Add SQL Tool under "Tools after module generation"

4. add the below query. You can replace <Knowledge_base>,<path> with the name of your Knowledge base and desired path respectively in the below query.

   1. 
      

      With CAST AIP < 8.3.37:

      update <Knowledge_base>.CTT_OBJECT_APPLICATIONS 
      set PROPERTIES = 1 
      where OBJECT_ID in (select OBJECT_ID 
      from <Knowledge_base>.CSV_FILE_OBJECTS 
      where lower(FILE_PATH) like '<path>');

   2. With CAST AIP >=8.3.37:

      update <Knowledge_base>.CTT_OBJECT_APPLICATIONS 
      set PROPERTIES = PROPERTIES | 256 
      where OBJECT_ID in (select OBJECT_ID 
      from <Knowledge_base>.CSV_FILE_OBJECTS 
      where lower(FILE_PATH) like '<path>');

5. Run analysis and Generate snapshot (skip analysis if already analyzed )