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

Posted in 2008

Habichtsberg, Reinhard — Mon, 25 Aug 2008 09:27:42 +0200 — source: Usenet: comp.databases.informix

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 > [mailto:informix-list-bounces@iiug.org]On Behalf Of Rajesh > Sent: Monday, August 25, 2008 7:47 AM > To: informix-list@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@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >