Hi,

Informix on NT Server.

Created this batch file contining the following commands in it:

e:\informix\setenv
dbaccess dbname file.sql

When I try to execute the batch file, it executes the 'setenv' and then returns to the prompt without executing the 'dbaccess' part.

One way around this is to have the contents of the actual setenv.bat file copied to my batch file above. Which work ok. The set commands gets executed as well as the dbaccess command.

Any idea why the first option does not work.

I'm really no windows expert.

On Unix systems you need to execute an environment
file in the actual shell in order to set this environment
in the current shell, for example:

#!/bin/ksh
/home/informix/.profile
dbaccess stores7 select.sql

This would not work because '/home/informix/.profile' will be executed in a sub-shell, thus the current shell would not get
the actual environment. The right way would be:

#!/bin/ksh
. /home/informix/.profile
dbaccess stores7 select.sql

The leading point (". /home/informix/.profile") ensures that this
file is executed in the current shell, thus the environment
variables are available for the 'dbaccess' call.

I don't know if this is the same in NT. You might echo the
INFORMIXDIR and PATH environment variable after calling
your 'setenv' batch file in order to see if the environment
has been correctly set.

The reason the second line of your batch file doesn't work is because of the way you are calling the other batch file on the first line. Change your batch file to look like this:

call e:\informix\setenv
dbaccess dbname file.sql

The call statement will then execute the setenv batch file, then return to this file to execute the second line.

Simon.