Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
How to identify wrong data in millions of records?
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions
Author Message
prasadk432

New User


Joined: 22 Dec 2007
Posts: 9
Location: Gurgaon

PostPosted: Tue Feb 05, 2008 5:50 pm    Post subject: How to identify wrong data in millions of records?
Reply with quote

This is an interview question from Perot Systems?
Back to top
View user's profile Send private message
References
PostPosted: Tue Feb 05, 2008 5:50 pm    Post subject: Re: How to identify wrong data in millions of records? Reply with quote

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 2565
Location: italy

PostPosted: Tue Feb 05, 2008 5:55 pm    Post subject: Reply to: How to identify wrong data in millions of records?
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    Post subject: Reply to: How to identify wrong data in millions of records?
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: 964
Location: Virginia, USA

PostPosted: Tue Feb 05, 2008 6:19 pm    Post subject: Re: Reply to: How to identify wrong data in millions of reco
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

Global Moderator


Joined: 14 Mar 2007
Posts: 2565
Location: italy

PostPosted: Tue Feb 05, 2008 6:21 pm    Post subject: Reply to: How to identify wrong data in millions of records?
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    Post subject: Reply to: How to identify wrong data in millions of records?
Reply with quote

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

Global Moderator


Joined: 14 Mar 2007
Posts: 2565
Location: italy

PostPosted: Tue Feb 05, 2008 6:41 pm    Post subject: Reply to: How to identify wrong data in millions of records?
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: 497
Location: Richmond, Virginia

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

This entire thread should be eliminated.
Back to top
View user's profile Send private message
Moved: Tue Feb 05, 2008 6:45 pm by superk From JCL to Interview Questions
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 2565
Location: italy

PostPosted: Tue Feb 05, 2008 6:56 pm    Post subject: Reply to: How to identify wrong data in millions of records?
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    Post subject:
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

Senior Member


Joined: 13 Jun 2007
Posts: 646
Location: Wisconsin

PostPosted: Tue Feb 05, 2008 7:32 pm    Post subject:
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    Post subject:
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: 964
Location: Virginia, USA

PostPosted: Tue Feb 05, 2008 8:54 pm    Post subject:
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: 497
Location: Richmond, Virginia

PostPosted: Tue Feb 05, 2008 9:22 pm    Post subject:
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: 260
Location: Spain

PostPosted: Tue Feb 05, 2008 9:56 pm    Post subject:
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions All times are GMT + 6 HoursGoto page 1, 2  Next
Page 1 of 2