Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
Hello,
I ran check data for a table that was left in check pending and I noticed there were few orphan records.
So I created exception table for this table (left in check pending) and ran check data like below
"CHECK DATA TS"TSNAME"
FOR EXCEPTION IN "TABLE NAME " USE "EXCEPTION TABLE NAME"
DELETE YES".
mismatched orphan rows removed from child table & placed into exception table,which cleared check pending.
But I see few jobs,where the check data is run on parent table listing all "child table" in exception.
"CHECK DATA TS" PARENT TSNAME"
FOR EXCEPTION IN " CHILD TABLE NAME 1 " USE " CHILD EXCEPTION TABLE NAME 1"
FOR EXCEPTION IN " CHILD TABLE NAME 2 " USE " CHILD EXCEPTION TABLE NAME 2"
DELETE YES".
Which is correct way of specifying check data with exception? 1st example or second eg? what does the above mean-check data should be run on child right? why it has been run on parent table? |
|
