SQL Configuration Options

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.
distinctcachesize Specify cache size for distinct rows.
groupbycachesize Specify cache size for group by rows.
orderbycachesize Specify cache size for order by rows.
slotspercachenode Specify slots per cache node (cache).
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.
ignoreimporterrors Suppress import errors.
optimizeparameters Enable re-prepare of statements with parameter values