Is this repeatable?
There's no apparent pattern - most, but not all, of the values end in "8" or "9".
Are you sure there are no non-printing characters involved?
Validation Error for Integer Datatype
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
hi Ray,
Thanks for the reply. There are no printing Characters. i am wondering if the leading Zero's or leading byte character is the issue.
And a small Update on my piece of work. I ran the job with 300 Records
" 000100" to " 000299"
Interestingly it doesn't like the ones with 8 or 9 in any part of the string.
it drops all records with 8 and 9 in them.
Thanks for the reply. There are no printing Characters. i am wondering if the leading Zero's or leading byte character is the issue.
And a small Update on my piece of work. I ran the job with 300 Records
" 000100" to " 000299"
Interestingly it doesn't like the ones with 8 or 9 in any part of the string.
it drops all records with 8 and 9 in them.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,ray.wurlod wrote:Almost an IsValid("octal", TheNumber) test? Weird. What precise version of DataStage? I will try to reproduce this on version 8.1 sometime soon. ...
I am using Datastage 8.1. I didnt understand why it had problem with just those values. it worked fine once i trim off the leading space and zeros.
Thanks for your help.