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
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS2 | |
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
