|
View previous topic :: View next topic
|
| Author |
Message |
rexx77
New User
Joined: 14 Apr 2008
Posts: 78
Location: Mysore
|
|
|
|
Greetings.
I wanted to run check data utility on a particular table which is in check pending mode.
I am using the following JCL to run the check data.
| Code: |
//STEP1 EXEC DSNUPROC,UID='ABCDEF',SYSTEM='XXXX'
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
CHECK DATA TABLESPACE XXXXXX.XXXXXX
FOR EXCEPTION IN SCHEMA.TABLENAME USE SYSERR
DELETE NO
/*
|
i wanted to see the records which does not satisfy the constraint check in a dataset, how to modify the above jcl control card.
I have created a file USERID.SYSERR but it is searching for USERID.SYSERR table. Even i know USE CLause will search for table only but i cant create any table for this purpose.
I would appreciate if some one out there has any ideas |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Greetings rexx77,
| Quote: |
| I wanted to see the records which does not satisfy the constraint check in a dataset |
Sorry to break you the bad news. CHECK utility doesn't check data in a dataset.
| Quote: |
| I have created a file USERID.SYSERR but it is searching for USERID.SYSERR table. Even i know USE CLause will search for table only but i cant create any table for this purpose. |
Why?
| Quote: |
| I would appreciate if some one out there has any ideas |
You can write a program to CHECK your check constraints using your input dataset.
OR
Create a exception table.
Run CHECK utility.
OR
Make plans to alter your batch programs so that only valid data is loaded into the table.
Sushanth |
|
| Back to top |
|
|
rexx77
New User
Joined: 14 Apr 2008
Posts: 78
Location: Mysore
|
|
|
|
Thanks Sushanth...
Just out of curiosity, i wanted to know is there any impact in creating exception table?....
I dont have any idea of exception tables, i will go through the literature.. I will get to back to this forum when i have a doubt.
Many thanks.... |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
rexx77,
| Quote: |
Just out of curiosity, i wanted to know is there any impact in creating exception table?....
|
Impact hmmm. Yes, one additional object in the subsystem.
| Quote: |
| I dont have any idea of exception tables, i will go through the literature.. I will get to back to this forum when i have a doubt. |
Good.
Sushanth |
|
| Back to top |
|
|
|
|
