Configuring Open Client

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.