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 Using Multiple IFTHEN and WHEN condit... SYNCSORT 12
No new posts Check if CICS is online in JCL CICS 10
No new posts Unload and Load ISPF Table TSO/ISPF 4
No new posts ISPF Table to add a new column TSO/ISPF 1
No new posts Inserting into table while open selec... DB2 1
Search our Forums:

Back to Top