Options are defined using keys or properties. Every key has a name and a value, delimited by an equals sign (=). The key name appears to the left of the equals sign. Key names are not case-sensitive. Unless otherwise noted, values are not case-sensitive.
| Key | Value Description |
|---|---|
| autocommit | Enable autocommit mode. |
| snapshotmode | Specify snapshot start mode. |
| dateformat | Specify default display format for date. |
| timeformat | Specify default display format for time. |
| wildall | Change default "wild all" character. |
| wildone | Change default "wild one" charcater. |
| sortcostfactor | Specify sort cost factor (query). |
| debugmode | Specify debug mode (query). |
| optthreshold | Specify optimizer threshold (query). |
| defaulttransaction | Specify default transaction type. |
| defaultopenmode | Specify default database open mode. |
| optimizeparameters | Enable re-prepare of statements with parameter values |