View previous topic :: View next topic
|
Author |
Message |
prasadk432
New User
Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon
|
|
|
|
This is an interview question from Perot Systems? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
what do the idiots consider wrong data ??
the number of records is irrelevant |
|
Back to top |
|
|
prasadk432
New User
Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon
|
|
|
|
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 |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
are You perchance referring to me as an idiot ?? |
|
Back to top |
|
|
prasadk432
New User
Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon
|
|
|
|
No..No... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
This entire thread should be eliminated. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
prasadk432
New User
Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
|
prasadk432
New User
Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon
|
|
|
|
what logic we have to code if we use cobol pgm since file contains so many columns. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
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 |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
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 |
|
|
Douglas Wilder
Active User
Joined: 28 Nov 2006 Posts: 305 Location: Deerfield IL
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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
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 |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
|
|
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 |
|
|
Rahul_kumar Warnings : 2 New User
Joined: 24 Jun 2006 Posts: 50
|
|
|
|
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 |
|
|
Douglas Wilder
Active User
Joined: 28 Nov 2006 Posts: 305 Location: Deerfield IL
|
|
|
|
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 |
|
|
|