SQL Queries - CAST Knowledge Base - Queries on Data Functions - How to get the Merged object of a Main object in a Data Function Merge

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_DATAFUNCTION DSS
       JOIN KEYS K
         ON K.IDKEY = DSS.MAINTABLE_ID
       JOIN DSS_KEYSEXTRA EXT
         ON EXT.OBJECT_ID = DSS.CAL_MERGEROOT_ID
WHERE  EXT.OBJECT_NAME  = 'Data_Function_name'

Query result example

-- Main,Merged

Query result interpretation

The query returns the Main object and the merged object

Query for Oracle

SELECT EXT.OBJECT_NAME AS MAIN_MERGE,
       K.KEYNAM       AS DETAILED_MERGE
FROM   DSS_DATAFUNCTION DSS
       JOIN KEYS K
         ON K.IDKEY = DSS.MAINTABLE_ID
       JOIN DSS_KEYSEXTRA EXT
         ON EXT.OBJECT_ID = DSS.CAL_MERGEROOT_ID
WHERE  EXT.OBJECT_NAME  = 'Data_Function_name'

Query result example

-- Main,Merged

Query result interpretation

The query returns the Main object and the merged object

Query for SQL server

SELECT EXT.OBJECT_NAME AS MAIN_MERGE,
       K.KEYNAM       AS DETAILED_MERGE
FROM   DSS_DATAFUNCTION DSS
       JOIN KEYS K
         ON K.IDKEY = DSS.MAINTABLE_ID
       JOIN DSS_KEYSEXTRA EXT
         ON EXT.OBJECT_ID = DSS.CAL_MERGEROOT_ID
WHERE  EXT.OBJECT_NAME  = 'Data_Function_name'

Query result example

-- Main,Merged

Query result interpretation

The query returns the Main object and the merged object

Notes/comments

Related Pages