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

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