This feature is available through two new command-line options and the initialize_application statement.
-x – this option allows for external configuration. The application needs to initialize an application with a name. The Open Client/Server configuration file will have a section with this application name. Under this section, place all properties that need to be set for this application. The -x option is useful only when used with initialize_application. If initializing is not done, and the -x option is used, the default section of the configuration file will be accessed.
-e – this option allows us to configure by SERVER NAME. No call to initialize_application is required. The server name will be used as a key to look up in the configuration file for properties to be set the section defined by the server name. This will allow users to associate connection names with specific connection properties.
If INITIALIZE_APPLICATION is
not the first Embedded SQL statement to be executed, external configuration
properties will not be set. If it is the first Embedded SQL statement
to be executed, then the external configuration options will be
used for initialization.
