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

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

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 :

   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