SPM   277

test phases   267, 269

SQJ   277

test planning   264

SQL   14, 95, 277

test strategy   265

SQL execution plan   308

testing   60, 263

SQL table functions   289

TIMESTAMP   134 135, 149

SQL/PSM   320

TIMESTAMPFORMAT   134

SQL 92   36

tools catalog   80

SQL 99   36

Transaction Management   31

SQLCODE   277

Transactions   36

SQLException   216

transaction safe   99

SQLj   27, 192

trap files   281

sqllogdir   17

trigger   38

SQLPorter   54

tuning   60, 263

sqluexpr   244

two tier architecture   51

SQLWays   54

Type 2 driver   26

standby   247

Type 2 driver,   189

Static SQL statements   24

Type 3 driver   26, 190

Storage Manager   32

Type 4 driver   26

stored procedure   38, 320

typed view   318

structured query language   14, 95

structured type   325

U

Subqueries   37

UDT   90

suspended I/O   247

unfenced procedures   323

symbolic link   96

Unified ODBC   178

SYSADM   142

UNION ALL   104

SYSCAT.EVENTMONITORS   293

unique key   111

SYSCTRL   142

unit of work   229

SYSMAINT   142

unixODBC   178

system authority   142

UPDATE MONITOR SWITCHES   287

System catalog table   13

user   138 139

System Managed Space   98, 297

user account management   138

system planning   51

differences   138

user data   138, 140

T

user defined data type   90

table   14, 98

username   139

table function   289, 291

table functions   289

V

table funtion   328

version recovery   239

table level   144

view   14, 37, 318

table snapshot   288

view level   144

table space   13, 98, 110, 297

Views   318

table space level   143

views   318

table space snapshot   288

Visual Explain   295

tables_priv   138 139

VisualAge   321

TechNotes   284

volume stress testing   268

temporary table   104

test deliverables   266

test documentation   264

 Index 

373