DSXchange

Hi ,
I am reading a pipe delimited file which contain ID and description cols.

ID is char 4
description varchar2(30)

while reading a file it is erroring out as ID delimiter is missing.

If I changed to char to varchar , it is reading well.

Can any one help me why I am getting this issue.

Because you have bad data - data that does not conform to your specified metadata. Either get the data changed so that they conform to the metadata or change the metadata so that they conform to the data.