SQL Queries - CAST Knowledge Base - Queries on Links - How to list the link types that can be inserted into CI LINKS through a KB Update Tool

Purpose of Query

The query is useful to list the choices of link types available when you want to insert a link between two objects through a KB Update Tool.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS(tick)
Query for CSS
SELECT Typ.*
FROM   Typ   ,
       TypCat,
       Cat
WHERE  Typ.IdTyp          = TypCat.IdTyp
AND    TypCat.IdCatParent = Cat.IdCat
AND    Cat.CatNam         = 'physicalLink'
Query result example

1036;"useLink";"useLink";"ACTIVE "
2619;"callProgLink";"callProgLink";"ACTIVE "
2620;"callTransacLink";"callTransacLink";"ACTIVE "
2621;"callPerformLink";"callPerformLink";"ACTIVE "
2622;"callGotoLink";"callGotoLink";"ACTIVE "
2623;"inheritExtendLink";"inheritExtendLink";"ACTIVE "
1035;"inheritImplementLink";"implementLink";"ACTIVE "
2624;"inheritHideLink";"inheritHideLink";"ACTIVE "
2625;"inheritOverrideLink";"inheritOverrideLink";"ACTIVE "
1034;"inheritLink";"inheritLink";"ACTIVE "
2626;"fireBeforeLink";"fireBeforeLink";"ACTIVE "
2627;"fireAfterLink";"fireAfterLink";"ACTIVE "
2628;"fireInsteadOfLink";"fireInsteadOfLink";"ACTIVE "
2629;"fireForEachRowLink";"fireForEachRowLink";"ACTIVE "
2630;"fireForAllRowsLink";"fireForAllRowsLink";"ACTIVE "
2631;"fireInsertLink";"fireInsertLink";"ACTIVE "
2632;"fireUpdateLink";"fireUpdateLink";"ACTIVE "
2633;"fireDeleteLink";"fireDeleteLink";"ACTIVE "
2634;"fireSelectLink";"fireSelectLink";"ACTIVE "
2603;"fireLink";"fireLink";"ACTIVE "
2635;"monitorBeforeLink";"monitorBeforeLink";"ACTIVE "
2636;"monitorAfterLink";"monitorAfterLink";"ACTIVE "
2637;"monitorInsteadOfLink";"monitorInsteadOfLink";"ACTIVE "
2638;"monitorForEachRowLink";"monitorForEachRowLink";"ACTIVE "
2639;"monitorForAllRowsLink";"monitorForAllRowsLink";"ACTIVE "
2640;"monitorInsertLink";"monitorInsertLink";"ACTIVE "
2641;"monitorUpdateLink";"monitorUpdateLink";"ACTIVE "
2642;"monitorDeleteLink";"monitorDeleteLink";"ACTIVE "
2643;"monitorSelectLink";"monitorSelectLink";"ACTIVE "
2604;"monitorLink";"monitorLink";"ACTIVE "
2644;"accessExecLink";"accessExecLink";"ACTIVE "
2645;"accessMemberLink";"accessMemberLink";"ACTIVE "
2672;"accessMemberExecLink";"accessMemberLink";"ACTIVE "
2646;"accessArrayLink";"accessArrayLink";"ACTIVE "
2647;"accessReadLink";"accessReadLink";"ACTIVE "
2648;"accessWriteLink";"accessWriteLink";"ACTIVE "
2649;"accessOpenLink";"accessOpenLink";"ACTIVE "
2650;"accessCloseLink";"accessCloseLink";"ACTIVE "
2651;"accessPageIncludeLink";"accessPageIncludeLink";"ACTIVE "
2652;"accessPageForwardLink";"accessPageForwardLink";"ACTIVE "
2605;"accessLink";"accessLink";"ACTIVE "
2653;"containDefineLink";"containDefineLink";"ACTIVE "
2654;"containDeclareLink";"containDeclareLink";"ACTIVE "
2606;"containLink";"containLink";"ACTIVE "
2655;"ddlCreateLink";"ddlCreateLink";"ACTIVE "
2656;"ddlAlterLink";"ddlAlterLink";"ACTIVE "
2657;"ddlReplaceLink";"ddlReplaceLink";"ACTIVE "
2658;"ddlDropLink";"ddlDropLink";"ACTIVE "
2607;"ddlLink";"ddlLink";"ACTIVE "
2659;"referCascadeLink";"referCascadeLink";"ACTIVE "
2660;"referSetnullLink";"referSetnullLink";"ACTIVE "
2661;"referInsertLink";"referInsertLink";"ACTIVE "
2662;"referUpdateLink";"referUpdateLink";"ACTIVE "
2663;"referDeleteLink";"referDeleteLink";"ACTIVE "
2608;"referLink";"referLink";"ACTIVE "
2664;"relyonIsInstanceOfLink";"relyonIsInstanceOfLink";"ACTIVE "
2609;"relyonLink";"relyonLink";"ACTIVE "
2665;"joinSpForeignKeyLink";"joinSpForeignKeyLink";"ACTIVE "
2666;"joinSpCommonKeyLink";"joinSpCommonKeyLink";"ACTIVE "
2667;"joinNonSysCatalogLink";"joinNonSysCatalogLink";"ACTIVE "
2610;"joinLink";"joinLink";"ACTIVE "
2611;"catchLink";"catchLink";"ACTIVE "
2612;"friendLink";"friendLink";"ACTIVE "
2613;"mentionLink";"mentionLink";"ACTIVE "
2614;"raiseLink";"raiseLink";"ACTIVE "
2615;"throwLink";"throwLink";"ACTIVE "
2616;"lockLink";"lockLink";"ACTIVE "
1037;"prototypeLink";"prototypeLink";"ACTIVE "
1045;"includeLink";"includeLink";"ACTIVE "
2617;"matchLink";"matchLink";"ACTIVE "
2618;"gothroughLink";"gothroughLink";"ACTIVE "
2668;"internallyEscalatedLink";"internallyEscalatedLink";"ACTIVE "
2669;"dynamicLink";"dynamicLink";"ACTIVE "
2670;"staticLink";"staticLink";"ACTIVE "
141455;"Cast_ReferenceFinder_LinkForDLM";"Link for DLM";"ACTIVE "
1063;"useSelectLink";"useSelectLink";"ACTIVE "
1064;"useUpdateLink";"useUpdateLink";"ACTIVE "
1066;"useInsertLink";"useInsertLink";"ACTIVE "
1065;"useDeleteLink";"useDeleteLink";"ACTIVE "
1040;"callLink";"callLink";"ACTIVE "

Query result interpretation
 You have to choose the type of link you want to insert among those list.
Notes/comments



Related Pages