Transaction Configuration Center - Information - How to extract Transaction and Data Function information's per snapshot

Purpose of Query

The queries in this page will help you to extract transaction and Data Function information per snapshot.

You will be able to get the  snapshot id, Transaction\Data Function id, snapshot name, Transaction\Data Function name, Type, status, FP value,  Transaction\Data Function full name, complexity and AEFP value

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅

Applicable RDBMS

RDBMSYes/No
CSS4✅
CSS3✅
CSS2✅

Query for CSS

  1. On CB, Install the following stored procedures - DF.sqlTR_DF.sqlTR.sql

  2. Run the bellow query

 select TR_DF()

3. To get Data Functions run the following :

   ```sql
select *
from datafunctions

Query result example

8 5671007 “hello1” “main” “DET: 56, FTR: 2 (Input)” “UNCHANGED” 6 “main” 0 0.0
3 5667516 “hello2” “NcmsDSFServlet” “DET: 38, FTR: 5 (Output or Inquiry)” “UNCHANGED” 7 “NcmsDSFServlet” 0 0.0 4. To get Transactions run the following :

select *
from transactions

Query result example

8 5671007 “hello1” “main” “DET: 56, FTR: 2 (Input)” “UNCHANGED” 6 “main” 0 0.0
3 5667516 “hello2” “NcmsDSFServlet” “DET: 38, FTR: 5 (Output or Inquiry)” “UNCHANGED” 7 “NcmsDSFServlet” 0 0.0

Notes/comments

Related Pages