Index
126 Adaptive Server Enterprise
C
C shell 29
case sensitivity
in SQL xv
changing
character sets 83, 97
languages 97
sort order 97
character devices
improving I/O performance on 38, 39
character sets 89
accented letters in 13
changing 83, 84, 97
client selection of 84
code conversions and 89
configuring 99
converting between 89
databases and 90
default 83
in a heterogeneous environment 89
sort orders and 90
U.S. English 13
charsets directory 91, 94
about the 95
Chinese character sets 86
client interfaces files
difference between client and server versions 52
heterogeneous 53
homogeneous 53
clients
Adaptive Server communications with 49
applications and locales.dat file 96
conversion between, and server 89
default character set 84
DSQUERY and 60
file servers 61
code conversion
between character sets 89
collating sequences. See sort orders 90
comma (,)
in SQL statements xiv
commands
disk init 10
iostat 44
maxfiles 34
maxfiles_lim 34
netstat 43, 44
netstat -v 44
no -a 44
ps 44, 45
sar 43
setenv 30
setperm_all 34
time 44, 45
vmstat 43, 44
common.loc file 95
communications between client and Adaptive Server
49
configurations
default 47, 48
configurations, default 48
configuring
Backup Server 94, 97
character sets 99
conventions
See also syntax
Transact-SQL syntax xiii
used in the Reference Manual xiii
conventions in this book xv
conversions, Unicode character 85
converting between character sets 89
create database command, system tables created by 5
creating
interfaces files 51, 58
interfaces files automatically 50
interfaces files for beginners 58
master interfaces files with dscp utility 58
master interfaces files with dsedit 58
master interfaces files with text editor 58
.cshrc file 29
curly braces ({}) in SQL statements xiv
customizing installations 47
Cyrillic character sets 86
D
data translation 81
database devices
master 5
preparing raw partitions for 10
sybsyntax 122