A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

Master Index

Symbols

@ 1, 2

triggers 1

A

aborting transactions 1

ABS 1

access

privileges 1, 2, 3, 4, 5

DELETE 1

INSERT 1

REFERENCES 1

SELECT 1

UPDATE 1

access control statements 1, 2

GRANT 1

REVOKE 1

access privileges 1

DELETE 1, 2

examples 1

granting 1

INSERT 1, 2

REFERENCES 1, 2

revoking 1

SELECT 1, 2

UPDATE 1, 2

access rights

for cursors 1

access-clause for procedures 1

accessing data 1

active connection 1, 2

ADO.NET 1

AFTER 1, 2

ALL 1, 2, 3

in SELECT clause 1

predicate 1

ALLOCATE CURSOR 1

ALLOCATE DESCRIPTOR 1

ALTER DATABANK 1, 2

INTO 1

SET FILESIZE 1

TO

LOG 1

TRANSACTION 1

WORK 1

ALTER DATABANK RESTORE 1

filename-string 1

LOG 1

ALTER DATABASE 1

ALTER IDENT 1, 2

ALTER SEQUENCE 1

ALTER SHADOW 1

ALTER STATEMENT 1

ALTER SUBSCRIPTION 1

ALTER TABLE 1, 2

Alternate Weighting 1

ANSI/ISO 1

ANY 1, 2

APIs

embedded SQL 1

JDBC 1

Application Server 1

arccosine 1

arcsine 1

arctangent 1, 2

arithmetic operations 1

arithmetical operators 1, 2

arrays 1

AS

for column labels 1

for connection name 1

ASCII_CHAR 1

ASCII_CODE 1

assigning values 1

standard compliance 1, 2

assignment

SET 1

assignments 1

string 1

ATOMIC 1

Audit trail 1

audit trail 1

authorization

database statistics 1

DBC 1

DBOPEN 1

automatic upgrade 1

AUTOUPGRADE 1, 2, 3, 4

AVG 1, 2

B

BACKUP 1

privilege 1, 2

backup

databank 1

backup and restore 1

SQL statements 1

back-up protection 1

backups of databanks 1

Backward Accent Ordering 1

backward compatibility 1

balanced I/O 1

basic predicate 1

subselect 1

batch jobs 1

security 1

Batch SQL 1

BEFORE 1, 2

BEGIN DECLARE SECTION 1, 2

BETWEEN 1

BETWEEN operator 1

BIGINT 1

BINARY LARGE OBJECT 1

binary operators 1

BIT_LENGTH 1

BLOB 1

Block Fetching 1

Boolean 1

BSQL 1

batch jobs 1

command-line arguments 1

commands 1

errors in 1

host variables 1

logging in 1

running 1

syntax descriptions 1

Unix command line 1

variables 1

BSQL commands 1

CLOSE 1

DESCRIBE 1

DESCRIBE options 1

EXIT 1

GET DIAGNOSTICS 1

LIST 1

LOG 1

READ INPUT 1

SET ECHO 1

SET EXECUTE 1

SET EXPLAIN 1

SET LINECOUNT 1

SET LINESPACE 1

SET LINEWIDTH 1

SET LOG 1

SET MAX_BINARY_LENGTH 1

SET MAX_CHARACTER_LENGTH 1

SET MESSAGE 1

SET OUTPUT 1

SET PAGELENGTH 1

SET PAGEWIDTH 1

SHOW SETTINGS 1

TRANSACTIONS 1

WHENEVER 1

bufferpool 1

report 1

C

C (programming language)

preprocessor output 1

C/C++ 1

comments 1

data types 1

value assignments 1

host variables 1

declaring 1

line continuation 1

null terminated strings 1

quotation marks 1

special characters 1

statement delimiters 1

statement format 1

white-space 1

CALL 1

CALL statement 1

calling procedures 1, 2

CASCADE 1, 2, 3, 4, 5, 6

cascade 1

access privileges 1

effects with drop and revoke 1

CASE 1, 2, 3

rules 1, 2

CASE expression 1

COALESCE 1

is NULLIF 1

NULLIF 1

rules 1, 2

short forms 1

CAST 1, 2

CAST specification 1

example 1

rules 1

CEILING 1

changing connections 1

changing databank file location 1

changing password 1

changing passwords 1

changing shadow to master databank 1

CHAR(n) 1

CHAR_LENGTH 1, 2

character set 1, 2

character string 1

character string comparison 1

CHARACTER VARYING(n) 1

CHARACTER(n) 1

CHARACTER_SET_ CATALOG 1

CHARACTER_SET_ NAME 1

CHARACTER_SET_ SCHEMA 1

character-string-literal 1

CHECK 1, 2

in domain 1, 2

check

conditions 1

option in views 1

check conditions 1

in tables 1

CHECK OPTION

in view definition 1

check option in views 1

check options 1

client/server 1

CLOB 1

maximum length 1, 2

CLOSE 1

closing a cursor 1

COALESCE 1

COBOL 1

comments 1

data types 1

host variables 1

line continuation 1

preprocessor output 1

statement delimiters 1

COLLATE 1

collation 1, 2, 3

creating 1

dropping 1

COLLATION_CATALOG 1

COLLATION_NAME 1

COLLATION_SCHEMA 1

collations 1

altering 1

comparison operators 1

concatenation operator 1

CREATE DOMAIN 1

CREATE INDEX 1

CREATE/ALTER TABLE 1

DISTINCT 1

dropping 1

GROUP BY 1

IN and BETWEEN 1

INFORMATION_SCHEMA 1

ORDER BY 1

precedence 1

scalar string functions 1

UNION 1

using 1

using - examples 1

column

adding 1

altering 1

dropping 1

column definition 1

column labels 1

column names

in UNION queries 1

in views 1

column names in UNION 1

COM+ 1

COMMAND_FUNCTION 1

command-line arguments

MIMCONTROL 1

MIMINFO 1

SDBGEN 1, 2

COMMENT 1

comment

dropping 1

comments 1, 2, 3

changing 1

dropping 1

in COBOL 1

in FORTRAN 1

in routines 1

COMMIT 1, 2

committing transactions 1

comparison 1

comparison operators 1

comparisons 1

truth tables 1

compiler 1

computed values 1

concatenation 1

concurrency control 1, 2

condition names

declaring 1

conditional execution

CASE 1

IF 1

CONFORMANCE 1

CONNECT 1, 2

backward compatibility syntax 1

CONNECT SOURCE USER 1

CONNECT TARGET USER 1

connecting 1

connection name 1

connection statements 1, 2

CONNECT 1

DISCONNECT 1

ENTER 1

LEAVE 1

SET CONNECTION 1

connections

cursors 1

constants 1

CONSTRAINT_CATALOG 1

constraints

referential 1

unique 1

CONTINUE 1

contractions 1

correlation names 1, 2

cosine 1

cotangent 1

COUNT 1, 2

CREATE

BACKUP 1

COLLATION 1

DATABANK 1

DOMAIN 1

FUNCTION 1

IDENT 1

INDEX 1

MODULE 1

PROCEDURE 1

SCHEMA 1

SEQUENCE 1

SHADOW 1

STATEMENT 1

SYNONYM 1

TABLE 1

TRIGGER 1

VIEW 1

CREATE SUBSCRIPTION 1

creating

collations 1

comments 1

databanks 1, 2

domain 1

domains 1

function 1

ident 1

module 1

modules 1

procedure 1

procedures 1

schema 1

secondary index 1

secondary indexes 1

sequence 1

shadow databank 1

synonym 1

synonyms 1

table 1

tables 1

trigger 1

triggers 1

view 1

views 1

views on views 1

cross product 1

current row 1

CURRENT_DATE 1

CURRENT_PROGRAM 1

CURRENT_USER 1

CURRENT_VALUE 1

cursor

closing 1

cursor stack 1, 2

cursor-independent data manipulation 1

cursors 1, 2

access rights 1, 2

and program idents 1

closing 1

declaring 1, 2

deleting current row 1

evaluating declaration 1

evaluating SELECT statement 1

extended dynamic 1

for join conditions 1

for UPDATE and DELETE 1

in dynamic SQL 1

in multiple connections 1

opening 1, 2

position after delete 1

position in result set 1, 2

positioning 1

positioning in result set 1

REOPENABLE 1

resource allocation 1

retrieving data 1

SCROLL 1, 2

stacking 1

transactions 1

updatable 1

updating and deleting with 1

updating data 1

D

DACOS 1

DASIN 1

data

binary 1

description headers 1

errors 1

files 1

loading 1

numerical 1

data definition statements 1, 2

ALTER 1

COMMENT 1

CREATE 1

DROP 1

data dictionary 1, 2, 3

tables 1

data integrity 1, 2, 3

check conditions 1

check options 1

domains 1

foreign keys 1

data manipulation 1

data manipulation statements 1

CALL 1

DELETE 1

INSERT 1

SELECT 1

SET 1

UPDATE 1

data protection 1

levels 1

data types

abbreviations 1

BINARY VARYING(n) or VARBINARY(n) 1

BINARY(n) 1

C/C++ 1

CHAR(n) 1

CHARACTER VARYING(n) or VARCHAR(n) 1

CHARACTER(n) 1, 2

compatibility 1

compatibility in FETCH statements 1

conversion 1, 2, 3, 4

DATE TIME TIMESTAMP 1

DOUBLE PRECISION 1

in COBOL 1

in FORTRAN 1

INTERVAL 1

NCHAR 1

NCHAR VARYING 1

parameter markers 1

ROW 1

standard compliance 1

DATABANK 1

privilege 1

databank 1, 2

access errors 1

altering 1

backup 1

creating 1

dropping 1

file location 1, 2

name 1, 2

offline 1

restoring 1

shadow 1

shadows offline 1

shadows online 1

system 1

user 1

databank check. See DBC1

DATABANK privilege 1

databank shadows 1

databanks 1, 2

allocating disk space 1

altering 1

backup 1

changing location 1

creating 1

data security 1

disk I/O 1

dropping 1

file access 1

file deletion 1

initial size 1

locating files 1

online 1

options 1

organizing 1

recreating 1

restoring from backup 1

system 1, 2

LOGDB 1

SQLDB 1

SYSDB 1

TRANSDB 1

user 1, 2

database 1, 2

accessing 1

administration 1

connecting 1

connecting to 1

data dictionary 1

default (node-specific) 1

defining user specific 1

definition statements 1

design 1

environment 1

ident and data structure 1

listing connected users 1

local 1

objects 1

offline 1

online 1

optimizing performance 1

private objects 1

privileges 1

remote 1

security 1

selecting 1

single-user mode 1

statistics 1

SYSADM 1

system objects 1

troubleshooting connect failures 1

database administration statements 1

ALTER DATABANK 1

CREATE BACKUP 1

CREATE INCREMENTAL BACKUP 1

RESTORE 1

SET DATABANK 1

SET DATABASE 1

SET SHADOW 1

UPDATE STATISTICS 1

database server 1

bufferpool 1

client-server interface 1

communication buffers 1

controlling 1

error messages 1

managing 1

memory requirements 1

MIMCONTROL 1

MIMINFO 1

performance 1

SQLPOOL 1

system information 1

system requirements 1

threads 1

DATAN 1

DATAN2 1

DATE 1

datetime

arithmetic 1

functions 1

datetime and interval comparisons 1

datetime assignments 1

DATETIME data types 1

Datetime literals 1

DATETIME_INTERVAL _CODE 1

DATETIME_INTERVAL _PRECISION 1

DAYOFWEEK 1

DAYOFYEAR 1

DAY-TIME 1

DBC 1

command-line arguments 1

error messages 1

bitmap errors 1

root page errors 1

sequential structure errors 1

table structure errors 1

for LOGDB, TRANSDB and SQLDB 1

end page 1

no. of pages read 1

no. of records read 1

page size 1

start page 1

status of table 1

tabid 1

type of table 1

result file 1

table information 1

data page size 1

index page size 1

keylen 1

levels 1

number of data pages 1

number of index pages 1

reached no of records 1

reclen 1

required/allocated data pages 1

startp 1

status of table 1

tabid 1

type of table 1

DBOPEN 1

authorization 1

background threads 1

command-line arguments 1

functions 1

multi-user mode 1

output example 1

DCOS 1

DCOT 1

DDEGREES 1

DDL 1

deadlock 1

DEALLOCATE

DESCRIPTOR 1

PREPARE 1

deallocating cursor resources 1

debugging 1

DECIMAL 1

decimal literals 1

declaration of SQLSTATE 1

DECLARE

CONDITION 1

CURSOR 1

HANDLER 1

SECTION 1

VARIABLE 1

DECLARE SECTION 1

declaring

condition names 1

cursors 1

host variables 1

routine variables 1

declaring host variables 1

declaring procedure variables 1

DEFAULT

in column definition 1

in domain 1

DEFAULT section 1

default transaction mode settings 1

default values 1

default values in domains 1

DELETE 1, 2, 3, 4, 5

CURRENT 1

privilege 1

privileges 1

DELETE STATISTICS 1

delimiting complex statements with @ 1

deprecated features 1, 2

parameter markers 1

SET TRANSACTION CHANGES 1

SQLCODE 1, 2

SQLDA 1

VARCHAR(size) 1

DESCRIBE

COLLATION 1

DATABANK 1

DOMAIN 1

FUNCTION 1

IDENT 1

INDEX 1

MODULE 1

PROCEDURE 1

SCHEMA 1

SEQUENCE 1

SHADOW 1

SPECIFIC 1

SYNONYM 1

TABLE 1

TRIGGER 1

VIEW 1

DESCRIBE INPUT 1

DESCRIBE SELECT LIST 1

DESCRIBE SUBSCRIPTION 1

DESCRIBE USER VARIABLES 1

descriptor area 1

see SQLDA 1

destroy allocated cursor 1

destroy prepared statement 1

DEXP 1

diagnostics area 1, 2

DISCONNECT 1, 2

DISCONNECT SOURCE 1

DISCONNECT TARGET 1

disconnecting 1

DISTINCT 1, 2

in set functions 1

DLOG 1

DLOG10 1

domain 1

creating 1

data integrity 1

dropping 1

domains 1, 2

check clause 1

creating 1

default value 1

default values 1

dropping 1

dormant cursors 1

DPOWER 1

DRADIANS 1

DROP 1, 2

drop behavior 1

drop log 1

DROP SUBSCRIPTION 1

dropping objects 1

DSIN 1

DSQRT 1

DTAN 1

DTC 1, 2

duplicate values 1

dynamic SQL 1, 2

cursors 1

descriptor area 1

example framework 1

executing statements 1

input variables 1

object form of statements 1

output variables 1

parameter markers 1

preparing statements 1

source form of statements 1

SQL statements 1

statement source form 1

statements 1, 2

ALLOCATE CURSOR 1

ALLOCATE DESCRIPTOR 1

CLOSE 1

DEALLOCATE DESCRIPTOR 1

DEALLOCATE PREPARE 1

DESCRIBE 1

EXECUTE 1

EXECUTE IMMEDIATE 1

FETCH 1

GET DESCRIPTOR 1

OPEN 1

PREPARE 1

SET DESCRIPTOR 1

submitting 1

dynamic SQL statements

executing 1, 2

opening cursors 1

preparing 1

source form 1

DYNAMIC_FUNCTION 1

E

Embedded SQL

ESQL 1

host languages 1

program structure 1

scope 1

statements 1

embedded SQL control statements 1

END DECLARE SECTION 1, 2

ENTER 1, 2

ENTER SOURCE 1

ENTER TARGET 1

entity integrity 1

environment variables 1

EOR 1

error

codes 1, 2

handling 1

Error handling 1

error handling 1

in transactions 1

error messages

DBC 1

errors

examples 1

illegal BSQL commands 1

messages 1

semantic 1

syntax 1

escape

characters 1

clause 1

ESCAPE in LIKE conditions 1

ESQL 1

evaluating cursor declaration 1

example database 1

exception

conditions 1

handlers

declaring 1

exception conditions 1

exception handlers 1

continue 1

exit 1

undo 1

exception-info 1

EXEC SQL 1

EXECUTE 1, 2, 3

on routine 1

privileges 1

EXECUTE IMMEDIATE 1

EXECUTE privilege

on procedure 1

on program ident 1

EXECUTE STATEMENT 1

EXISTS 1

condition 1

NULL values 1

EXIT 1

EXLOAD 1

exp 1

expression

CASE 1

expressions 1

binary operators 1

evaluating arithmetical 1

evaluating string 1

in SELECT 1

operands 1

precision and scale 1

standard compliance 1

syntax 1

unary operators 1

EXPTOLOAD 1

extended cursor

allocate 1

DELETE CURRENT 1

UPDATE CURRENT 1

EXTRACT 1, 2

F

FETCH 1, 2, 3

scrollable cursor 1

file extension

shadow databank 1

file location

databank 1, 2

FILESIZE 1, 2

FLOAT 1

floating point literals 1

FLOOR 1

FOR loop 1

FOR UPDATE OF 1

foreign keys 1, 2

data integrity 1

FORTRAN 1

comments 1

host variables 1

line continuation 1

preprocessor output 1

statement delimiters 1

statement margins 1

statement numbers 1

function

dropping 1

functions 1, 2, 3, 4, 5

datetime pseudo literals

CURRENT_DATE 1

LOCALTIME 1

LOCALTIMESTAMP 1

invoking 1

scalar functions 1

standard compliance 1

scalar interval functions

ABS 1

scalar numeric functions 1

ASCII_CODE 1, 2

BIT_LENGTH 1

CHAR_LENGTH 1

CURRENT_VALUE 1

DAYOFWEEK 1

DAYOFYEAR 1

EXTRACT 1

IRAND 1

MOD 1

NEXT_VALUE 1

OCTET_LENGTH 1

POSITION 1

ROUND 1

SIGN 1

TRUNCATE 1

WEEK 1

scalar string functions

ASCII_CHAR 1, 2

CURRENT_PROGRAM 1

LOWER 1

PASTE 1

REPEAT 1

REPLACE 1

SOUNDEX 1

SUBSTRING 1

TAIL 1

TRIM 1

UPPER 1

set functions 1

ALL 1

AVG 1

COUNT 1

DISTINCT 1

eliminating duplicate values 1

empty operand set 1

evaluating 1

MAX 1

MIN 1

NULL 1

operational mode 1

precision and scale 1

restrictions 1

results 1

standard compliance 1

SUM 1

syntax 1

SQL statements 1

string `pseudo literals'

CURRENT_USER 1

SESSION_USER 1

USER 1

user-defined 1

G

general exception handlers 1

GET DESCRIPTOR 1

GET DIAGNOSTICS 1, 2

COMMAND_FUNCTION 1

DYNAMIC_FUNCTION 1

exception-info 1

CATALOG_NAME 1

CLASS_ORIGIN 1

COLUMN_NAME 1

CONDITION_IDENTIFIER 1

CONDITION_NUMBER 1

CONNECTION_NAME 1

CONSTRAINT_CATALOG 1

CONSTRAINT_NAME 1

CONSTRAINT_SCHEMA 1

CURSOR_NAME 1

MESSAGE_LENGTH 1

MESSAGE_OCTET _LENGTH 1

MESSAGE_TEXT 1

NATIVE_ERROR 1

PARAMETER_NAME 1

RETURNED_SQLSTATE 1

ROUTINE_CATALOG 1

ROUTINE_NAME 1

ROUTINE_SCHEMA 1

SCHEMA_NAME 1

SERVER_NAME 1

SPECIFIC_NAME 1

SUBCLASS_ORIGIN 1

TABLE_NAME 1

TRIGGER_CATALOG 1

TRIGGER_NAME 1

TRIGGER_SCHEMA 1

ROW_COUNT 1

statement-information 1

COMMAND_FUNCTION 1

DYNAMIC_FUNCTION 1

MORE 1

NUMBER 1

ROW_COUNT 1

TRANSACTION_ACTIVE 1

GOALSIZE 1, 2

GOTO 1

GRANT OBJECT PRIVILEGE 1

GRANT OPTION 1, 2, 3

grant option 1, 2

GRANT SYSTEM PRIVILEGE 1

granting privileges 1

GROUP BY 1, 2

GROUP ident 1

group ident 1, 2

GROUP idents 1

group idents 1

group membership 1

H

handlers

declaring 1

HAVING 1, 2

holdable 1

holdable cursor 1, 2, 3, 4

host identifier 1

host identifiers 1

host language

included code 1

host languages 1

C/C++ 1

COBOL 1

FORTRAN 1

host variable declarations 1

host variables 1, 2, 3

arrays 1

declaration 1

declarations 1

declaring 1

in COBOL 1

in cursor declarations 1

in FORTRAN 1

in SQL statements 1

names 1

scope 1

SQL 1

using 1

I

IDENT 1

privilege 1, 2

ident 1, 2, 3

access and authority 1

creating 1

disconnecting from a database 1

dropping 1

GROUP 1

group 1, 2

group membership 1

OS_USER 1, 2, 3

PROGRAM 1

program 1, 2

structuring guidelines 1

SYSADM 1

USER 1

user 1, 2

identifiers

host 1

standard compliance 1

idents 1, 2, 3

altering 1

dropping 1

GROUP 1

group 1

names 1

OS_USER 1, 2

PROGRAM 1

program 1

structure 1

USER 1

user 1

IF 1

implicit connection 1

IN condition 1

IN predicate 1

INCLUDE SQLCA 1

included code

host language 1

index 1

indexes 1, 2

indexing

automatic 1

Indic 1

indicator variable 1

indicator variables 1, 2

including 1

INFORMATION_SCHEMA 1

INNER JOINs 1

INSERT 1, 2, 3, 4, 5

privilege 1

privileges 1

inserting NULL values 1

inserting with a subselect 1

inserting with a values list 1

install 1

INSTEAD OF 1, 2

INTEGER 1

integer literals 1

integrity

domains 1

foreign key 1

in view definitions 1

primary key 1

within tables 1

intermediate result sets 1

INTERVAL 1

literals 1

qualifiers 1

INTERVAL data types 1

invoking functions 1

invoking procedures 1

IRAND 1

IS NULL 1

ISO/IEC 9075 1

ISOLATION LEVEL 1

isolation levels 1

isolation levels in transactions 1

item descriptor area 1

ITERATE 1, 2, 3

iteration 1

LOOP statement 1

REPEAT statement 1

skip 1

WHILE statement 1

iterative execution

LOOP 1

REPEAT 1

WHILE 1

J

Japanese 1

JDBC 1, 2

driver 1

JOIN

FULL OUTER 1

INNER 1

LEFT OUTER 1

NATURAL 1

ON 1

OUTER 1

RIGHT OUTER 1

standard compliance 1

USING 1

join

a table with itself 1

condition 1

views 1

join retrievals

using cursors 1

joined tables 1

joins 1

natural 1

outer 1

simple 1

K

Kanji 1, 2

keys