Sybase Adaptive Server Anywhere - Page 101

Chapter 4 Database Administration Utilities
83
Switch Description
–c "keyword=value; ..." Supply database connection parameters
–d mapping-file Convert the definition file to INSERT statements
with collation mapping placed in mapping-file
–e
Include empty mappings
–o filename Log output messages to a file
–q
Quiet mode — do not print messages
–x
Use hex for extended characters (7F-FF)
–y
Replace the file without confirmation
–z col-seq Specify a collating sequence label
$ For more information about the command-line switches, see "Collation
utility options" on page 83.
Collation utility options
Connection parameters (–c) For a description of the connection
parameters, see "Connection parameters" on page 64 of the book ASA User’s
Guide. If the connection parameters are not specified, connection parameters
from the SQLCONNECT environment variable are used, if set.
For example, the following command extracts a collation file from the
asademo database that is running on the sample_server server, and connects
as user ID
DBA with password SQL:
dbcollat -c "eng=sample_server;dbn=asademo;uid=DBA;pwd=SQL" c:\sample\col
Convert the definition file to an INSERT statement (–d) When a
database is created, the collation is inserted into the SYS.SYSCOLLATION
system table. This collation is selected from the set of collations specified in
the
scripts subdirectory of your Adaptive Server Anywhere installation
directory. Custom collations are added to the
custom.sql script. The -d
switch converts the collation file that you edited into an INSERT statement
that can be copied into
custom.sql .
From the
dbcollat command-line utility you can use this option as follows:
dbcollat -d coll-defn-file cust-map-file custom-file
The coll-defn-file is read and parsed as a collation definition. Output is
written to cust-map-file and custom-file. The cust-map-file contents should
be added to
custmap.sql , and custom-file contents to custom.sql .