SQL Queries - CAST Knowledge Base - Queries on Transactions - How to list Transactions reaching Data Functions

Purpose of Query

This query will list the transactions entry point and their end points which are only ending at tables (Data functions).

You may refer to TCC - AFP Calibration - Data Functions/Transactional Functions sub-nodes - Right hand panel for more information about Transaction and Data Function

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT a.object_name, 
       a.object_type_str, 
       b.object_name, 
       b.object_type_str 
FROM   cdt_objects a, 
       cdt_objects b, 
       dssapp_transactiondataview dtd, 
       dss_transaction dt, 
       dss_datafunction dd 
WHERE  dtd.transaction_id = dt.object_id 
       AND dtd.datafunction_id = dd.object_id 
       AND a.object_id = dt.form_id 
       AND b.object_id = dd.maintable_id

Query result example

“HomeJS.jsp”;“eFile”;“Hello”;“Oracle table”

Query result interpretation

The above query returns the entry point, the type of the entry point, the Data Function and the type of Data Function

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages