SQL Queries - CAST Knowledge Base - Queries on Transactions - How to get the Main object of a Merged object in a Transaction Merge

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

Applicable RDBMS

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