SQL Queries - CAST Knowledge Base - Queries on Transactions - How to get the status of a transaction

Purpose of Query

This page provides information on how to check the status of a given transaction to see if it is Deleted, Ignored, Splitted, Merged as a main object, Merged as a Detail object

More on function points can be found here:

For 8.3: CAST OMG-compliant Automated Function Points

Information on the status of transactions can be found here:

For 8.3: TCC - Data Functions/Transactional Functions sub-nodes - Right hand panel

Applicable CAST Version

Applicable RDBMS

Query for CSS

Provide a Transaction Name in the query below and run

SELECT
       CASE
              WHEN cal_flags = 0
              THEN 'transaction is not a Merged, not Deleted, not ignored'
              WHEN cal_flags = 2
              THEN 'transaction is a Main object of Transaction Merge'
              WHEN cal_flags = 4
              THEN 'transaction is a detail of Transaction Merge'
              WHEN cal_flags = 8
              THEN 'transaction is deleted'
              WHEN cal_flags = 10
              THEN 'the parent of this transaction is deleted'
              WHEN cal_flags =256
              THEN 'transaction is ignored'
       END
FROM   dss_transaction
WHERE  form_id =
       (SELECT object_id
       FROM    cdt_objects
       WHERE   object_name = '<Transaction Name>'
       )

Query result example

“transaction is ignored”

Query result interpretation

The transaction will be examined based on the cal_flags field to determine if it is Deleted, Ignored, Splitted, Merged as a main object, Merged as a Detail object

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