MLoad Custom Delimiter Problem

[mgarg24]

Hi,

we have source as sequential file with ^| as delimiter and Target is teradata loaded using Mload stage.

I am trying to load the data with data format "VARTEXT" and Delimiter as ^|. while loading received error message as "UTY4016 Data item too large for field END_DT in vartext record number 1"

Record is properly delimited and i am able to view it with datastage. Also If I use | as delimiter, job works fine.

Is it like we can't use ^| as delimiter in Mload stage. Please throw some light on it.

Thanks,
Manish

[ray.wurlod]

Replace Field Delimiter property with Field Delimiter String property. The former accepts only a single character; the latter accepts an arbitrary string.