Alphabetical list of options
188
When enabled (set to ON), all occurrences of the keyword FLOAT are
interpreted as equivalent to the keyword DOUBLE within SQL statements.
By default, Adaptive Server Anywhere FLOAT values are interpreted by
Adaptive Server Enterprise as REAL values. Since Adaptive Server
Enterprise treats its own FLOAT values as DOUBLE, enabling this option
makes Adaptive Server Anywhere treat FLOAT values in the same way
Enterprise treats FLOAT values.
REAL values are four bytes; DOUBLE values are eight bytes. According to
the ANSI SQL/92 specification, FLOAT can be interpreted based on the
platform. It is up to the database to decide what size the value is, so long as it
can handle the necessary precision. Adaptive Server Enterprise and Adaptive
Server Anywhere exhibit different default behavior.
The FLOAT_AS_DOUBLE option takes effect only when no precision is
specified. For example, the following statement is not affected by the option
setting:
create table t1(
c1 float(5)
)
The following statement is affected by the option setting:
create table t2(
c1 float)
// affected by option setting
GLOBAL_DATABASE_ID option
For use in generating unique primary keys in a replication environment.
Controls the beginning of the range of values for columns created with
DEFAULT GLOBAL AUTOINCREMENT.
Integer
0
PUBLIC setting only. Takes effect when the database is next started.
"CREATE TABLE statement" on page 466
"Database-level properties" on page 1101
"Ensuring unique primary keys" on page 427 of the book Replication and
Synchronization Guide
If you create a column with DEFAULT GLOBAL AUTOINCREMENT, its
value is incremented starting from the value of GLOBAL_DATABASE_ID.
Function
Allowed values
Default
Scope
See also
Description
To Next Page
Loading...