Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 518 / 536

Index
498
backups 291, 383
data definition 300
in Adaptive Server IQ 290
insertions, deletions, and queries 299
read and write 292
configuration files
using 29
configuring
ODBC data sources 67
CONN connection parameter
about 73
connect
permission 357
connecting
character sets 338
connection name
ODBC configuration 70
connection parameters
about 73
case sensitivity
75
conflicts 76
data sources
63
default 61
embedded databases
76
in connection strings 52
location of 79
priority 75
table
of 73
connection strings
character sets 338
representing 52
ConnectionName connection parameter
about 73
connections
embedded database 57
establishing 52
examples 53
how the server establishes
77
Interactive SQL 54, 85
JDBC 51
limiting concurrent
34
limiting statements used by 450
local database 54
over a network 60
overview 50
to database on foreign host
55
troubleshooting 93
using data source
59
constraints
effect on performance 274
CONTINUE_AFTER_RAISERROR option
Open Client 491
control statements
list 239
conversion options
DATE 210
DATE format specification
210
DATETIME 212, 213
substitution for zero-length cells 210
CONVERSION_ERROR database option 220
conversions
between Adaptive Server Enterprise and Adaptive
Server IQ 217
errors on import 220
insert options 204
on insert 202
COUNT DISTINCT
impact on index choice 141
COUNT function 145
CPU usage
monitoring 477, 479
CREATE DATABASE statement 108
CREATE DBSPACE statement 114, 445
CREATE INDEX statement 138
CREATE JOIN INDEX statement 162
CREATE PROCEDURE statement
examples 231
parameters 244
CREATE statement
automatic commit 289
concurrency rules 300
CREATE TABLE statement
and command files 101
example 119
CT-library
about 481
cursors
and LOOP statement 253
connection limit 372
hold 297, 313
in procedures 253
in transactions 311