Page tree
Skip to end of metadata
Go to start of metadata
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 )




  • No labels