DSXchange

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

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

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

hi, i think you can change it to date by using date_from_string function and specify the Date format as yyddd. you have to convert decimal to string first which can be achieved by using DecimalToString(CollName,"suppress_zero"). It Looks Similar to this StringToDate(DecimalToString(Link_AU...

hi,
i think you can change it to date by using date_from_string function and specify the Date format as yyddd. you have to convert decimal to string first which can be achieved by using DecimalToString(CollName,"suppress_zero").

Hi Kiran, thanks for reply. i am developing a job to produce some test data for our project. i am using Collumn generator with runtime collumn propagation enabled and am getting the table definition from the Orchestrate schema file. i have developed the schema file and managed to generate some test ...

hi,
i am developing a parallel job to use Runtime Collumn Propagation using Shema file. i am struck at specifying the Description for the Collumns in schema file. Could any one please help me out on this issue. Thanks in advance.