Re: Error while loading data from a file into a table

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

> -----Original Message-----
> From: informix-list-bounces-at-iiug.org
> [mailto:informix-list-bounces-at-iiug.org]On Behalf Of Rajesh
> Sent: Monday, August 25, 2008 7:47 AM
> To: informix-list-at-iiug.org
> Subject: Error while loading data from a file into a table
>
>
> 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..
> _______________________________________________
> Informix-list mailing list
> Informix-list-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>