Chapter 4 Database Administration Utilities
99
$ For full information on creating a database in Sybase Central, see
"Creating a database" on page 115 of the book ASA User’s Guide.
The dbinit command-line utility
dbinit [
switches
]
new-database-file
Switch Description
–b
Blank padding of strings for comparisons and fetching
–c
Case sensitivity for all string comparisons
–e
Encrypt the database
–i
Do not install Sybase jConnect support
–j
Do not install Sybase runtime Java classes
–k
Omit Watcom SQL compatibility views SYS.SYSCOLUMNS
and SYS.SYSINDEXES
–l
List the available collating sequences
–m file-name Use a transaction log mirror (default is no mirror)
–n
No transaction log
–o filename Log output messages to a file
–p page-size Set page size
–q
Quiet mode—do not print messages
–t log-name Transaction log filename (default is the database name with .
log
extension)
–z col-seq Collation sequence used for comparisons
For example, the database
test.db
can be created with 1024 byte pages as
follows:
dbinit -p 1024 test.db
$ For more information about the command-line switches, see
"Initialization utility options" on page 99.
Initialization utility options
Blank padding (–b) Ignore trailing blanks for comparison purposes and
pad strings that are fetched into character arrays. For example, the two
strings
Syntax
Description
To Next Page
Loading...