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

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅

Applicable RDBMS

RDBMSYes/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