Error while loading data from a file into a table

Posted in 2008

Rajesh — Sun, 24 Aug 2008 22:46:54 -0700 (PDT) — source: Usenet: comp.databases.informix

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..

↪ replying to Rajesh

Superboer — Mon, 25 Aug 2008 00:12:34 -0700 (PDT) — source: Usenet: comp.databases.informix

isql is not installed??? you could try dbaccess instead. Superboer On 25 aug, 07:46, Rajesh <grajesh...@gmail.com> wrote: > 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..

↪ replying to Rajesh

Obnoxio The Clown — Mon, 25 Aug 2008 10:03:27 +0100 (BST) — source: Usenet: comp.databases.informix

Rajesh said: > 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.. dbaccess? If you have ISQL, then it's probably not in your PATH. -- Bye now, Obnoxio http://obotheclown.blogspot.com/