Purpose of Query
This query returns the Merged object and the Main object of a Transactions merge:
You may refer to TCC - Merge/Unsplit objects for more information about Transaction merge
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
SELECT ext.object_name AS Main_merge,
K.keynam AS detailed_merge
FROM dss_transaction DSS
JOIN <Name of current local base>.keys K
ON K.idkey = DSS.form_id
JOIN dss_keysextra ext
ON ext.object_id = DSS.cal_mergeroot_id
WHERE ext.object_name = 'Entry point name'
You need to replace 'Entry point name' by the name of the Main object
Query result sample:
Query result example
"Menu.jsp";"Login.jsp"
If he query returns no rows, then the Transaction is not merged.
Interpretation:
Query result interpretation
The above query returns the Main object and the Merged 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
