Sybase Adaptive Server Anywhere - Page 180

General database options
162
OPTION VALUES DEFAULT
"MAX_CURSOR_COUNT option" on
page 196
Integer 50
"MAX_HASH_SIZE option" on page 197 Integer 10
"MAX_WORK_TABLE_HASH_SIZE
option" on page 197
Integer 20
"MAX_STATEMENT_COUNT option" on
page 198
Integer 50
"MIN_PASSWORD_LENGTH option" on
page 198
Integer 0
"OPTIMIZATION_GOAL option" on
page 201
first-row or all-
rows
first-row
"PRECISION option" on page 205 Number of
digits
30
"PREFETCH option" on page 205 ON, OFF ON
"RECOVERY_TIME option" on page 208 Number of
minutes
2
"RETURN_JAVA_AS_STRING option" on
page 209
ON, OFF OFF
"ROW_COUNTS option" on page 208 ON, OFF OFF
"SCALE option" on page 210 Number of
digits
6
"TIME_FORMAT option" on page 213 String ’HH:NN:SS.SSS’
"TIMESTAMP_FORMAT option" on
page 213
String ’YYYY-MM-DD
HH:NN:SS.SSS’
"TRUNCATE_DATE_VALUES option" on
page 214
ON, OFF ON (databases created
with version 7 software)
OFF (older databases)
"TRUNCATE_TIMESTAMP_VALUES
option" on page 215
ON, OFF OFF
"TRUNCATE_WITH_AUTO_COMMIT
option" on page 215
ON, OFF OFF
"WAIT_FOR_COMMIT option" on
page 217
ON, OFF OFF