I am trying to unload the data from a DB2 table using an BMC Utility. I am getting the following error:
BMC51675I UNLOAD STATISTICS: 5 RECORDS DISCARDED DUE TO ERRORS
This is because of the Bad data in one of the DATE fields in the Table.
Ofcourse I have idetified that field.
But I need to handle it in the JCL while Unloading he Data. The value in that DATE field is '20071131' Its the wrong data. Because November has only 30 days. Because of this BMC utility is discarding the 5 records those having this value.
For this I need to handle this and need to change it to either '20071130' or '20071201'.
there are many issues on date changes in databases...
technical issues ...
the easier to solve
legal, auditing issues...
whenever a date change occurs in a database with dates related to financial transaction
there is a lot of paper work to be done in order to leave an auditable trace of what has been done to correct the wrong date
after the legal issues have been taken care of
any mean can be used to change the wrong data
as long as a clear TRACE of the changes can be archived
I would say that SPUFI/QMF are out of the scenario
unless the legal/audit department says that a before/after printout is enough
Anyway for a plain wrong ( non existent ) date the task might be easier...
:-) think what would happen in a bank if the system was ipl' ed with the wrong date ...
- happened at 5 in the morning, luckily discovered at 6 !
Is there any way we can handle this in a JCL. If so please let me know.
Error correction is just something that cannot be done without people being involved.
There should always be some awareness of what is going on.
Automating things will certainly make somebody underestimate or even not realize the presence of errors
if a date is wrong there is no reason to believe that simply plugging in a correct date ( from a formal point of view )
will give You a correct date from a business point of view
each one of these errors must be handled individually
NO You cannot handle in JCL terms
YES given the right utilities/user-written-programs You can define thru jcl a sequence of steps to be executed to do what You want