When connecting to Sybase IQ using Open Client or when using the INSERT...LOCATION syntax, you can set various Open Client configuration parameters in an Open Client runtime configuration (.cfg) file. For example, you can change the maximum default number of connections, which is controlled by the value of the CS_MAX_CONNECT option.
The application name for INSERT...LOCATION is Sybase IQ
.
(The space between the words is required.) This application name
is set at the Open Client connection level, not at the Open Client
context level. For details about using an Open Client runtime configuration
file and the options available, see the Open Client Client-Library
C Reference Manual.
To have the .cfg take effect, stop and restart the Sybase IQ server. You may also specify certain configuration parameters in the INSERT...LOCATION command line. Parameters set in INSERT...LOCATION are superseded by parameters set in the configuration file.