Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

5 records are discarded due to errors while unloading

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri Sep 28, 2007 11:42 am    Post subject: 5 records are discarded due to errors while unloading
Reply with quote

Hi all,

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'.

I should not skip them anyway.

Can anyone provide me the solution for this.

Any suggestions are qppreciated.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Fri Sep 28, 2007 11:56 am    Post subject: Reply to: 5 records are discarded due to errors while unload
Reply with quote

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 !
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri Sep 28, 2007 12:32 pm    Post subject:
Reply with quote

thanks enrico-sorichetti,

What u said is exactly right.

Is there any way we can handle this in a JCL. If so please let me know.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Fri Sep 28, 2007 12:51 pm    Post subject: Reply to: 5 records are discarded due to errors while unload
Reply with quote

Quote:
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


regards

e.s
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us