Querying The Alter Repository

This section provides these examples to illustrate the type of information you can gather from the contents of the alter repository.

• Example: Fields Altered For Target Records

• Example: Source Records Deleted From Target

• Example: Source Records Renamed In Target

Example: Fields Altered For Target Records

This sample query illustrates how to determine which fields on a particular target record will be altered why.

SELECT
 PTUPG_TRECNAME, 
 PTUPG_TFLDNAME,
 PTUPG_ALTACT_A,
 PTUPG_ALTACT_D,
 PTUPG_ALTACT_CT,
 PTUPG_ALTACT_CL,
 PTUPG_ALTACT_CD,
 PTUPG_ALTACT_CN,
 PTUPG_ALTACT_CDR,
 PTUPG_ALTACT_CDF,
 PTUPG_ALTACT_CEN,
 PTUPG_ALTACT_FR
FROM PS_PTUALTRECFLDDAT
WHERE PTUPG_TRECNAME LIKE 'JOB_CD_TBL'
 

Example: Source Records Deleted From Target

This sample query illustrates how to determine which records in the source database will be deleted from the target.

SELECT
 PTUPG_SRECNAME,
 PTUPG_STABNAME
FROM PS_PTUALTRECDATA
WHERE PTUPG_ALTACTION = 'DR'
 

Example: Source Records Renamed In Target

This sample query illustrates how to determine which records in the source database are being renamed in the target.

select 
		PTUPG_SRECNAME, 
		PTUPG_STABNAME,
		PTUPG_TRECNAME, 
		PTUPG_TTABNAME
FROM PS_PTUALTRECDATA
WHERE PTUPG_ALTACTION = 'RR'