How to list or retrieve goldencopy records for a repository given the repository ID?

book

Article ID: KB0094323

calendar_today

Updated On:

Products	Versions
TIBCO MDM	-
Not Applicable	-

Description

Resolution:
Assuming the ID of the repository is XXXXX, the following SQL statement can be used to retrieve goldencopy records for a repository.

SELECT MCT_XXXXX.* FROM MCT_XXXXX, GOLDENCOPY WHERE
MCT_XXXXX.CPRODUCTKEYID=GOLDENCOPY.PRODUCTKEY AND
MCT_XXXXX.CMODVERSION=GOLDENCOPY.VERSION;

Environment