IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Check data with Exception Table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Sun Nov 05, 2023 12:37 am
Reply with quote

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?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top