Simplest way to identify a bad record ?

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
jazzer1
Participant
Posts: 37
Joined: Mon Mar 20, 2006 10:26 am

Simplest way to identify a bad record ?

Post by jazzer1 »

I'm reading a 10,000 record file. The validation stops in the middle of the run. What's the simplest method to identify which record is failing the validation ?

The trace has all this offset info but is there any way it could give you a record count instead of an object count ?

E.G. Record 9299 failed ? Something straight forward ?
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Please give some more information regarding this.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
jgibby
Participant
Posts: 42
Joined: Thu Dec 16, 2004 8:48 am

Post by jgibby »

Do you have the Restart attribute set in the input Type Tree? If so, then validation wouldn't fail and you could use the reject function to access any bad records.

I agree, more information is needed.
jazzer1
Participant
Posts: 37
Joined: Mon Mar 20, 2006 10:26 am

Post by jazzer1 »

I have a file that could have (0:s) records, and each record can occur (0:s). For example:
1mmmmmmmmmmmmmmm<CR><LF>
2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
Xnnnnnnnnnnnnn<CR><LF>
3xxxxxxxxx2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
T44444nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
2nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn<CR><LF>
9aaaaaaaaaaa<CR><LF>

Any field could fail on any record. If any field fails, I want to write the
entire record to an output. How do I set this up ?
Thanks.
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

Use the REJECT function to reject failed records and set RESTART in the type tree so that you process all records.
Post Reply