Purpose

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

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
Details

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 )