I have a PX job which creates sequential file. I am using this file in server job as a source and doing some look up on hash file. Look up is failing because the source sequential file has padded with some control characters because its an Char(10) field and actual value is less than 10 character. Example is given below. Second column in the example is having issue.
"33","INVEST^@^@^@^@","394","21","9","1960-01-01 00:00:33"
Reason we are doing this is beause we just upgraded to EE and some of the reusable jobs are still in server so we have to use those jobs. but the source file will be created by Parallel.
How do we overcome this issue ? I am sure someone might have alrady faced this issue. Please advise.