Problem with seq file in server jobs

sreedhards · Post by **sreedhards** » Sat Mar 30, 2013 12:30 pm

Hi,

I'm using sequential file in my datastage server job,in the format tab,i'm unable to give white space as record delimiter,since it is not accepting any spaces..

Please help me out..

ray.wurlod · Post by **ray.wurlod** » Sat Mar 30, 2013 1:38 pm

Use a three-digit decimal ASCII code, namely 032.

chulett · Post by **chulett** » Sat Mar 30, 2013 3:17 pm

... if you are certain that it is a space and not something more typical like a TAB.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 30, 2013 9:41 pm

Either of those would be very unusual as a record delimiter! Are you sure you aren't confusing the properties Record Delimiter and Field Delimiter?