CAST Engineering Dashboard - Information - Setting objects as external

Purpose

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

Applicable in CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS✅

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>, 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 ‘’);

   2. With CAST AIP >=8.3.37:

      ```sql
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>');
  1. Run analysis and Generate snapshot (skip analysis if already analyzed )