IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to identify wrong data in millions of records?


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 5:50 pm
Reply with quote

This is an interview question from Perot Systems?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Feb 05, 2008 5:55 pm
Reply with quote

what do the idiots consider wrong data ??

the number of records is irrelevant
Back to top
View user's profile Send private message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 6:07 pm
Reply with quote

Idiots will idiot words.You are a big idiot.See if file has a numeric data instead for nonnumeric data that job will abend.Please tell how to identify that bad data
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Feb 05, 2008 6:19 pm
Reply with quote

prasadk432 wrote:
Idiots will idiot words.You are a big idiot.See if file has a numeric data instead for nonnumeric data that job will abend.Please tell how to identify that bad data


Nonnumeric data instead of numeric data will cause more of a problem, or numeric data that is out of range, invalid dates, or missing data.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Feb 05, 2008 6:21 pm
Reply with quote

are You perchance referring to me as an idiot ??
Back to top
View user's profile Send private message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 6:40 pm
Reply with quote

No..No...
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Feb 05, 2008 6:41 pm
Reply with quote

Quote:
... See if file has a numeric data instead for nonnumeric data that job will abend.Please tell how to identify that bad data


wrong assumption
from the question subject " How to identify wrong data in millions of records?"

wrong data is any data which does not abide/respect the application specifications
best regards
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia

PostPosted: Tue Feb 05, 2008 6:43 pm
Reply with quote

This entire thread should be eliminated.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Feb 05, 2008 6:56 pm
Reply with quote

Agree on that, Phil,,

maybe it' s my fault but I have the bad habit of reacting strongly to stupid/misleading questions

I imagine the poor candidate anxious for the opportunity for a new job
being questioned/examined not on his/her skills but rather
on the speed of reaction to stupid questions,
that' not interviewing but rather horse betting

I remember my - almost flunked - algebra exam in college when I was asked..
write down an array ...
and I kept asking myself what in h**l he wanted and after a while
the examiner began writing for me ...

Code:
a11 a12 a13 ... a1n
a21 a22 a23 ... a2n
....
am1 am2 am3 ... amn

indexes and m and n subscripts
stupid question wasn' t it???
Back to top
View user's profile Send private message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 7:20 pm
Reply with quote

what is stupid in it? An input file contains a millions of records if it contains bad data and processed in next job and if job gets abended.how to find the bad data.See mistakes are done by human to forgive is divine.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Feb 05, 2008 7:32 pm
Reply with quote

There are many ways to check for bad data. Write a COBOL program, write an EZTrieve program, write an assembler program, etc.
Back to top
View user's profile Send private message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 7:43 pm
Reply with quote

what logic we have to code if we use cobol pgm since file contains so many columns.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Feb 05, 2008 8:54 pm
Reply with quote

prasadk432 wrote:
what logic we have to code if we use cobol pgm since file contains so many columns.


How ever much logic it will take to be sure all the data is valid!
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia

PostPosted: Tue Feb 05, 2008 9:22 pm
Reply with quote

Again - this is the most ridiculous thread I've seen here.

I had a client years ago to whom I gave a gag gift of a keyboard with all the buttons removed and replaced with one huge paper mache button that simply said "DO IT".
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Feb 05, 2008 9:56 pm
Reply with quote

prasadk432 wrote:
what logic we have to code if we use cobol pgm since file contains so many columns.


noone but you knows the file copybook...and the format of every field in the record... so the right values every field must have.
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Tue Feb 05, 2008 10:19 pm
Reply with quote

Bad data in fields is no problem, if the practice that I was taught almost 30 years ago is followed. The first program in a system that uses data from outside the system must make sure no bad data get into the system. Check the program specs for this first program and it should tell you for each field what values are ok and what to do with data that is not good. To find the bad data look at the error reports and/or error files coming out of this program.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Feb 06, 2008 12:35 am
Reply with quote

Hello,

Quote:
How to identify wrong data . . .

This is an interview question from Perot Systems?

what logic we have to code if we use cobol pgm since file contains so many columns.
One answer is that until all of the validation rules for every field have been defined, it cannot be done.

Quote:
Again - this is the most ridiculous thread I've seen here.
Not all of us can can say this icon_smile.gif

Quote:
I gave a gag gift of a . . . . that simply said "DO IT".
Once bought 25 blank "keys", labeled them with "DWIM", and stuck them with 2-sided tape on some prominent place on selected user's keyboards. (DWIM - Do What I Meant).

d
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Wed Feb 06, 2008 12:06 pm
Reply with quote

Have counters defined in your program and everytime you process a record successfully increment that and display them in case of a abend will be a good start......

And as enrico-sorichetti said

Quote:
wrong data is any data which does not abide/respect the application specifications


sk
Back to top
View user's profile Send private message
Rahul_kumar
Warnings : 2

New User


Joined: 24 Jun 2006
Posts: 50

PostPosted: Sun Mar 23, 2008 9:53 pm
Reply with quote

I thk we can use display statements in the program to find the statement for which the program abends.
or there is another method to identify the SOC7 error using OFFSET address but i don't know the same.Can anyone pls help.
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Mon Mar 24, 2008 10:52 pm
Reply with quote

Years ago I supported a system, that when it abended, it would "snap dump", then the program would backout the changes for the current bad record, and write the bad record to an error file, then go on with the next record. I am not sure how they did that. A good edit program would have make that almost unneeded. But it is an interesting idea.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top