Problem in running sql script

[lrout]

Hi,

I am trying to run a sql script for a database in linux which is owned by a user other than ingres.

Issuing this command from the user -

sql insurancesource /home/osic/Ingres/ingres_script/sourceTables.sql /tmp/Ingres_log.log

Error :

E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GC0136 -- User provided a server class as part
of the database name (dbname/class), but that server class is not known
to the Name Server..

E_LQ0001 Failed to connect to DBMS session.


Thanks in advance.

Lipika

[jackhigh]

I don't know Linux, only UNIX, so this might be complete nonsense, but, don't you need the redirect signs to read commands in, and output results, to a file.

sql insurancesource < /home/osic/Ingres/ingres_script/sourceTables.sql > /tmp/Ingres_log.log

[lrout]

Thanks a lot.It worked...