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
