source file delimiter error

parag.s.27 · Post by **parag.s.27** » Tue Apr 11, 2006 3:12 am

Hi All,

I am having a funny problem in reading a source file in my DS job.

Actually the source file is '~' delimited. In the file last column is having null in all the records, not even spaces. Now datastage is not reading that column and throwing "Read File Delimited" error. can u please suggest some thing. I tried everything from opening it in XL, to saving it as CSV, but it did'nt work.

ArndW · Post by **ArndW** » Tue Apr 11, 2006 3:14 am

How about using the attribute for "incomplete column"?

parag.s.27 · Post by **parag.s.27** » Tue Apr 11, 2006 3:28 am

ArndW wrote:How about using the attribute for "incomplete column"? ...

Hi ArndW,

Can you please tell me in an elaborated manner, sorry but i did'nt understand.

thanks

ArndW · Post by **ArndW** » Tue Apr 11, 2006 3:43 am

Parag,

go into your designer sequential file stage in the columns tab, and scroll to the right to see the incomplete column column. Also, try using the HELP and search for incomplete.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 11, 2006 3:44 am

In the Columns grid scroll right and you will find rules that can be set on a per-column basis, including incomplete and "contains terminator" rules. Set the incomplete rule to Replace. Click on Help while there to learn more about the precedence requirements of these rules.

parag.s.27 · Post by **parag.s.27** » Tue Apr 11, 2006 4:47 am

Hi,

I tried with column wise settings by checking Incomplete column and contains terminator options, but still it throws an error saying, "Column can not retain incomplete data as it is a delimited file"

ArndW · Post by **ArndW** » Tue Apr 11, 2006 4:52 am

Both Ray and I suggested you read the HELP regarding how to set the incomplete columns. From the question in your post it would seem you decided not to follow that advice! Only columns starting at the end of the line and going backwards can be set to incomplete.