The Initialization utility
102
Set the transaction log filename (–t) The transaction log is a file where
the database server logs all changes, made by all users, no matter what
application system is being used. The transaction log plays a key role in
backup and recovery (see "The transaction log" on page 651 of the book ASA
User’s Guide), and in data replication. If the filename has no path, it is placed
in the same directory as the database file. If you run
dbinit
without specifying
-t or -n, a transaction log is created with the same filename as the database
file, but with extension
.log
.
Collating sequence (–z) The collation sequence is used for all string
comparisons in the database.
If you want to create a custom collation, use the Collation utility to create a
file containing the collation. Once you have modified the collation and
inserted it into the appropriate scripts, you use the Initialization utility to
create the database and specify the new collation.
You must change the collation label in the custom collation file. Otherwise,
the Initialization utility prevents the insertion of the new collation, since it
conflicts with an existing collation.
$ For more information on custom collating sequences, see "International
Languages and Character Sets" on page 287 of the book ASA User’s Guide.
For information on the Collation utility, see "The Collation utility" on
page 82.
In order to change the collation that an existing database uses, it is necessary
to unload the database, create a new database using the appropriate collation,
then reload the database. It may be necessary to translate the data as well.
If
-z is not specified, the default collation is used. Normal ASCII (binary)
ordering is used for the lower 128 characters, subject to the case sensitivity
setting (
-c). For the upper 128 characters (also called the extended
characters), any character that is an accented form of a letter in the lower 128
are sorted to the same position as the unaccented form. The determination of
whether or not an extended character is an accented letter is based upon code
page 850 (multilingual code page).
The following table identifies the available collating sequence labels.
Collation label Type Description
437LATIN1 OEM Code Page 437, Latin 1
437ESP OEM Code Page 437, Spanish
437SVE OEM Code Page 437, Swedish/Finnish
819CYR ANSI Code Page 819, Cyrillic
819DAN ANSI Code Page 819, Danish
819ELL ANSI Code Page 819, Greek
To Next Page
Loading...