Index

backups

291, 383

 

 

troubleshooting

93

 

 

 

data definition

300

 

 

using data source

59

 

 

 

in Adaptive Server IQ

290

 

constraints

 

 

 

 

 

 

 

insertions, deletions, and queries 299

effect on performance

274

 

 

read and write

292

 

 

CONTINUE_AFTER_RAISERROR option

configuration files

 

 

 

Open Client

491

 

 

 

 

using 29

 

 

 

 

control statements

 

 

 

 

 

 

configuring

 

 

 

 

 

list 239

 

 

 

 

 

 

 

ODBC data sources

67

 

conversion options

 

 

 

 

 

CONN connection parameter

 

DATE

210

 

 

 

 

 

 

about

73

 

 

 

 

DATE format specification

210

connect

 

 

 

 

 

DATETIME

212, 213

 

 

 

permission

357

 

 

substitution for zero-length cells

210

connecting

 

 

 

 

 

CONVERSION_ERROR database option 220

character sets

338

 

 

conversions

 

 

 

 

 

 

 

connection name

 

 

 

between Adaptive Server Enterprise and Adaptive

ODBC configuration

70

 

Server IQ

 

217

 

 

 

connection parameters

 

 

errors on import

 

220

 

 

 

about

73

 

 

 

 

insert options

 

204

 

 

 

case sensitivity

75

 

 

on insert

202

 

 

 

 

 

conflicts

76

 

 

 

COUNT DISTINCT

 

 

 

 

data sources

 

63

 

 

impact on index choice

141

 

 

default

61

 

 

 

COUNT function

 

145

 

 

 

embedded databases

76

 

CPU usage

 

 

 

 

 

 

 

in connection strings

52

 

monitoring

477, 479

 

 

 

location of

79

 

 

CREATE DATABASE statement

108

priority

75

 

 

 

CREATE DBSPACE statement

114, 445

table of

73

 

 

 

CREATE INDEX statement

138

 

connection strings

 

 

 

CREATE JOIN INDEX statement

162

character sets

338

 

 

CREATE PROCEDURE statement

 

representing

 

52

 

 

examples

231

 

 

 

 

 

ConnectionName connection parameter

parameters

244

 

 

 

 

about

73

 

 

 

 

CREATE statement

 

 

 

 

connections

 

 

 

 

automatic commit

289

 

 

 

embedded database

57

 

concurrency rules

300

 

 

 

establishing

52

 

 

CREATE TABLE statement

 

 

examples

53

 

 

 

and command files

101

 

 

how the server establishes

77

example

119

 

 

 

 

 

Interactive SQL 54, 85

 

CT-library

 

 

 

 

 

 

 

 

JDBC

51

 

 

 

 

about

481

 

 

 

 

 

 

limiting concurrent

34

 

cursors

 

 

 

 

 

 

 

 

limiting statements used by

450

and LOOP statement 253

 

 

local database

54

 

 

connection limit

 

372

 

 

 

over a network

60

 

 

hold

297, 313

 

 

 

 

 

overview

50

 

 

 

in procedures

 

253

 

 

 

to database on foreign host

55

in transactions

 

311

 

 

 

498

Page 518
Image 518
Sybase 12.4.2 manual 498, Datetime