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

isql is not installed???

you could try dbaccess instead.

Superboer

On 25 aug, 07:46, Rajesh 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..

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/