Validation Error for Integer Datatype

ray.wurlod · Post by **ray.wurlod** » Tue Oct 06, 2009 10:30 pm

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?

mrajesh99 · Post by **mrajesh99** » Tue Oct 06, 2009 11:04 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 06, 2009 11:36 pm

Almost an IsValid("octal", TheNumber) test? Weird. What precise version of DataStage? I will try to reproduce this on version 8.1 sometime soon.

mrajesh99 · Post by **mrajesh99** » Tue Oct 06, 2009 11:36 pm

I have found out the issue. it works once i trim leading Zeros and space.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 06, 2009 11:38 pm

Leading zeroes should not invalidate an integer test. One leading space (sign) ought not to do so either, in my opinion.

mrajesh99 · Post by **mrajesh99** » Tue Oct 06, 2009 11:41 pm

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. ...

Hi Ray,
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.