ODBC server command line switches
These are the command line switches that can be used with the ODBC server kiodbc.
| Flag | Description | Notes |
|---|---|---|
| -a | Disable keepalive packets | |
| -c | Dump contents of sources.txt | Output format is of the form SECTION|keyname|value| |
| -C codepage | Convert data to the specified codepage. | Now longer required now that the KCML 7 ODBC driver supports Unicode |
| -e max_exec_time | Set query execution timeout value in seconds | |
| -f /path/to/sources.txt | Set the location of sources.txt if not in the same directory as kiodbc. | Deprecated when kiodbc is being launched by the Connection Manager as kconf.xml will be used instead |
| -q nice_increment | Reduce scheduling priority. | Unix only. Lowers the priority at which kiodbc runs at to minimize the load of expensive queries on the server |
| -S | List connected users since last reboot | |
| -t max_idle_time | Set idle timeout value in seconds | |
| -U codepage | Convert UTF-8 data to the specified codepage. | No longer required now that the KCML 7 ODBC driver supports Unicode |
| -v | Prints the version string | |
| -w /path/to/temp/dir | Set the location of the workspace directory. | Deprecated when the Connection Manager is being used as $WORKSPACE will be used. |
| -x row_count | Wait after fetching the specified number of rows from a KDB/KISAM database. The period of time to wait is specified by the -z switch | Has no effect on Oracle/PostgreSQL databases. |
| -y SYSTEMID | SYSTEMID value. | Deprecated. It is recommended to use the Connection Manager when $SYSTEMID is in effect. |
| -z delay | Set the wait delay, in milli-seconds, after fetching a large number of rows. Number of rows is set by the -x switch. | Has no effect on Oracle/PostgreSQL databases. |
| -8 | Use new permissions file structure introduced with Autoline Rev8. | Alternatively set $LONGUSERNAMES to TRUE in the <service's> environment when kiodbc is being launched by the Connection Manager |