Filter
Top Products
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