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
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
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