Chapter 5 Database Options
199
This option allows the database administrator to impose a minimum length
on all new passwords for greater security. Existing passwords are not
affected.
♦ Set the minimum length for new passwords to 6 bytes.
SET OPTION PUBLIC.MIN_PASSWORD_LENGTH = 6
NEAREST_CENTURY option
Controls the interpretation of two-digit years, in string-to-date conversions.
Integer between 0 and 100
50 for databases created with Version 6 or later.
0 for databases created with Version 5.5 or earlier.
This option controls the handling of two-digit years, when converting from
strings to dates or timestamps.
The NEAREST_CENTURY setting is a numeric value that acts as a rollover
point. Two digit years less than the value are converted to 20yy, while years
greater than or equal to the value are converted to 19yy.
The historical Adaptive Server Anywhere behavior is to add 1900 to the
year. Adaptive Server Enterprise behavior is to use the nearest century, so
any year where value yy is less than 50, the year is set to 20yy.
NON_KEYWORDS option
Turns off individual keywords, allowing their use as identifiers.
String
The empty string.
This option turns off individual keywords, or all keywords introduced since a
specific release of the product. This provides a way of ensuring that
applications created with older versions of the product are not broken by new
keywords. If you have an identifier in your database that is now a keyword,
you can either add double quotes around the identifier in all applications or
scripts, or turn off the keyword using the NON_KEYWORDS option.
In addition to specifying individual keywords, you can turn off all keywords
since a specified release, using one of the following special values in the list
of keywords:
Description
Example
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...