GENESIS_INITSQL
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The GENESIS_INITSQL environment variable specifies the SQL options file.
Value
The path and filename of your SQL options file.
Discussion
The GENESIS_INITSQL environment variable enables you to specify a file that contains predefined SQL statements. This includes all options that can be set with the SET OPTION command. The SQL statements in this file are executed each time a connection is made to the driver.
Setting location
The environment. For client/server configurations, GENESIS_INITSQL must be set on the server. On Windows, GENESIS_INITSQL must be set in opennet.srv.
Used by
xfODBC
See also
- Creating a file for query processing options
- Appendix B: SQL Support for information on the SET OPTION command
Examples
On Windows,
set GENESIS_INITSQL=c:\synergyde\connect\synodbc\options.sql