MVSFORUMS.com

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

HI ,

Suppose we got soc7 and the has millions of record .How to identify which record the abend occur so that we correct the data.

Thanks & regards,
Siva

dbzTHEdinosauer · Posted: Fri Aug 24, 2007 3:49 am Post subject:

write defensive code. i.e. IF NUMERIC
_________________
Dick Brenholtz
American living in Varel, Germany

shekar123 · Posted: Fri Aug 24, 2007 4:01 am Post subject:

Dick,

Looks like a cool answer from a program perspective but in case we are using a SORT utility which is doing some operations on fields and we get S0C7 how to find out which record is responsible for creating S0C7.
_________________
Shekar
Grow Technically

dbzTHEdinosauer · Posted: Fri Aug 24, 2007 4:12 am Post subject:

shekar123,

if the OP wanted a 'COOL' answer for SORT Utility, he should not have posted the question in Application Programming.
_________________
Dick Brenholtz
American living in Varel, Germany

kolusu · Posted: Fri Aug 24, 2007 7:02 am Post subject:

dbzTHEdinosauer · Posted: Fri Aug 24, 2007 7:29 am Post subject:

sivafdms,

IF it was a user written program (you and i are users) you would have to interpret the dump, if abend aid was not available. There are many threads on how to interpret dumps.
_________________
Dick Brenholtz
American living in Varel, Germany

bruce2359 · Posted: Fri Aug 24, 2007 1:48 pm Post subject:

Good (best practice) application architecture calls for an application program that will read each record in a file and validate all the fields in each record.
_________________
"Time is what keeps things from happening all at once" - anonymous fortune cookie

dbzTHEdinosauer · Posted: Fri Aug 24, 2007 3:24 pm Post subject:

You could follow Kolusu's suggestion and write a SORT which would validate your records. This would only be run when you have an error and don't want to use the dump. It would take a while to code, but would be always there as a debugging tool. Also, if you ran the SORT 'Proofer' and there was no bad data, then you know that the program managed to step-on-its-foot with something else - which means you have to go to the dump.
_________________
Dick Brenholtz
American living in Varel, Germany

edkir98 · Posted: Mon Aug 27, 2007 6:15 am Post subject:

If it is like processing on the input and then writing it to output files then you could use (NEW,CATLG,CATLG) on the output and find out till what record the input has processed
In case of DB2 you need to have a column in the table which should be updated when a particular read is successful. Jus like a status indicator. Very Happy

_________________
Thanks

Luc Orient · Posted: Mon Aug 27, 2007 12:45 pm Post subject:

May be ICETOOL with the VERIFY operator ?