Page tree
Skip to end of metadata
Go to start of metadata
Description

This page lists a query to fetch the complete list of standard analyzers meta-model based types that are used in the Dynamic Link Manager (DLM) Filter rules per technology.

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

The below query will list around 1500 object types that can be used in the DLM engine (and other configuration files either), grouping them by technology/language:


select c.CatDsc as "Technology/Language",
       t.TypDsc as "Type Description",
       t.IdTyp as "Type ID",
       t.TypNam as "Type Name"
  from Cat c
  join TypCat tct
    on tct.IdCatParent = c.IdCat
  join Typ t
    on t.IdTyp = tct.IdTyp
  join TypCat tc
    on tc.IdTyp = t.IdTyp
   and tc.IdCatParent = 1023
 where c.IdCat in (select cc.IdCat
                     from CatCat cc
                    where cc.IdCatParent = 6000)
 order by c.CatDsc, t.TypDsc;
Notes/comments


Query result example

 Each of the results returned should be like this sample below (Technology/Language, Type Description, Type ID, Type Name):


".Net";".NET AppSetting found in configuration file";137626;"CAST_DotNet_AppSettingType"

Related Pages





  • No labels