How to list or retrieve goldencopy records for a repository given the repository ID?
Article ID: KB0094323
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;
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;
Issue/Introduction
How to list or retrieve goldencopy records for a repository given the repository ID?
Environment
TIBCO MDM 8.X
Feedback
Yes
No
Powered by
