Chapter 5 Database Options
169
Alphabetical list of options
This section lists options alphabetically
ALLOW_NULLS_BY_DEFAULT option
Controls whether new columns that are created without specifying either
NULL or NOT NULL are allowed to contain NULL values.
ON, OFF
ON
OFF for Open Client and JDBC connections
The ALLOW_NULLS_BY_DEFAULT option is included for Transact-SQL
compatibility.
$ For more information, see "Setting options for Transact-SQL
compatibility" on page 969 of the book ASA User’s Guide.
ANSI_BLANKS option
Controls behavior when character data is truncated at the client side.
ON, OFF
OFF
ON for Open Client and JDBC connections
The ANSI_BLANKS option has no effect unless the database was created
with the
-b command-line option. It forces a truncation error whenever a
value of data type CHAR(N) is read into a C char(M) variable for values of N
greater than or equal to M. With ANSI_BLANKS set to OFF, a truncation
error occurs only when at least one non-blank character is truncated.
For Embedded SQL, if ANSI_BLANKS is ON when you supply a value of
data type DT_STRING, you must set the sqllen field to the length of the
value, including space for the terminating null character. With
ANSI_BLANKS off, the length is determined solely by the position of the
null character.
The ANSI_BLANKS setting persists for the life of a connection. Changing it
after a connection has been established does not affect that connection.
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...