Index_I

I

IBM DB2 UDB 8.1. See DB2 UDB 8.1

IBM IMS (Information Management System), 12, 22

IBM SQL/DS, 23

IBM standards, 529

Idempotent Law, 274

identification. See authentication

identifier, SELECT statement, 239

identity

Boolean algebra, 778–779

OOP, 602

set theory, 785–786

identity clause, table constraints, 100–101

identity column

described, 74

Oracle 9i equivalent (sequences), 100

tables, modifying

DB2 UDB 8.1, 152, 190

MS SQL Server 2000, 190–192

image functions, MS SQL Server 2000, listed, 720

images, storing. See binary strings

implicit transactions, 218

IMS (Information Management System), 12, 22

IN operator

emulating, 375–376

SELECT statement, 256–258

indexes

ACME sample database, 617

altering, 159–160

clustered, 13

columns, dropping

MS SQL Server 2000, 155

Oracle 9i, 149

creating

DB2 UDB 8.1, 110–111

MS SQL Server 2000, 111–112

Oracle 9i, 109–110

DDL statements, syntax, 729

described, 106–109

dropping

DB2 UDB 8.1, 161

MS SQL Server 2000, 161

Oracle 9i, 160–161

join tables, 305

listing, 461, 466–467

maximum name length restrictions, 8

partitioning, Oracle 9i, 188

tables, storing unique addresses (UROWID), 73

tablespaces, specifying, 98

indicator variables, host variables, embedded SQL, 532–533

Information Management System. See IBM IMS

INFORMATION_SCHEMA views

MS SQL Server 2000, system catalog, 470–675

Oracle 9i data dictionary, 462–464

system catalogs, 456–458

Informix, 768

INGRES II, 768

inheritance, object, 601–602

INITIALLY DEFERRED table constraints, 97

inline views, joins involving, 302–303

inner joins

described, 279–280

multitable queries

cross join, 289–290

equijoin, 282–284

nonequijoin, 284–286

self-join, 287–289

syntaxes, 279–281

older syntax, 281

SQL99, 280–281

input

data, 32–35

versus output host variables, embedded SQL, 531

inserting

populating tables (INSERT)

for all columns, 182–183

clauses, described, 178–179

DB2 UDB 8.1, 189–190

described, 177–178

integrity constraints, 186

MS SQL Server 2000, 190–192

NULL and default values, 183–184

Oracle 9i, 188–189

from other tables, 184–185

SQL99 specifics, 187–188

value for specified column, 179–181

rows

multiple, 189

and updating (MERGE), 202–204

secure handling, 440–441

views, restricting, 438

with SELECT statement, 248–249

installing applications

ACME database

on DB2 UDB 8.1, 691–693

on MS SQL Server 2000, 693–694

on Oracle 9i, 689–691

DB2 UDB 8.1, 658–666

MS SQL Server 2000, 666–673

Oracle 9i

general information, 637–638

on Linux, 653–658

on SUN Solaris, 648–653

on Windows NT/2000/XP, 638–648

uninstalling

DB2 UDB 8.1, 666

MS SQL Server 2000, 672–673

Oracle 9i, 646–647, 653

integers

ANSI/ISO code, 549

bit operations, 389–392

numbers, described, 54

programming languages, corresponding, 532

storing, 55

tablespaces, specifying, 131

integrity constraints

modifying existing data (UPDATE), 197

populating tables (INSERT), 186

removing data (DELETE), 200–201

integrity, data, 398

interactive mode, DB2 UDB 8.1 CLP (Command-Line Processor), 681

InterBase

described, 768

domains, 130

Internet protocols, 40, 592

intersection, set theory operations, 782

intervals, time, Oracle 9i, 66

invoice numbers, generating sequential. See identity clause; sequences

IS NULL operator, 258–259

ISO (International Organization for Standardization)

data type codes, 549

defaults, specifying, MS SQL Server 2000, 212

dynamic SQL and SQL99 standards, 543

history of, 7, 23

security standard (No. 17799), 451–452

standards documents, 29

time formats, 67

isolation levels, transactions, 217, 225–228

iSQL*Plus, 680