Page tree
Skip to end of metadata
Go to start of metadata


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(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
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

  • No labels