Sybase Adaptive Server Anywhere - General Database Options

Chapter 5 Database Options
161
General database options
This section lists all database options.
OPTION VALUES DEFAULT
"AUDITING option" on page 172 ON, OFF OFF
"BACKGROUND_PRIORITY option" on
page 174
ON, OFF OFF
"BLOCKING option" on page 175 ON, OFF ON
"CHECKPOINT_TIME option" on
page 177
Number of
minutes
60
"CIS_ROWSET_SIZE option" on page 177 Integer 50
"COOPERATIVE_COMMITS option" on
page 180
ON, OFF ON
"COOPERATIVE_COMMIT_TIMEOUT
option" on page 181
Integer 250
"DATE_FORMAT option" on page 181 String ’YYYY-MM-DD’
"DATE_ORDER option" on page 183 ’YMD’, ’DMY’,
’MDY’
’YM D’
"DEFAULT_TIMESTAMP_INCREMENT
option" on page 183
Integer 1
"DELAYED_COMMITS option" on
page 184
ON, OFF OFF
"DELAYED_COMMIT_TIMEOUT
option" on page 184
Integer 500
"EXTENDED_JOIN_SYNTAX option" on
page 186
ON/OFF ON
"GLOBAL_DATABASE_ID option" on
page 188
Integer 0
"ISOLATION_LEVEL option" on page 194 0, 1, 2, 3 0
"JAVA_HEAP_SIZE option" on page 194 Number of bytes 1000000
"JAVA_NAMESPACE_SIZE option" on
page 195
Number of bytes 4000000
"LOGIN_MODE option" on page 195 STANDARD,
MIXED,
INTEGRATED
STANDARD
"LOGIN_PROCEDURE option" on
page 196
String sp_login_environment