Setting environment variables
Any environment variables for SQL Connection can be defined in the opennet.srv file on Windows, the startnet script file on UNIX, and STARTNET.COM on OpenVMS.
Using opennet.srv to set environment variables (Windows)
To set an environment variable in opennet.srv, use the following syntax:
env_variable=setting
The opennet.srv file is also used to specify the command line that starts the service. The environment variable setting should precede that command line. For example:
VORTEX_HOST_LOGFILE=c:\vortex vtxnet2.exe -k67834 -p1660 log
For more information about opennet.srv, see Customizing the opennet.srv file.
Using startnet to set environment variables (UNIX and OpenVMS)
The startnet (UNIX) and STARTNET.COM (OpenVMS) files start SQL OpenNet Server. You can also set environment variables in these files. Environment variables set in these files will be set on the server. Use the following syntax:
- In startnet:
env_variable=setting; export env_variable
- In STARTNET.COM:
define env_variable setting
Environment variable settings should precede the line that starts the SQL OpenNet server. For example, on UNIX:
VORTEX_HOST_LOGFILE=usr2/vortex; export VORTEX_HOST_LOGFILE nohup vtxnetd -p1958 log & sleep 1