Chapter 5 Database Options
189
A setting of 0 (the default) indicates that GLOBAL DEFAULT
AUTOINCREMENT is disabled, and NULL is generated as a default.
You can find the value of the option in the current database using the
following statement:
select db_property( ’GlobalDBId’ )
You need to shut down and restart the database when you change this option
for it to take effect.
This feature is of particular use in replication environments to ensure unique
primary keys. For more information, see "Ensuring unique primary keys" on
page 427 of the book Replication and Synchronization Guide.
HEADINGS option [ISQL]
Controls whether headings will be displayed for the results of a SELECT
statement.
ON, OFF
ON
Set this option according to your preference.
INPUT_FORMAT option [ISQL]
Sets the default data format expected by the INPUT statement.
String. See below.
ASCII
Certain file formats contain information about column names and types.
Using this information, the INPUT statement will create the database table if
it does not already exist. This is a very easy way to load data into the
database. The formats that have enough information to create the table are:
DBASEII, DBASEIII, FOXPRO, and LOTUS.
Allowable input formats are:
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...