load problem

I am having a problem with loading a file to an informix database The file I am trying to load (dt2) is of the format:- 9845,593680,RAMANATHAN 3471,592812,QUIST-THERON And I am trying to load it into a table with the following fields:- patient Integer refid Integer consultant Char(30) If I then run the following commands:- load from "/home/cobdeng/sql/dt2" delimiter "," insert into diet_cons; unload to "/home/cobdeng/sql/dt2u" delimiter "," select * fromdiet_cons; select * from diet_cons; The Select Statement tells me there are two rows retrieved, but nothing displays on screen If I cat the file dt2u I get the following:- ,845,593680,RAMANATHAN ,471,592812,QUIST-THERON If I load values manually into the table, there is no problem Can somebody help me with where I am going wrong please

On 10 Nov 2004 05:22:20 -0800, gary.cobden@nhs.net (Gary Cobden) wrote: >I am having a problem with loading a file to an informix database > >The file I am trying to load (dt2) is of the format:- >9845,593680,RAMANATHAN >3471,592812,QUIST-THERON > >And I am trying to load it into a table with the following fields:- >patient Integer >refid Integer >consultant Char(30) > >If I then run the following commands:- >load from "/home/cobdeng/sql/dt2" delimiter "," insert into diet_cons>; >unload to "/home/cobdeng/sql/dt2u" delimiter "," select * from>diet_cons; >select * from diet_cons;> >The Select Statement tells me there are two rows retrieved, but >nothing displays on screen > >If I cat the file dt2u I get the following:- >,845,593680,RAMANATHAN >,471,592812,QUIST-THERON > >If I load values manually into the table, there is no problem > >Can somebody help me with where I am going wrong please Sounds like there are some strange control characters in the unload file. Where did the unload file come from? JWC