Hi,

I'm starting a new job and have no informix experience whatsoever. I'm trying to map common things I'd do in postgres to informix, and I'm not having much luck.

The #1 thing I'm having a problem with is getting to be able to pipe in SQL commands contained in .sql files from the command line.

If I do:

$ dbaccess database_name testfile.sql

I get back:

951: Incorrect password or user username@mymachine-dat is not known on the database server.

Is there some kind of configuration file I could use to fix this? It seems to be getting a network based username. I've talked to various people at my company, and no one seems to know how to get this working (or sees the utility in being able to execute sql files at the command line). Any help is much appreciated. I'm on my own here.

Thanks in advance.

Moses

1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine, they use your logged user to connect, if they don't exists, you got this error 951)
3) dbaccess have some limitations with conection authentication...
4) Have a several ways to solve this..
a) configure a .netrc (client side)
b) configure a hosts.equiv (server side)
c) use the commando "connect" in your script and don't specify the database on the command: dbaccess - yourscript.sql
check the manual for more information: CONNECT

Thanks for your solution. It identified that I left out one important piece of information