Purpose of Query
This query returns the Main object of a Merged object in a Transaction 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 K.keynam = 'Merged object name'
You need to replace 'Merged object name' by the name of the merged 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 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
