RE: load problem

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-20-2008, 07:03 AM

Bill Dare

Posts: n/a

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

« RE: Problem with 7.31 UC2 on Solaris 8 | informix begginer on xp »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 08:10 PM.

SEO

RE: load problem