Error while loading data from a file into a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rajesh - 25 Aug 2008 06:46 GMT

Hi Guys:

I am trying to load the data from a file into a table in a database by
using the below command.

isql metdb >> /tmp/TEMPDIR_REM/LOAD.LOG 2>&1 <<!
load from "/tmp/TEMPDIR_REM/$LOADTABLE.txt" insert into $LOADTABLE
!

But while running this in a script it shows..
UX:sh (loadfile.sh): ERROR: isql: not found

Plz suggest me an alternative..

Reply to this Message

Superboer - 25 Aug 2008 08:12 GMT

isql is not installed???

you could try dbaccess instead.

Superboer

> Hi Guys:
>
[quoted text clipped - 9 lines]
>
> Plz suggest me an alternative..

Reply to this Message

Habichtsberg, Reinhard - 25 Aug 2008 08:27 GMT

Set the informix environment like PATH, INFORMIXDIR, INFORMIXSERVER etc.
before calling isql.
BTW: I would prefer dbaccess.

> -----Original Message-----
> From: informix-list-bounces@iiug.org
[quoted text clipped - 20 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message

Obnoxio The Clown - 25 Aug 2008 10:03 GMT

Rajesh said:

> Hi Guys:
>
[quoted text clipped - 9 lines]
>
> Plz suggest me an alternative..

dbaccess?

If you have ISQL, then it's probably not in your PATH.

Signature

Bye now,
Obnoxio

http://obotheclown.blogspot.com/

Reply to this Message