sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
I have a parent & child table. Child table has orphan records which are not in the parent table. how to delete these records from the child table.
This is the CHECK DATA job
Code: |
//HXSULLCH JOB (T,TEST),'CHECK DATA',CLASS=C,MSGCLASS=X,
// NOTIFY=&SYSUID
//*....................................................................
//UTIL0001 EXEC PGM=DSNUTILB,COND=(4,LT), * CD (MJUTLCD)
// PARM='DB2D'
//STEPLIB DD DISP=SHR,DSN=DB2.DB2D.DSNEXIT
// DD DISP=SHR,DSN=DB2.DB2D.DSNLOAD
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSERR DD UNIT=SYSDA,DISP=(,PASS),
// SPACE=(CYL,(676,1))
//SYSPUNCH DD UNIT=SYSDA,DISP=(,PASS),
// SPACE=(CYL,(676,1))
//SYSUT1 DD UNIT=SYSDA,DISP=(,PASS),
// SPACE=(CYL,(676,1))
//SORTOUT DD UNIT=SYSDA,DISP=(,PASS),
// SPACE=(CYL,(676,1))
CHECK DATA TABLESPACE SHANDB.SIMPLETS
SCOPE ALL
SORTDEVT SYSDA SORTNUM 03 |
Thank You,
Sushanth Bobby |
|