HP 3000 Manuals HP 3000 Manuals
Index
A
access plan
defined
modifying with SETOPT
access to databases
multiple connections
types
active connection
defined
active set
in DECLARE CURSOR
in FETCH
in OPEN
in REFETCH
actual parameter
using in procedures
ADD DBEFILE
syntax
adding
ADD TO GROUP
column to table
constraint to table
DBEFiles
members to authorization group
rows
ADD_MONTHS
in an expression
syntax
ADD TO GROUP
syntax
ADVANCE
syntax
aggregate functions
arguments in
DECIMAL arguments
in an expression
in NULL predicates
syntax
truncation
type conversion
ALL
in aggregate function
in quantified predicate
in SELECT
all audit element
in START DBE NEW
in START DBE NEWLOG
ALLBASE/SQL
components
data types
definition
message catalog
names
users
allocating file space
in CREATE DBEFILESET
ALTER DBEFile
syntax
altering
DBEFile type
tables
ALTER TABLE
syntax
to change table locking
to set audit partition
ANSI standards
ANY
in quantified predicate
application programming
and SQL statements
archive logging
wrapperDBE
archive mode
definition
use of BEGIN ARCHIVE
use of COMMIT ARCHIVE
archive record
use of COMMIT ARCHIVE
arithmetic operators
in an expression
Assignment
syntax
asymmetric outer join
defined
atomicity
setting in SET SESSION
setting in SET TRANSACTION
audit
DBE understanding
disabling logging
elements default
elements understanding
enabling logging
functionality definition
information wrapperDBE
log record
partition with ALTER TABLE
tool
transactions with SQLAudit
AUDIT NAME
in START DBE NEW
in START DBE NEWLOG
authorities
and program development
and program use
defined
direct
granting
granting on DBEFileSET
how to obtain
OWNER
REFERENCES
revoking
RUN
summary of types
table and view
authorization
audit element in START DBE NEWLOG
check constraint in ALTER TABLE
check constraint in CREATE TABLE
DBEFileSet in CREATE PROCEDURE
DBEFileSet in CREATE VIEW
DBEFileSet in PREPARE
DBEFileSet in REVOKE
for a procedure cursor
for a select cursor
in START DBE NEW
long column in ALTER TABLE
long column in CREATE TABLE
name
section in PREPARE
SECTIONSPACE in CREATE RULE
authorization groups
adding members to
advantages of
creating
dropping
removing members from
use of
AUTOCOMMIT
DELETE parameter
VALIDATE parameter
automatic locking modes
in CREATE TABLE
autostart
and CONNECT
mode
average
in aggregate function
AVG
syntax
B
base table
defined
basic names
objects having
rules governing
BEGIN
syntax
BEGIN ARCHIVE
syntax
BEGIN DECLARE SECTION
syntax
BEGIN WORK
and MULTITRANSACTION
cursor stability isolation level
in a procedure
read committed isolation level
read uncommitted isolation level
repeatable read isolation level
syntax
BETWEEN predicate
in search condition
syntax
BINARY
conversions rules
long data type defined
storage requirements
built-in variable
differences from local variables
similar to SQLCA elements
using in procedures
BULK operations
FETCH
INSERT
SELECT
use of
BY
syntax
C
caller of a procedure
recommended practices for
Cartesian product
defined
in SELECT
CASCADE
explained
syntax
case sensitive
comparison predicate
comparisons
CAST function
arguments in
syntax
CATALOG
owner of catalog views
catalog views
explained
chain
of grants
of rules
changing
connections
data
DBEFile type
table locking
CHAR
conversions rules
defined
native language data
storage requirements
check constraint
authorization in ALTER TABLE
authorization in CREATE TABLE
defined
in ALTER TABLE
in a view
in CREATE TABLE
search condition
CHECKPOINT
record
syntax
use of
checkpoint for STOP DBE
classes
creating
use of
class names
in REVOKE
rules for
clause
defined
CLOSE
syntax
closing cursors
clustered indexes
COBOL preprocessor
defined
MICROFOCUS
coding practices
for procedures
column names
in ALTER TABLE
in an expression
in CREATE INDEX
in CREATE TABLE
in CREATE VIEW
in INSERT
in null predicates
rules for
columns
adding to tables
and Cartesian product
common columns in join
defined
defining
definition
maximum allowed in tables
maximum allowed in views
order of display
comment audit element
in START DBE NEW
in START DBE NEWLOG
comment initiator
within SQL statements
comment partition
in START DBE NEW
in START DBE NEWLOG
COMMIT ARCHIVE
syntax
COMMIT WORK
in a procedure
syntax
common columns
in SELECT
COMPARISON predicate
character collation sequence
in search condition
operators
syntax
type conversion in
complex queries
defined
range of types
compound identifiers
in names
concatenate
data types
strings
concurrency
and table size
control
configuring a DBEnvironment
in START DBE NEW
summarized
CONNECT
syntax
transactions
connection
and SET CONNECTION
changing
disconnecting
initiating
terminating
to DBEnvironments
use with timeouts
connection name
in CONNECT
in SET CONNECTION
in START DBE
in START DBE NEWLOG
constant
defined
in an expression
in NULL predicates
CONSTANT
syntax
constraint
check constraint
defined
defining
error checking and SET statement
error checking in SET SESSION
error checking in SET TRANSACTION
example
constraint checking
setting in SET SESSION
setting in SET TRANSACTION
control block
in START DBE
in START DBE NEW
in START DBE NEWLOG
control flow statements
in procedures
RETURN
control language
GOTO in procedures
in procedures
controlling
error checking level
conversion functions
syntax
conversion rules
data in query expressions
converting
data types
copying rows
to tables and views
correlated subquery
explained
correlation names
in SELECT
COUNT
syntax
C preprocessor
defined
CREATE DBEFILE
syntax
CREATE DBEFILESET
syntax
CREATE GROUP
syntax
CREATE INDEX
syntax
CREATE PARTITION
syntax
CREATE PROCEDURE
explained
syntax
CREATE RULE
invoking a procedure through
syntax
using
CREATE SCHEMA
syntax
CREATE TABLE
LANG = clause
syntax
CREATE TEMPSPACE
syntax
CREATE VIEW
syntax
creating
audit DBE
authorization groups
constraints
databases
DBEFile
DBEFileSets
DBEFile volume specification
DBEnvironments
indexes
partition
tables
TempSpace
views
CS isolation level
explained
in SET SESSION
in SET TRANSACTION
current
function in an expression
function syntax
language defined
row in FETCH
row in REFETCH
timeout value in multi-transaction
current connection
in CONNECT
none after DISCONNECT CURRENT
setting
CURRENT_DATE function
syntax
CURRENT_DATETIME function
syntax
CURRENT_TIME function
syntax
cursor names
in CLOSE
in DECLARE CURSOR
in DELETE WHERE CURRENT
in FETCH
in OPEN
in UPDATE WHERE CURRENT statement
rules for
cursors
active set
advancing
and INTO clause
closed
closing
current row
declaring
deleting rows with
in procedures
opening
procedure cursor parameters in
retrieving rows with
updatability of
updating data with
use of
using in procedures
using multiple
cursor stability (CS)
explained
cursor stability isolation level
in BEGIN WORK
in SET SESSION
in SET TRANSACTION
cycle
in chain of grants
D
data
access
in native languages
manipulation
data audit element
in START DBE NEW
in START DBE NEWLOG
database
administration activities
administrator defined
control of access to
creation
creation (CREATE SCHEMA)
logical definition
physical definition
statistics
data buffer pages
in START DBE
in START DBE NEW
in START DBE NEWLOG
data definition statements
in procedures
data types
comparisons between
conversion
converting
effect of
in CREATE TABLE
of column added to existing table
of columns in joins
rules governing
table of
valid combinations
DATE
conversions rules
defined
operations with values
storage requirements
values in arithmetic expression
DATETIME
conversions rules
defined
operations with values
storage requirements
values in arithmetic expressions
date/time conversion functions
in an expression
syntax
DBA
automatic grant of authority
defined
statements authorized to use
DBECon file
creation
defined
naming conventions
overriding parameters
parameters
DBECreator
authorization
defined
statements authorized to use
DBEFile0
defined
naming
DBEFile names
group name
in ADD DBEFile
in ALTER DBEFile
in CREATE DBEFILE
in DROP DBEFILE
in REMOVE DBEFile
rules for
DBEFiles
adding
altering type of
creating
defined
dropping
for data
for indexes
incrementing size
purging
relation to DBEFileset
removing from DBEFileSet
size range
type
using
DBEFileSet
authorization in CREATE PROCEDURE
authorization in CREATE VIEW
authorization in PREPARE
authorization in REVOKE
creating
defined
dropping
dropping default
dynamic section
dynamic statement
for a check constraint
for a long column
for a table
in DECLARE CURSOR
relation to DBEFiles
revoking authority
setting a default
specifying for a cursor
specifying for a view
DBEFileSet names
in ADD DBEFile
in CREATE TABLE
in REMOVE DBEFile
rules for
DBEFile type
in ALTER DBEFile
in CREATE DBEFILE
DBELog1
defined
DBELog2
defined
DBEnvironment
components
configuration
connecting to
creating
creating audit
defined
disconnecting from
initial privileges
naming conventions
obtaining information on
startup parameters
statistics
DBEnvironment name
in CONNECT
in DISCONNECT
in START DBE
in START DBE NEW
in START DBE NEWLOG
DBE sessions
and autostart mode
defined
multiuser
setting the current connection
single-user
starting
terminating
DBEUserID
defined
in ADD TO GROUP
in GRANT
in REMOVE FROM GROUP
in RESET
in REVOKE
in TERMINATE QUERY
in TERMINATE USER
rules governing
DDL Enabled flag
defined
deadlock
avoidance of
definition
detection/resolution
example
in multi-transaction mode
DECIMAL
conversions rules
defined
in operations
storage requirements
DECIMAL data type
arguments in aggregate functions
DECLARE
and local variables in a procedure
DECLARE CURSOR
syntax
DECLARE Variable
syntax
declaring
cursors
host variables
local variables in a procedure
default
columns in tables
ownership discussed
default DBEFileSet
dropping
setting
default partition
in START DBE NEW
in START DBE NEWLOG
deferred error checking
constraint (SET CONSTRAINTS)
explained
referential constraint
defining objects
authorization groups
DBEFile
DBEFileSets
DBEnvironments
default columns in tables
tables
TempSpace
views
definition
of a column
of audit functionality
procedure cursor
select cursor
wrapperDBE
definition audit element
in START DBE NEW
in START DBE NEWLOG
DELETE
displaying access plan
statement type in rules
syntax
DELETE WHERE CURRENT
syntax
deleting
all rows from tables
authorization groups
data
DBEFiles
DBEFileSets
indexes
modules
rows
rows using a cursor
tables
TempSpaces
views
DESCRIBE
syntax
describing
dynamic statements
direct authority
explained
DISABLE AUDIT LOGGING
syntax
DISABLE RULES
syntax
using
disabling
audit logging
DISCONNECT
syntax
DISCONNECT CURRENT
no current connection following
disconnecting
from DBEnvironments
displaying
access plan
DISTINCT
in aggregate function
in SELECT
DML atomicity
setting
DML ATOMICITY
setting in SET SESSION
setting in SET TRANSACTION
DO
in procedures
DROP DBEFILE
syntax
DROP DBEFILESET
syntax
DROP GROUP
syntax
DROP INDEX
syntax
DROP MODULE
syntax
DROP PARTITION
syntax
dropping
authorization groups
constraint
DBEFiles
DBEFileSets
indexes
modules
partition
procedures
rules
tables
TempSpaces
views
DROP PROCEDURE
syntax
DROP RULE
syntax
DROP TABLE
syntax
DROP TEMPSPACE
syntax
DROP VIEW
syntax
dual logging
duplicate
column DISTINCT
column values eliminated
dynamic parameters
example of usage
example with BULK INSERT
example with INSERT
in DECLARE CURSOR:specifying
in EXECUTE PROCEDURE
syntax
dynamic preprocessing
defined
DESCRIBE
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
PREPARE
E
ELSE
in procedures
ELSEIF
in procedures
embedding SQL statements
explained
ENABLE AUDIT LOGGING
syntax
ENABLE RULES
syntax
using
enabling
audit logging
END DECLARE SECTION
syntax
ENDIF
in procedures
ENDWHILE
in procedures
error checking
explained
setting atomicity
transaction and statement constraints
using constraints
error handling
4008, 4009, or -14024 or greater
built-in variables
error number and text
in procedures invoked by rules
in procedures not invoked by rules
RAISE ERROR
exclusive lock
defined
EXCLUSIVE mode
in LOCK TABLE
EXECUTE
syntax
EXECUTE authority
granting
revoking
EXECUTE IMMEDIATE
statements that cannot be used with
syntax
EXECUTE PROCEDURE
in ISQL
syntax
using
executing
a procedure
dynamic statements
EXISTS predicate
explained
syntax
explicit locking
expression
and null values
date/time
defined
in aggregate function
in BETWEEN predicate
in COMPARISON predicate
in constants
in EXISTS predicate
in IN predicate
in LIKE predicate
in long column function
in NULL predicates
in string function
order of evaluation of elements in
overflow
syntax
truncation
type conversion
underflow
use
use of parentheses
USER expression value
extended characters
comparison prediate
F
FETCH
syntax
fetching rows
file names
explained
file space management
for tables and indexes
FILL option
setting in BEGIN WORK
setting in SET SESSION
FIPS flagging support
fixed-length strings
defined
fixed-point values
in constants
FLOAT
conversions rules
defined
storage requirements
FORCE
VALIDATE parameter
FOREIGN KEY
in CREATE TABLE
formal parameter
using in procedures
Fortran preprocessor
defined
free log space
checkpoint host variable
FROM
in simple queries
FromSpec
in SELECT
fully qualified name
functions
Add Months
aggregate
CAST function
current
date/time
long column
string functions
TID
G
generating
log comment
GENPLAN
explained
syntax
with SYSTEM and CATALOG views
GOTO
in procedures
syntax
GRANT
MONITOR authority
syntax
WITH GRANT OPTION explained
grantable privileges
explained
revoking
GRANT ON DBEFILESET
syntax
grants
automatic
explicit (GRANT)
grantable privileges
implicit (CREATE TABLE)
issuing
issuing for DBEFileSet
revoking
which authorities can be granted
who can issue them
granularity
of locking
GROUP BY
in SELECT
in simple queries
grouping rows
in SELECT
group names
DBEFile name
in ADD TO GROUP
in CREATE GROUP
in REMOVE FROM GROUP
in REVOKE
in TRANSFER OWNERSHIP
rules for
groups
adding members to
creating
dropping
in query result
removing members from
H
hash
in CREATE TABLE
specifying with SETOPT
HAVING
in SELECT
in simple queries
hexadecimal string
in constants
host variables
declaration of
differences from local variables
free log space
in an expression
in CONNECT
in EXECUTE IMMEDIATE
in FETCH
in INSERT
in LIKE predicates
in PREPARE
input
in ROLLBACK WORK
in SAVEPOINT
in SELECT
in SET CONNECTION
in SQLEXPLAIN
in UPDATE
in UPDATE WHERE CURRENT
naming rules
output
procedure parameter
procedure value
use of
HPODBSS
reserved owner name
HPRDBSS
owner of system tables
hyphen
as comment initiator
I
IF
in procedures
syntax
INCLUDE
syntax
incrementing
DBEFile size
index
allocating storage for
creating
defined
dropping
duplicate keys
locking explained
name in CREATE INDEX
name in DROP INDEX
name rules for
null values in
number of keys in
order of entries
restrictions in using
specifying with SETOPT
uses for
INDEX DBEFiles
indicator variables
example in predicates
in expressions
use of
INNER
in SELECT
inner join
defined
syntax
IN predicate
explained
syntax
USER expression value
INSERT
statement type in rules
syntax
use of
inserting
rows in a table
rows in INSERT
values in constraint columns
instance of partition
INTEGER
conversions rules
defined
storage requirements
integer values
in constants
integrity constraint
defined
example
intention
exclusive lock
share lock
interactive database access
defined
INTERVAL
conversions rules
defined
operations with values
storage requirements
values in arithmetic expressions
IS lock
explained
isolation level
defined
setting in BEGIN WORK
setting in SET SESSION
setting in SET TRANSACTION
ISQL
defined
EXECUTE PROCEDURE in
syntax summary
using to issue statements
IX lock
explained
J
join
algorithm specified by SETOPT
asymmetric
in complex queries
inner and outer
natural
nested loop
not using explicit join syntax
outer join
sort merge
symmetric
three or more tables
joining tables
in SELECT
in simple queries
one table to itself
JOIN ON
in SELECT
JOIN USING
in SELECT
K
keys
index
L
label
in GOTO
Labeled Statement
LANG = clause
for columns and tables
in ALTER TABLE
in CREATE TABLE
in START DBE NEW
language
current language
DBEnvironment and current
native language support
setting and resetting
LANG variable
setting and resetting
LEFT JOIN
in SELECT
left outer join
defined
LEFT OUTER JOIN
in SELECT
LIKE predicate
in search condition
syntax
local variable
and DECLARE Variable
differences from host variables
naming rules
using in procedures
locking
automatic
concurrency control
deadlocks
exclusive mode
explicit
granularity
implicit
in COMMIT WORK
in LOCK TABLE
isolation levels
levels of
mode
mode associated authorities
mode types of
objects locked
overriding automatic locking
page and table compared
PUBLIC
PUBLICREAD
release
released in deadlock
released in STOP DBE
releasing in ROLLBACK WORK
releasing locks
row and page compared
SET USER TIMEOUT
share
share update mode
locks
exclusive (X)
in RELEASE
intention exclusive (IX)
intention share (IS)
share intention exclusive (SIX)
share (S)
waits and timeout
LOCK TABLE
syntax
log buffer pages
in START DBE
in START DBE NEW
in START DBE NEWLOG
log buffers
flushing
log comment
generating
LOG COMMENT
syntax
log file
creating new
defined
increasing or decreasing space
orphaned, in wrapperDBE
log file names
assigning
in START DBE NEWLOG
rules for
logging
audit
dual
rollback
row level DML atomicity
logical operators
LONG
I/O string syntax
LONG BINARY
defined
storage requirements
long column
authorization in ALTER TABLE
authorization in CREATE TABLE
functions syntax
LONG data type
OUTPUT_DEVICE function
OUTPUT_NAME function
restricted from search condition
syntax, defining column
LONG VARBINARY
defined
storage requirements
M
MAX
syntax
maximum
columns
columns for a view
columns in a query
concurrent transactions
DBEFile size
hash key size
host variable names
host variables
items for DISTINCT option
length of index key
log file size
number of concurrent transactions
number of partitions
PrimaryPages
tables per query
TempSpace
timeout
MAXPAGES
maxpartitions
in START DBE NEW
in START DBE NEWLOG
MaxTransactions
message
buffer in procedures
catalog
error number
for PRINT statements
handling with SET PRINTRULES
number 5000
MICROFOCUS
COBOL preprocessor
MIN
syntax
minimum
DBEFile size
PrimaryPages
mixed DBEFiles
module names
in DROP MODULE
in PREPARE
in REVOKE
rules for
modules
access plan for validation
created by preprocessor
dropping
effect of DBEnvironment changes on
extracting
owner of
validating
MONITOR
authority
multiple
connections example
connections using
DBEnvironments
multitable operations
SELECT
using
multi-transaction mode
explained
undetectable deadlocks
use with one DBE
multitransaction mode
in SET MULTITRANSACTION
multiuser mode
defined
in a DBE session
N
names
basic
used in ALLBASE/SQL
naming
database objects
DBEConfile
DBEnvironment
DBEUserID
host variables
owners
system files
with native language objects
native-3000
and double quotes
defined
NATIVE CHAR
conversions rules
native language
ALLBASE/SQL object names
character data
current language
defaults
in columns and tables
in creating a DBEnvironment
setting and resetting
support overview
tables in ALTER TABLE
tables in CREATE TABLE
NATIVE VARCHAR
conversions rules
NATURAL
in SELECT
natural inner join
defined
NATURAL JOIN
in SELECT
NOT NULL
in CREATE TABLE
in defining a column
NULL predicate
in search condition
syntax
null values
and altering tables
and FETCH
and INSERT
and SELECT
and UPDATE
and UPDATE WHERE CURRENT
as index keys
behavior in Cartesian product
behavior in joins
defined
in an expression
in Cartesian product
in comparison predicates
in joins
in search conditions
O
objects
defined
native language names in
owner of
OPEN
syntax
operators
arithmetic
comparison
logical
optimizer
displaying access plan
modifying plan with SETOPT
ORDER BY
in simple queries
specifying result columns
order of evaluation
of elements in an expression
orphaned log files
wrapperDBE
orphaned privilege
providing a parent
outer join
defined
syntax
using UNION operator
OUTPUT_DEVICE
OUTPUT_NAME
overflow
in expression
of data
owner
authorization group
changing
class
how to become one
individuals
of modules
of system section tables
of system tables
privileges
use of name
who can be one
owner names
origin of
rules governing
specification of
use of
ownership
and dropping authorization groups
creating objects
how it is assigned
of objects
transferring
P
page buffers
flushing
page level locking
pages
deadlocks
in DBEFiles
in TempSpaces
PARALLEL FILL option
setting in BEGIN WORK
setting in SET SESSION
parameter
in procedures
naming rules
using in procedures
partition
creating
dropping
instance
setting with ALTER TABLE
understanding
Pascal preprocessor
defined
pattern matching
in LIKE predicate
performance
in procedures and rules
precision
defined
in DECIMAL operations
predicates
BETWEEN
COMPARISON
compatible data types in
definition of
EXISTS predicate
IN predicate
in search condition
LIKE predicate
NULL predicates
null values in
order of evaluation of
quantified predicate
PREPARE
statements that cannot be prepared
syntax
preparing statements
interactively and programmatically
preprocessor
defined
tasks
preserving authorization
and DROP MODULE
primary
in an expression
pages
PRIMARY KEY
in ALTER TABLE
in CREATE TABLE
PRINT
in procedures
priority
setting in SET SESSION
setting in SET TRANSACTION
private
locking
PRIVATE tables
in CREATE TABLE
locking mode
privilege
defined
grantable
procedure
and transaction management
Assignment
BEGIN
built-in variables in
caller recommended practices
checkpoint host variable
coding practices
comments within
control flow statements in
control language
creating
defined
executing
explained
GOTO in control language
local variables in
parameters in
PRINT statement
queries in
RAISE ERROR
recommended practices
result set
RETURN
rule and non-rule invocation
runtime errors
SELECT in
specifying in DECLARE CURSOR
using DECLARE Variable in
using with rules
validating
with multiple row sets
with single format multiple row sets
procedure cursor
authorization in CREATE PROCEDURE
defined
in ISQL
parameters in
query types
procedure names
in GRANT
in REVOKE
procedures and rules
chains of
using
programmatic database access
defined
programs
effect of DBEnvironment changes on
PUBLIC
special name
PUBLICREAD tables
in CREATE TABLE
locking mode
PUBLICROW tables
in CREATE TABLE
locking mode
PUBLIC tables
in CREATE TABLE
in GRANT
locking mode
purging DBEFiles
using DROP DBEFILE
Q
quantified predicate
explained
syntax
queries
available with a procedure cursor
defined
displaying access plan
in procedures
range of complex types
simple types
updatable
query
block in SELECT
blocks in expression
complex
expression
expression in SELECT
file space used
modifying access plan
processor defined
result defined
results
syntax (SELECT)
R
RAISE ERROR
in procedures
in procedures invoked by rules
syntax
RC isolation level
explained
in SET SESSION
in SET TRANSACTION
read committed isolation level
in BEGIN WORK
in SET SESSION
in SET TRANSACTION
read committed (RC)
explained
read uncommitted isolation level
in BEGIN WORK
in SET SESSION
in SET TRANSACTION
read uncommitted (RU)
explained
REAL
conversions rules
data type defined
storage requirements
real values
in constants
recovery
rollback
referenced table
defined
referencing table
defined
referential constraint
deferred error checking
defined
in ALTER TABLE
in CREATE TABLE
revoking
slowing TRUNCATE TABLE
referential integrity
using constraints
REFETCH
syntax
relation
defined
relational database
defined
release
DBE session
in COMMIT WORK
RELEASE
syntax
remote connections
establishment of
REMOVE DBEFile
syntax
REMOVE FROM GROUP
syntax
removing DBEFiles
RENAME COLUMN
syntax
RENAME TABLE
syntax
renaming
columns
tables
repeatable read isolation level
in BEGIN WORK
in SET SESSION
in SET TRANSACTION
repeatable read (RR)
explained
RESET
syntax
resetting ALLBASE/SQL system data
result
table defined
result columns
in SELECT
retrieving
data
rows
RETURN
syntax
return status
in DECLARE CURSOR:specifying
revalidating rows
REVOKE
and CASCADE
and grantable privilege
syntax
revoking
authorities using REVOKE
DBEFileSet authority
grants using CASCADE
right outer join
defined
RIGHT OUTER JOIN
in SELECT
rollback
recovery
ROLLBACK WORK
ROLLBACK WORK
in a procedure
syntax
roll forward
wrapperDBE
row level
DML atomicity
DML atomicity logging
locking
rows
defined
fetching
inserting
joining
selecting
RR isolation level
explained
in SET SESSION
in SET TRANSACTION
RU isolation level
explained
in SET SESSION
in SET TRANSACTION
rule
and transaction management
creating
defined
differences from integrity constraints
enabling and disabling
explained
techniques for using procedures with
rules and procedures
chains of
CREATE PROCEDURE statement
CREATE RULE statement
DISABLE RULES statement
DROP PROCEDURE statement
DROP RULE statement
ENABLE RULES statement
TRUNCATE TABLE statement
using
RUN authority
granting
purpose
revoking
run block
in START DBE
in START DBE NEWLOG
runtime control block pages
in START DBE
in START DBE NEW
in START DBE NEWLOG
runtime errors
in a procedure
S
sample DBEnvironment
SAVEPOINT
in a procedure
setting
syntax
using
scale
defined
in DECIMAL operations
scoping
transaction and session attributes
search condition
compatible predicates
defined
definition
in complex queries
in DELETE
subquery in
syntax
type conversion in
use for
value extensions in
SearchCondition
in CREATE TABLE
section
authorization in PREPARE
defined
invalidation by TRUNCATE TABLE
invalidation through procedures
semi-permanent
validating
section audit element
in START DBE NEW
in START DBE NEWLOG
SECTIONSPACE
authorization in CREATE RULE
security
of database
SELECT
displaying access plan
in CREATE VIEW
in DECLARE CURSOR
in procedures
syntax
use of
with cursor in procedures
select cursor
authorization in CREATE PROCEDURE
defined
within a procedure
selecting data
discussed
grouping rows
maximum columns
null values
SELECT
unique rows
select list
defined
semi-permanent section
creating with PREPARE
owner
SEMIPREM owner
serializable isolation level
in SET SESSION
in SET TRANSACTION
session
DBE
SET CONNECTION
syntax
SET CONSTRAINTS
syntax
set constraint type statement
explained
SET DEFAULT DBEFILESET
syntax
SET DML ATOMICITY
syntax
SET MULTITRANSACTION
explained
syntax
SETOPT
syntax
validating modules
SET PRINTRULES
syntax
SET PRINTRULES ON
to trace rule chaining
SET SESSION
CS isolation level
cursor stability isolation level
RC isolation level
read committed isolation level
read uncommitted isolation level
repeatable read isolation level
RR isolation level
RU isolation level
serializable isolation level
syntax
setting
constraint checking with SET SESSION
constraint checking with SET TRANSACTION
constraints to deferred
current connection
default DBEFileSet
DML atomicity
multiple-transaction mode
options with BEGIN WORK
savepoints
the current connection
the FILL option
timeout values
transaction mode
setting DML atomicity
setting DML ATOMICITY
with SET SESSION
with SET TRANSACTION
setting transaction attributes
with SET SESSION
with SET TRANSACTION
SET TRANSACTION
CS isolation level
cursor stability isolation level
RC isolation level
read committed isolation level
read uncommitted isolation level
repeatable read isolation level
RR isolation level
RU isolation level
serializable isolation level
syntax
SET USER TIMEOUT
syntax
share
intention exclusive lock
lock defined
share mode
locking
SHARE mode
in LOCK TABLE
SHARE UPDATE mode
in LOCK TABLE
simple names
defined
simultaneous transactions
with BEGIN WORK
single-transaction mode
explained
in SET MULTITRANSACTION
single-user mode
defined
in a DBE session
SIX lock
explained
SIX (SHARE INTENT EXCLUSIVE) locks
S lock
explained
SMALLINT
conversions rules
defined
storage requirements
SOME
in quantified predicate
sorting
using TempSpace
space management
for tables and indexes
in CREATE DBEFILESET
special
authorities revoking
names
special predicates
EXISTS predicate
IN predicate
quantified predicate
SQL
defined
language structure
naming rules
usage
SQLAudit
auditing transactions
defined
SQLCA
INCLUDE SQLCA
used with SQLEXPLAIN
used with WHENEVER
SQLCheck
defined
SQLDA
INCLUDE SQLDA
used with FETCH
SQLEXPLAIN
on returning from procedures
syntax
SQLGEN
defined
SQLMigrate
defined
SQLMON
authority
defined
grant authority to run
monitoring locking
monitoring transactions
revoke authority to run
SQL statement
ADD DBEFile
ADD TO GROUP
ADVANCE
ALTER DBEFILE
ALTER TABLE
Assignment
BEGIN
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN WORK
BULK FETCH
BULK INSERT
BULK SELECT
CHECKPOINT
CLOSE
COMMIT ARCHIVE
COMMIT WORK
CONNECT
CREATE DBEFILE
CREATE DBEFILESET
CREATE GROUP
CREATE INDEX
CREATE PARTITION
CREATE PROCEDURE
CREATE RULE
CREATE SCHEMA
CREATE TABLE
CREATE TEMPSPACE
CREATE VIEW
DECLARE CURSOR
DECLARE Variable
DELETE
DELETE WHERE CURRENT
DESCRIBE
DISABLE AUDIT LOGGING
DISABLE RULES
DISCONNECT
DROP DBEFILE
DROP DBEFILESET
DROP GROUP
DROP INDEX
DROP MODULE
DROP PARTITION
DROP PROCEDURE
DROP RULE
DROP TABLE
DROP TEMPSPACE
DROP VIEW
ENABLE AUDIT LOGGING
ENABLE RULES
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
GENPLAN
GOTO
GRANT
GRANT ON DBEFILESET
IF
INCLUDE
INSERT
Labeled Statement
length
LOCK TABLE
LOG COMMENT
OPEN
PREPARE
PRINT
RAISE ERROR
REFETCH
RELEASE
REMOVE DBEFILE
REMOVE FROM GROUP
RENAME COLUMN
RENAME TABLE
RESET
RETURN
REVOKE
ROLLBACK WORK
SAVEPOINT
SELECT
SET CONNECTION
SET CONSTRAINTS
SET DEFAULT DBEFILESET
SET DML ATOMICITY
SET MULTITRANSACTION
SETOPT
SET PRINTRULES
SET SESSION
SET TRANSACTION
SET USER TIMEOUT
SQLEXPLAIN
START DBE
START DBE NEW
START DBE NEWLOG
STOP DBE
summary table
syntax summary
TERMINATE QUERY
TERMINATE TRANSACTION
TERMINATE USER
TRANSFER OWNERSHIP
TRUNCATE TABLE
UPDATE
UPDATE STATISTICS
UPDATE WHERE CURRENT
VALIDATE
WHENEVER
WHILE
SQL statements
categories
within procedures
SQLUtil
defined
setting transaction limits
wrapdbe command
SQLVer
defined
S (SHARE) locks
standards flagging support
START DBE
syntax
START DBE NEW
syntax
START DBE NEWLOG
syntax
starting a DBE session
using CONNECT
using START DBE
startup parameters
defined in START DBE NEW
in START DBE NEW
statement level
constraint error checking
DML atomicity
error enforcement explained
STOP DBE
syntax
stopping
ALLBASE/SQL using STOP DBE
session using DISCONNECT
storage allocation
defined
storage audit element
in START DBE NEW
in START DBE NEWLOG
Storage Manager
defined
storage requirements
for specific data types
stored modules
and DROP MODULE
STOREDSECT
owner of system section tables
string
constants in constant
functions arguments in
functions syntax
value in constants
STRING_LENTH
in string functions
Structured Query Language
defined
subquery
as part of a predicate
correlated
defined
in an EXISTS predicate
in an IN predicate
in a quantified predicate
SUBSTRING
in string functions
SUM
defined
syntax
switching transactions
and MULTITRANSACTION
symmetric outer join
and UNION
defined
using UNION operator
syntax summary
ISQL
SQL statements
SYSTEM
as owner
owner of system views
table locking
view names in UPDATE STATISTICS
SYSTEM.ACCOUNT
resetting
system catalog
contents
defined
system tables
system views
table of system views
updating statistics
SYSTEM.COLUMN
updating statistics for
SYSTEM.COUNTER
resetting
SYSTEM.DBEFILE
updating statistics for
SYSTEM.DBEFILESET
updating statistics for
system DBEFileset
defined
SYSTEM.INDEX
updating statistics for
SYSTEM.SECTION
validating modules
SYSTEM.TABLE
monitoring for table size
updating statistics for
system views
summary of
T
table
adding constraint to
allocating storage for
and check constraints
changing locking
creating
defined
defining default columns in
deleting all rows from
dropping
dropping constraint from
explicit locking
granting authorities
implicit locking
inserting rows into
locking
locking explained
referenced
referencing
revoking authorities
updating statistics
TABLE DBEFiles
table names
in ALTER TABLE
in CREATE INDEX
in CREATE TABLE
in DELETE
in DELETE WHERE CURRENT
in DROP INDEX
in DROP TABLE
in GRANT
in INSERT
in LOCK TABLE
in REVOKE
in TRANSFER OWNERSHIP
in TRUNCATE TABLE
in UPDATE statements
in UPDATE STATISTICS
in UPDATE WHERE CURRENT
rules for
TableSpec
in SELECT
TEMP
and modules not stored
owner of modules
temporary section
validating
TempSpace
defined
dropping
names in CREATE TEMPSPACE
names in DROP TEMPSPACE
using
TERMINATE QUERY
syntax
TERMINATE TRANSACTION
syntax
TERMINATE USER
syntax
terminating
a DBE session
transactions
TERMINATION LEVEL
setting with SET SESSION
setting with SET TRANSACTION
THEN
in procedures
TID function
syntax
TIME
conversions rules
defined
operations with values
storage requirements
values in arithmetic expression
timeout
and BEGIN WORK
and lock waits
SET SESSION statement
SET TRANSACTION statement
SET USER TIMEOUT statement
START DBE NEWLOG
value setting
values in DBECon file
TO_CHAR function
syntax
TO_DATE function
syntax
TO_DATETIME function
syntax
TO_INTEGER function
syntax
TO_INTERVAL function
syntax
TO_TIME function
syntax
transaction attributes
setting in BEGIN WORK
setting in SET SESSION
setting in SET TRANSACTION
transactions
aborted
and data consistency
and multiple connections
and recovery
and timeouts
automatic rollback of
committing
defined
effect of terminating
errors in level constraint checking
implicit vs. explicit
in a procedure
in a procedure invoked by a rule
in START DBE NEW
locks released
management
maximum in START DBE
maximum in START DBE NEWLOG
mode setting
priority
SET USER TIMEOUT
simultaneous with BEGIN WORK
statements that must be in the same
terminating
TRANSFER OWNERSHIP
syntax
transferring ownership
when dropping authorization group
TRUNCATE TABLE
syntax
truncation
and native language data
in aggregate functions
in expressions
of data
tuple
defined
type conversion
and overflow
and truncation
defined
in aggregate functions
in COMPARISON predicates
in expressions
in search conditions
U
UDCs
use with ALLBASE/SQL
underflow
defined
in expression
undetectable deadlock
in multi-transaction mode
UNION
and outer join
character constants with
in outer joins
in queries
in SELECT
UNION ALL form
unique
column values DISTINCT
indexes
rows
unique constraint
defined
in ALTER TABLE
in CREATE TABLE
updatability
of cursors
of views
rules
UPDATE
displaying access plan
statement type in rules
syntax
UPDATE STATISTICS
syntax
validating modules
UPDATE WHERE CURRENT
syntax
updating
data
system catalog statistics
USER expression value
expressions
IN predicate
user mode
defined
in CONNECT
user table locking
explained
user timeout value
in SET SESSION
in SET TRANSACTION
in START DBE
in START DBE NEW
in START DBE NEWLOG
using ALLBASE/SQL
ad hoc queries
application programming
database administration
using SQL
summarized
V
VALIDATE
syntax
validity checking
of data
of databases
value
comparisons
extensions in search conditions
VARBINARY
conversions rules
long data type defined
storage requirements
VARCHAR
conversions rules
defined
storage requirements
variable-length strings
defined
variables
BEGIN DECLARE SECTION
END DECLARE SECTION
indicator
input
output
verb
defined
view names
in CREATE VIEW
in DELETE
in DELETE WHERE CURRENT
in DROP TABLE
in DROP VIEW
in INSERT
in REVOKE
in TRANSFER OWNERSHIP
in UPDATE
in UPDATE WHERE CURRENT
rules for
views
and check constraints
base tables
creating
defined
dropping
granting authorities
inserting data
restrictions in using
revoking authorities
updatability of
updatable
uses for
WITH CHECK OPTION
volume specification
creating DBEFile
W
WHENEVER
in procedures
syntax
WHERE
and joins
in SELECT
in simple queries
WHILE
syntax
WITH CHECK OPTION
in CREATE VIEW
view
WITH GRANT OPTION
explained
syntax in GRANT
wrapdbe command
wrapperDBE
wrapperDBE
archive logging
audit information
definition
roll forward
wrapdbe command
writer of a procedure
recommended practices
X
X (EXCLUSIVE) locks
explained