Filter
Top Products
Index
504
creating in Sybase Central 139
disk space usage 143
displaying size 9
dropping 134
in system tables 133
introduction 132
listing 9
parallel creation 139
selecting an index type 150
insert conversion options 204
INSERT LOCATION statement 193
INSERT permissions 359
INSERT statement 151
about 190
and integrity 275
incremental 192
partial-width insert 198
performance 192
VALUES option 190
inserting
column width issues 208
from Adaptive Server Enterprise database 193
from older versions 204
from other databases 192
interactively 195
join index tables 195
overview 171
partial-width inserts 197
performance 221
primary and foreign key columns 196
See Also loading data 204
selected rows 191
INT connection parameter
about 73
integer data types
matching Adaptive Server Enterprise and Adaptive
Server IQ 218
Integrated connection parameter
about 73
integrated logins
default user 92
network aspects 92
ODBC configuration 69
operating systems 86
using 89
integrity
constraints 275, 276
overview 273
Interactive SQL
command delimiter 265
See Also DBISQL 101
window problems 96
interface libraries
connections 50
interfaces file
configuring 483
internal build number 17
INTO clause
using 247
IP address
about 485
IQ PAGE SIZE 111
IQ page size
determining 429
IQ PATH option
choosing a raw device 441
IQ Store
buffer cache size 427
content and structure 6
IQ UNIQUE constraint 278
IQ UNIQUE table option 122
IQ_QUERY_PLAN_ONLY option 457
iqgovern switch 34
restricting queries to improve performance 448
iqsmem switch 35, 436
iqwmem switch 34, 435
ISO_1 collation
about 332
Isolation level
ODBC configuration 67
isolation levels 302
ISOLATION_LEVEL option
Open Client 491
J
Java
connection parameters 76
memory requirements 35
use in Adaptive Server IQ 51, 113
jConnect