Index

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

126

Adaptive Server Enterprise

Page 142
Image 142
Sybase DC35823-01-1500-04 manual Index, 126