RE: load problem
I just tried that on 9.40.FC3 and no problems. Check your load file for
possibly some control characters. When you unloaded the data it showed up
with the first field as null(comma in the first position of each line). I'd
guess that something is wrong with that load file.
Regards,
Bill
devldb:[/usr/informix]> echo 'load from /tmp/dt2 delimiter "," insert into
diet_cons' | dbaccess test
Database selected.
2 row(s) loaded.
Database closed.
devldb:[/usr/informix]> echo 'select * from diet_cons' | dbaccess test
Database selected.
patient refid consultant
9845 593680 RAMANATHAN
3471 592812 QUIST-THERON
2 row(s) retrieved.
Database closed.
devldb:[/usr/informix]> cat /tmp/dt2
9845,593680,RAMANATHAN
3471,592812,QUIST-THERON
devldb:[/usr/informix]>
devldb:[/usr/informix]> echo 'unload to /tmp/dt2u delimiter "," select *
from diet_cons' | dbaccess test
Database selected.
2 row(s) unloaded.
Database closed.
devldb:[/usr/informix]> cat /tmp/dt2u
9845,593680,RAMANATHAN,
3471,592812,QUIST-THERON,
devldb:[/usr/informix]>
> -----Original Message-----
> From: gary.cobden@nhs.net [SMTP:gary.cobden@nhs.net]
> Sent: Wednesday, November 10, 2004 8:22 AM
> To: informix-list@iiug.org
> Subject: 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 * 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
sending to informix-list