Sybase 12.4.2 manual 504, See Also Dbisql

Models: 12.4.2

1 536
Download 536 pages 20.34 Kb
Page 524
Image 524

Index

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

504

Page 524
Image 524
Sybase 12.4.2 manual 504, See Also Dbisql