HPlogo ALLBASE/SQL Reference Manual: HP 3000 MPE/iX Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

A

access plan
defined, GENPLAN
modifying with SETOPT, SETOPT
access to databases
multiple connections, Using Multiple Connections and Transactions with Timeouts
types, ALLBASE/SQL Components
active connection
defined, Disconnecting from DBEnvironments
active set
in DECLARE CURSOR, Description
in FETCH, FETCH
in OPEN, OPEN
in REFETCH, REFETCH
actual parameter
using in procedures, Specifying Parameters
ADD DBEFILE
syntax, ADD DBEFILE
ADD TO GROUP
syntax, ADD TO GROUP
ADD_MONTHS
in an expression , Expression
syntax, Add Months Function
adding
ADD TO GROUP, ADD TO GROUP
column to table, ALTER TABLE
constraint to table, ALTER TABLE
DBEFiles, ADD DBEFILE
members to authorization group, ADD TO GROUP
rows, Inserting Data, INSERT
ADVANCE
syntax, ADVANCE
aggregate functions
arguments in, Aggregate Functions
DECIMAL arguments, Description
in an expression , Expression
in NULL predicates, NULL Predicate
syntax, Aggregate Functions
truncation, Description
type conversion, Description
ALL
in aggregate function, Parameters
in quantified predicate, Quantified Predicate
in SELECT, Parameters--Query Block Level
all audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
ALLBASE/SQL
components, ALLBASE/SQL Components
data types, Data Types
definition, Introduction
message catalog, SQLEXPLAIN
names, Names
users, ALLBASE/SQL Users
allocating file space
in CREATE DBEFILESET, CREATE DBEFILESET
ALTER DBEFile
syntax, ALTER DBEFILE
ALTER TABLE
syntax, ALTER TABLE
to change table locking, ALTER TABLE
to set audit partition, ALTER TABLE
altering
DBEFile type, ALTER DBEFILE
tables, ALTER TABLE
ANSI standards, Standards Flagging Support
ANY
in quantified predicate, Quantified Predicate
application programming
and SQL statements, Application Programming
archive logging
wrapperDBE, Using Wrapper DBEnvironments
archive mode
definition, Description
use of BEGIN ARCHIVE, BEGIN ARCHIVE
use of COMMIT ARCHIVE, COMMIT ARCHIVE
archive record
use of COMMIT ARCHIVE, COMMIT ARCHIVE
arithmetic operators
in an expression , Expression
Assignment
syntax, Assignment (=)
asymmetric outer join
defined, Outer Joins Using Explicit JOIN syntax
atomicity
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
audit
DBE understanding, Partitions in Audit DBEnvironments
disabling logging, DISABLE AUDIT LOGGING
elements default, Auditing DBEnvironments
elements understanding, Auditing DBEnvironments
enabling logging, ENABLE AUDIT LOGGING
functionality definition, Auditing DBEnvironments
information wrapperDBE, Using Wrapper DBEnvironments
log record, Auditing DBEnvironments
partition with ALTER TABLE, ALTER TABLE
tool, Using Wrapper DBEnvironments
transactions with SQLAudit, Using SQLAudit
AUDIT NAME
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
authorities
and program development, Authorization
and program use, Authorization
defined, Logical Concepts
direct, Parameters—Grant Table or View Authority
granting, Grants, GRANT
granting on DBEFileSET, SQL Syntax—Grant DBEFileSet Authority
how to obtain, Controlling Database Access
OWNER, Controlling Database Access
REFERENCES, Controlling Database Access
revoking, Grants, REVOKE
RUN, Controlling Database Access
summary of types, Controlling Database Access
table and view, Controlling Database Access
authorization
audit element in START DBE NEWLOG, START DBE NEWLOG
check constraint in ALTER TABLE, Authorization
check constraint in CREATE TABLE, Authorization
DBEFileSet in CREATE PROCEDURE, Authorization, CREATE TABLE, Authorization
DBEFileSet in CREATE VIEW, Authorization
DBEFileSet in PREPARE, Description
DBEFileSet in REVOKE, Description—Revoke DBEFileSet Authority
for a procedure cursor, Authorization
for a select cursor, Authorization
in START DBE NEW, START DBE NEW
long column in ALTER TABLE, Authorization
long column in CREATE TABLE, Authorization
name, Authorization Names
section in PREPARE, Authorization
SECTIONSPACE in CREATE RULE, Description
authorization groups
adding members to, ADD TO GROUP
advantages of, Authorization Groups
creating, CREATE GROUP
dropping, DROP GROUP
removing members from, REMOVE FROM GROUP
use of, Authorization Groups
AUTOCOMMIT
DELETE parameter , Parameters
VALIDATE parameter, VALIDATE
automatic locking modes
in CREATE TABLE, Creating a Table
autostart
and CONNECT, CONNECT
mode, Description
average
in aggregate function, Aggregate Functions
AVG
syntax, Aggregate Functions

B

base table
defined, Creating a View
basic names
objects having, Names
rules governing, Names
BEGIN
syntax, BEGIN
BEGIN ARCHIVE
syntax, BEGIN ARCHIVE
BEGIN DECLARE SECTION
syntax, BEGIN DECLARE SECTION
BEGIN WORK
and MULTITRANSACTION, SET MULTITRANSACTION
cursor stability isolation level, Parameters
in a procedure, Procedures and Transaction Management
read committed isolation level, Parameters
read uncommitted isolation level, Parameters
repeatable read isolation level, Parameters
syntax, BEGIN WORK
BETWEEN predicate
in search condition, Search Condition
syntax, BETWEEN Predicate
BINARY
conversions rules, Description--Query Expression Level
long data type defined, Type Specifications
storage requirements, Type Specifications
built-in variable
differences from local variables, Using Built-in Variables in Procedures
similar to SQLCA elements, Using Built-in Variables in Procedures
using in procedures, Using Built-in Variables in Procedures
BULK operations
FETCH, FETCH
INSERT, INSERT
SELECT, SELECT
use of, Multiple-Row Manipulations
BY
syntax, Parameters—Grant Table or View Authority

C

C preprocessor
defined, ALLBASE/SQL Components
caller of a procedure
recommended practices for, Recommended Coding Practices for Procedures
Cartesian product
defined, Simple Queries
in SELECT, Description--Query Block Level
CASCADE
explained, Grantable Privileges
syntax, Parameters—Revoke Table or View Authority
case sensitive
comparison predicate, Description
comparisons, Value Comparisons
CAST function
arguments in, CAST Function
syntax, CAST Function
CATALOG
owner of catalog views, Special Names
catalog views
explained, Understanding the System Catalog
chain
of grants, Grantable Privileges
of rules, Using a Chained Set of Procedures and Rules, Effects of Rule Chaining
changing
connections, SET MULTITRANSACTION
data, Updating Data
DBEFile type, ALTER DBEFILE
table locking , ALTER TABLE
CHAR
conversions rules, Description--Query Expression Level
defined, Type Specifications
native language data, Native Language Data
storage requirements, Type Specifications
check constraint
authorization in ALTER TABLE, Authorization
authorization in CREATE TABLE, Authorization
defined, Specifying Integrity Constraints, Check Constraints
in a view, Check Constraints
in ALTER TABLE, ALTER TABLE
in CREATE TABLE, CREATE TABLE, Parameters--Column Definition, SQL Syntax--Check Constraint (Table Level)
search condition, Check Constraints
CHECKPOINT
record, CHECKPOINT
syntax, CHECKPOINT
use of, CHECKPOINT
checkpoint for STOP DBE, STOP DBE
class names
in REVOKE, SQL Syntax—Revoke Table or View Authority, SQL Syntax—Revoke RUN or EXECUTE or Authority, SQL Syntax—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority, SQL Syntax—Revoke DBEFileSet Authority
rules for, Names
classes
creating, Classes
use of, Classes
clause
defined, SQL Language Structure
CLOSE
syntax, CLOSE
closing cursors, CLOSE
clustered indexes, CREATE INDEX
COBOL preprocessor
defined, ALLBASE/SQL Components
MICROFOCUS, ALLBASE/SQL Components
coding practices
for procedures, Recommended Coding Practices for Procedures
column names
in ALTER TABLE, ALTER TABLE
in an expression , Expression
in CREATE INDEX, CREATE INDEX
in CREATE TABLE, SQL Syntax--Column Definition
in CREATE VIEW, CREATE VIEW
in INSERT, INSERT
in null predicates, NULL Predicate
rules for, Names
columns
adding to tables, ALTER TABLE
and Cartesian product, Description--Query Block Level
common columns in join, Description--Query Block Level
defined, Logical Concepts
defining, Parameters--CREATE TABLE
definition, Defining the Columns
maximum allowed in tables, SQL Syntax--Column Definition
maximum allowed in views, CREATE VIEW
order of display, Description--Query Block Level
comment audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
comment initiator
within SQL statements, Using Comments within SQL Statements
comment partition
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
COMMIT ARCHIVE
syntax, COMMIT ARCHIVE
COMMIT WORK
in a procedure, Procedures and Transaction Management
syntax, COMMIT WORK
common columns
in SELECT, Description--Query Block Level
COMPARISON predicate
character collation sequence, Description
in search condition, Search Condition
operators, Comparison Predicate
syntax, Comparison Predicate
type conversion in, Description
complex queries
defined, Complex Queries
range of types, Complex Queries
compound identifiers
in names, DBEUserIDs
concatenate
data types, Description
strings, Parameters
concurrency
and table size, Lock Granularities
control, Concurrency Control through Locks and Isolation Levels
configuring a DBEnvironment
in START DBE NEW, START DBE NEW
summarized, Creating DBEnvironments
CONNECT
syntax, CONNECT
transactions , Description
connection
and SET CONNECTION, SET CONNECTION
changing, SET MULTITRANSACTION
disconnecting, DISCONNECT
initiating, CONNECT
terminating, Disconnecting from DBEnvironments
to DBEnvironments, Connecting to DBEnvironments
use with timeouts, Using Multiple Connections and Transactions with Timeouts
connection name
in CONNECT, CONNECT
in SET CONNECTION, SET CONNECTION
in START DBE, START DBE
in START DBE NEWLOG, START DBE NEWLOG
CONSTANT
syntax, Scope
constant
defined, Scope
in an expression , Expression
in NULL predicates, NULL Predicate
constraint
check constraint, Specifying Integrity Constraints, Using Integrity Constraints
defined, Constraints, Procedures, and Rules
defining, CREATE TABLE
error checking and SET statement, SET CONSTRAINTS
error checking in SET SESSION, SET SESSION
error checking in SET TRANSACTION, SET TRANSACTION
example, Examples of Integrity Constraints
constraint checking
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
control block
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
control flow statements
in procedures, Using SQL Statements in Procedures
RETURN, RETURN
control language
GOTO in procedures, GOTO
in procedures, IF, WHILE
controlling
error checking level, SET DML ATOMICITY
conversion functions
syntax, Date/Time Functions
conversion rules
data in query expressions, Description--Query Expression Level
converting
data types, CAST Function
copying rows
to tables and views, Inserting Data
correlated subquery
explained, Correlated Versus Noncorrelated Subqueries
correlation names
in SELECT, Description--Query Block Level
COUNT
syntax, Aggregate Functions
CREATE DBEFILE
syntax, CREATE DBEFILE
CREATE DBEFILESET
syntax, CREATE DBEFILESET
CREATE GROUP
syntax, CREATE GROUP
CREATE INDEX
syntax, CREATE INDEX
CREATE PARTITION
syntax, CREATE PARTITION
CREATE PROCEDURE
explained, Understanding Procedures
syntax, CREATE PROCEDURE
CREATE RULE
invoking a procedure through, Executing Procedures
syntax, CREATE RULE
using, Creating Rules
CREATE SCHEMA
syntax, CREATE SCHEMA
CREATE TABLE
LANG = clause, Specifying Native Language Tables and Columns
syntax, CREATE TABLE
CREATE TEMPSPACE
syntax, CREATE TEMPSPACE
CREATE VIEW
syntax, CREATE VIEW
creating
audit DBE, Partitions in Audit DBEnvironments
authorization groups, CREATE GROUP
constraints, CREATE TABLE
databases, Creating DBEnvironments
DBEFile, CREATE DBEFILE
DBEFile volume specification, CREATE DBEFILE
DBEFileSets, CREATE DBEFILESET
DBEnvironments, Creating DBEnvironments, START DBE NEW
indexes, CREATE INDEX
partition, Partitions in Audit DBEnvironments, CREATE PARTITION
tables, CREATE TABLE
TempSpace, CREATE TEMPSPACE
views, CREATE VIEW
CS isolation level
explained, Cursor Stability (CS)
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
current
function in an expression , Expression
function syntax, Current Functions
language defined, Native Language Support
row in FETCH, FETCH
row in REFETCH, REFETCH
timeout value in multi-transaction, Setting the Transaction Mode
current connection
in CONNECT, CONNECT
none after DISCONNECT CURRENT, Disconnecting from DBEnvironments
setting, Setting the Current Connection
CURRENT_DATE function
syntax, Current Functions
CURRENT_DATETIME function
syntax, Current Functions
CURRENT_TIME function
syntax, Current Functions
cursor names
in CLOSE, CLOSE
in DECLARE CURSOR, DECLARE CURSOR
in DELETE WHERE CURRENT, DELETE WHERE CURRENT
in FETCH, FETCH
in OPEN, OPEN
in UPDATE WHERE CURRENT statement, UPDATE WHERE CURRENT
rules for, Names
cursor stability (CS)
explained, Cursor Stability (CS)
cursor stability isolation level
in BEGIN WORK, Parameters
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
cursors
active set, FETCH, REFETCH
advancing, ADVANCE
and INTO clause, Parameters--Query Block Level
closed, STOP DBE
closing, CLOSE, RELEASE, ROLLBACK WORK
current row, FETCH, REFETCH
declaring, DECLARE CURSOR
deleting rows with, Description, DELETE WHERE CURRENT
in procedures, Using a Select Cursor
opening, OPEN
procedure cursor parameters in, Specifying Parameters
retrieving rows with, Description, FETCH, REFETCH
updatability of, Description
updating data with, DECLARE CURSOR, Description
use of, Multiple-Row Manipulations, DECLARE CURSOR
using in procedures, Using a Single Procedure with Cursors
using multiple, OPEN
cycle
in chain of grants, Grantable Privileges

D

data
access, ALLBASE/SQL Data Access, Controlling Database Access
in native languages, Native Language Data
manipulation, SQL Queries
data audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
data buffer pages
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
data definition statements
in procedures, Invalidation of Sections
data types
comparisons between, Value Comparisons
conversion, Type Conversion
converting, CAST Function
effect of, Data Types
in CREATE TABLE, Description
of column added to existing table, ALTER TABLE
of columns in joins, Description--Query Block Level
rules governing, Data Types
table of, Type Specifications
valid combinations, Type Conversion
database
administration activities, Administering a Database
administrator defined, ALLBASE/SQL Users
control of access to, Controlling Database Access
creation, Creating DBEnvironments
creation (CREATE SCHEMA), CREATE SCHEMA
logical definition, Logical Concepts
physical definition, Physical Concepts
statistics, Understanding the System Catalog
DATE
conversions rules, Description--Query Expression Level
defined, ALLBASE/SQL Data Types
operations with values, Date/Time Operations
storage requirements, Type Specifications
values in arithmetic expression, Use of Date/Time Data Types in Arithmetic Expressions
date/time conversion functions
in an expression , Expression
syntax, Date/Time Functions
DATETIME
conversions rules, Description--Query Expression Level
defined, ALLBASE/SQL Data Types
operations with values, Date/Time Operations
storage requirements, Type Specifications
values in arithmetic expressions, Use of Date/Time Data Types in Arithmetic Expressions
DBA
automatic grant of authority, DBA Authority
defined, ALLBASE/SQL Users
statements authorized to use, DBA Authority
DBE sessions
and autostart mode, Starting and Terminating a DBE Session
defined, ALLBASE/SQL Data Access
multiuser, Starting and Terminating a DBE Session
setting the current connection, SET CONNECTION
single-user, Starting and Terminating a DBE Session
starting, Starting and Terminating a DBE Session, CONNECT, START DBE
terminating, Starting and Terminating a DBE Session, RELEASE, TERMINATE QUERY, TERMINATE USER
DBECon file
creation, START DBE NEW
defined, Physical Concepts
naming conventions, DBEnvironment and DBECon File Names
overriding parameters, START DBE
parameters, Description
DBECreator
authorization, DBA Authority
defined, Initial Privileges
statements authorized to use, DBA Authority
DBEFile names
group name, CREATE DBEFILE
in ADD DBEFile, ADD DBEFILE
in ALTER DBEFile, ALTER DBEFILE
in CREATE DBEFILE, CREATE DBEFILE
in DROP DBEFILE, DROP DBEFILE
in REMOVE DBEFile, REMOVE DBEFILE
rules for, Names
DBEFile type
in ALTER DBEFile, ALTER DBEFILE
in CREATE DBEFILE, CREATE DBEFILE
DBEFile0
defined, Physical Concepts
naming, SQL Syntax--DBEFile0Definition
DBEFiles
adding, ADD DBEFILE
altering type of, ALTER DBEFILE
creating, CREATE DBEFILE
defined, Physical Concepts
dropping, DROP DBEFILE, REMOVE DBEFILE
for data, Physical Concepts
for indexes, Physical Concepts
incrementing size, CREATE DBEFILE
purging, DROP DBEFILE
relation to DBEFileset, Physical Concepts
removing from DBEFileSet, DROP DBEFILE, DROP DBEFILESET, REMOVE DBEFILE
size range, CREATE DBEFILE
type, CREATE DBEFILE
using, CREATE DBEFILE
DBEFileSet
authorization in CREATE PROCEDURE, Authorization, CREATE TABLE, Authorization
authorization in CREATE VIEW, Authorization
authorization in PREPARE, Description
authorization in REVOKE, Description—Revoke DBEFileSet Authority
creating, CREATE DBEFILESET
defined, Physical Concepts
dropping, DROP DBEFILESET
dropping default, Description
dynamic section, Description
dynamic statement, Description
for a check constraint, CREATE TABLE
for a long column, CREATE TABLE
for a table, CREATE TABLE
in DECLARE CURSOR, DECLARE CURSOR
relation to DBEFiles, Physical Concepts
revoking authority, SQL Syntax—Revoke DBEFileSet Authority
setting a default, SET DEFAULT DBEFILESET
specifying for a cursor, DECLARE CURSOR
specifying for a view, CREATE VIEW
DBEFileSet names
in ADD DBEFile, ADD DBEFILE
in CREATE TABLE, Description
in REMOVE DBEFile, REMOVE DBEFILE
rules for, Names
DBELog1
defined, Physical Concepts
DBELog2
defined, Physical Concepts
DBEnvironment
components, Physical Concepts
configuration, Creating DBEnvironments, START DBE NEW
connecting to, Connecting to DBEnvironments
creating, Creating DBEnvironments
creating audit, Partitions in Audit DBEnvironments
defined, Physical Concepts
disconnecting from, Disconnecting from DBEnvironments
initial privileges, Initial Privileges
naming conventions, DBEnvironment and DBECon File Names
obtaining information on, Understanding the System Catalog
startup parameters, Creating DBEnvironments
statistics, Understanding the System Catalog
DBEnvironment name
in CONNECT, CONNECT, SET CONNECTION
in DISCONNECT, DISCONNECT
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
DBEUserID
defined, DBEUserIDs
in ADD TO GROUP, ADD TO GROUP
in GRANT, SQL Syntax--Grant RUN or EXECUTE Authority
in REMOVE FROM GROUP, REMOVE FROM GROUP
in RESET, RESET
in REVOKE, SQL Syntax—Revoke Table or View Authority, SQL Syntax—Revoke RUN or EXECUTE or Authority, SQL Syntax—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority, SQL Syntax—Revoke DBEFileSet Authority
in TERMINATE QUERY, TERMINATE QUERY
in TERMINATE USER, TERMINATE USER
rules governing, DBEUserIDs
DDL Enabled flag
defined, Description
deadlock
avoidance of, Avoiding Deadlock
definition, Deadlocks
detection/resolution, Deadlocks
example, Deadlocks
in multi-transaction mode, Setting Timeout Values
DECIMAL
conversions rules, Description--Query Expression Level
defined, Type Specifications
in operations, Decimal Operations
storage requirements, Type Specifications
DECIMAL data type
arguments in aggregate functions, Description
DECLARE
and local variables in a procedure, Using Local Variables in Procedures
DECLARE CURSOR
syntax, DECLARE CURSOR
DECLARE Variable
syntax, DECLARE Variable
declaring
cursors, DECLARE CURSOR
host variables, BEGIN DECLARE SECTION, END DECLARE SECTION
local variables in a procedure, DECLARE Variable
default
columns in tables, ALTER TABLE
ownership discussed, Default Owner Rules
default DBEFileSet
dropping, Description
setting, SET DEFAULT DBEFILESET
default partition
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
deferred error checking
constraint (SET CONSTRAINTS), SET CONSTRAINTS
explained, How Constraints are Enforced
referential constraint, Inserting Rows in Tables Having Constraints
defining objects
authorization groups, CREATE GROUP
DBEFile, CREATE DBEFILE
DBEFileSets, CREATE DBEFILESET
DBEnvironments, START DBE NEW
default columns in tables, ALTER TABLE
tables, CREATE TABLE
TempSpace, CREATE TEMPSPACE
views, CREATE VIEW
definition
of a column, Parameters--CREATE TABLE
of audit functionality, Auditing DBEnvironments
procedure cursor, Queries inside Procedures
select cursor, Queries inside Procedures
wrapperDBE, Using Wrapper DBEnvironments
definition audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
DELETE
displaying access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
statement type in rules, Description, Description
syntax, DELETE
DELETE WHERE CURRENT
syntax, DELETE WHERE CURRENT
deleting
all rows from tables, TRUNCATE TABLE
authorization groups, DROP GROUP
data, Deleting Data
DBEFiles, DROP DBEFILE
DBEFileSets, DROP DBEFILESET
indexes, DROP INDEX, DROP TABLE
modules, DROP MODULE
rows, Deleting Data, DELETE
rows using a cursor, DELETE WHERE CURRENT
tables, DROP TABLE
TempSpaces, DROP TEMPSPACE
views, DROP TABLE, DROP VIEW
DESCRIBE
syntax, DESCRIBE
describing
dynamic statements, DESCRIBE
direct authority
explained, Parameters—Grant Table or View Authority
DISABLE AUDIT LOGGING
syntax, DISABLE AUDIT LOGGING
DISABLE RULES
syntax, DISABLE RULES
using, Enabling and Disabling Rules
disabling
audit logging, DISABLE AUDIT LOGGING
DISCONNECT
syntax, DISCONNECT
DISCONNECT CURRENT
no current connection following, Disconnecting from DBEnvironments
disconnecting
from DBEnvironments, Disconnecting from DBEnvironments
displaying
access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
DISTINCT
in aggregate function, Parameters
in SELECT, SELECT, Parameters--Query Block Level
DML ATOMICITY
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
DML atomicity
setting, SET DML ATOMICITY
DO
in procedures, WHILE
DROP DBEFILE
syntax, DROP DBEFILE
DROP DBEFILESET
syntax, DROP DBEFILESET
DROP GROUP
syntax, DROP GROUP
DROP INDEX
syntax, DROP INDEX
DROP MODULE
syntax, DROP MODULE
DROP PARTITION
syntax, DROP PARTITION
DROP PROCEDURE
syntax, DROP PROCEDURE
DROP RULE
syntax, DROP RULE
DROP TABLE
syntax, DROP TABLE
DROP TEMPSPACE
syntax, DROP TEMPSPACE
DROP VIEW
syntax, DROP VIEW
dropping
authorization groups, DROP GROUP
constraint, ALTER TABLE
DBEFiles, DROP DBEFILE, REMOVE DBEFILE
DBEFileSets, DROP DBEFILESET
indexes, DROP INDEX, DROP TABLE
modules, DROP MODULE
partition, DROP PARTITION
procedures, DROP PROCEDURE
rules, DROP RULE
tables, DROP TABLE
TempSpaces, DROP TEMPSPACE
views, DROP TABLE, DROP VIEW
dual logging, START DBE NEW
duplicate
column DISTINCT, Example
column values eliminated, Example
dynamic parameters
example of usage , Description
example with BULK INSERT, Examples
example with INSERT, Examples
in DECLARE CURSOR
specifying, Description
in EXECUTE PROCEDURE, EXECUTE PROCEDURE
syntax, SQL Syntax--DynamicParameterValues
dynamic preprocessing
defined, Preprocessor
DESCRIBE, DESCRIBE
EXECUTE, EXECUTE
EXECUTE IMMEDIATE, EXECUTE IMMEDIATE
EXECUTE PROCEDURE, EXECUTE PROCEDURE
PREPARE, PREPARE

E

ELSE
in procedures, IF
ELSEIF
in procedures, IF
embedding SQL statements
explained, Application Programming
ENABLE AUDIT LOGGING
syntax, ENABLE AUDIT LOGGING
ENABLE RULES
syntax, ENABLE RULES
using, Enabling and Disabling Rules
enabling
audit logging, ENABLE AUDIT LOGGING
END DECLARE SECTION
syntax, END DECLARE SECTION
ENDIF
in procedures, IF
ENDWHILE
in procedures, WHILE
error checking
explained, Error Conditions in ALLBASE/SQL
setting atomicity, SET DML ATOMICITY
transaction and statement constraints, SET CONSTRAINTS
using constraints, How Constraints are Enforced
error handling
4008, 4009, or -14024 or greater, Description
built-in variables, Parameters
error number and text, RAISE ERROR
in procedures invoked by rules, Error Handling in Procedures Invoked by Rules
in procedures not invoked by rules, Error Handling in Procedures Not Invoked by Rules
RAISE ERROR, RAISE ERROR
exclusive lock
defined, Types of Locks
EXCLUSIVE mode
in LOCK TABLE, LOCK TABLE
EXECUTE
syntax, EXECUTE
EXECUTE authority
granting, SQL Syntax--Grant RUN or EXECUTE Authority
revoking, SQL Syntax—Revoke RUN or EXECUTE or Authority
EXECUTE IMMEDIATE
statements that cannot be used with, EXECUTE IMMEDIATE
syntax, EXECUTE IMMEDIATE
EXECUTE PROCEDURE
in ISQL, Using a Procedure Cursor in ISQL
syntax, EXECUTE PROCEDURE
using, Executing Procedures
executing
a procedure, EXECUTE PROCEDURE
dynamic statements, EXECUTE, EXECUTE IMMEDIATE
EXISTS predicate
explained, EXISTS Predicate
syntax, EXISTS Predicate
explicit locking, LOCK TABLE
expression
and null values , Description
date/time, Add Months Function, Current Functions, Date/Time Functions
defined, Expressions
in aggregate function, Aggregate Functions
in BETWEEN predicate, BETWEEN Predicate
in COMPARISON predicate, Comparison Predicate
in constants, Scope
in EXISTS predicate, EXISTS Predicate
in IN predicate, IN Predicate
in LIKE predicate, LIKE Predicate
in long column function, Long Column Functions
in NULL predicates, NULL Predicate
in string function, String Functions
order of evaluation of elements in , Description
overflow , Description
syntax, Expression
truncation , Description
type conversion , Description
underflow , Description
use, Expressions
use of parentheses , Description
USER expression value, Parameters
extended characters
comparison prediate, Description

F

FETCH
syntax, FETCH
fetching rows, FETCH
file names
explained, DBEnvironment and DBECon File Names
file space management
for tables and indexes, Creating Physical Storage
FILL option
setting in BEGIN WORK, BEGIN WORK
setting in SET SESSION, SET SESSION
FIPS flagging support, Standards Flagging Support
fixed-length strings
defined, Type Specifications
fixed-point values
in constants, Scope
FLOAT
conversions rules, Description--Query Expression Level
defined, Type Specifications
storage requirements, Type Specifications
FORCE
VALIDATE parameter, VALIDATE
FOREIGN KEY
in CREATE TABLE, CREATE TABLE
formal parameter
using in procedures, Specifying Parameters
Fortran preprocessor
defined, ALLBASE/SQL Components
free log space
checkpoint host variable, CHECKPOINT
FROM
in simple queries, Using the SELECT Statement
FromSpec
in SELECT, HostVariableSpecification--Without BULK Option, SQL Syntax--FromSpec
fully qualified name, Compound Identifiers
functions
Add Months, Add Months Function
aggregate, Aggregate Functions
CAST function, CAST Function
current, Current Functions
date/time, Add Months Function, Date/Time Functions
long column, Long Column Functions
string functions, String Functions
TID, TID Function

G

generating
log comment, LOG COMMENT
GENPLAN
explained, Symmetric Outer Join Using the UNION Operator
syntax, GENPLAN
with SYSTEM and CATALOG views, Description
GOTO
in procedures, GOTO
syntax, GOTO
GRANT
MONITOR authority, MONITOR Authority
syntax, GRANT
WITH GRANT OPTION explained, Grantable Privileges
GRANT ON DBEFILESET
syntax, SQL Syntax—Grant DBEFileSet Authority
grantable privileges
explained, Grantable Privileges
revoking, Grantable Privileges
grants
automatic, CREATE TABLE
explicit (GRANT), SQL Syntax--Grant RUN or EXECUTE Authority
grantable privileges, Grantable Privileges
implicit (CREATE TABLE), CREATE TABLE
issuing, GRANT
issuing for DBEFileSet, SQL Syntax—Grant DBEFileSet Authority
revoking, REVOKE
which authorities can be granted, Grants
who can issue them, Grants
granularity
of locking, Types of Locks
GROUP BY
in SELECT, Parameters--Query Block Level
in simple queries, Using the SELECT Statement
group names
DBEFile name, CREATE DBEFILE
in ADD TO GROUP, ADD TO GROUP
in CREATE GROUP, CREATE GROUP
in REMOVE FROM GROUP, REMOVE FROM GROUP
in REVOKE, SQL Syntax—Revoke Table or View Authority, SQL Syntax—Revoke RUN or EXECUTE or Authority, SQL Syntax—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority, SQL Syntax—Revoke DBEFileSet Authority
in TRANSFER OWNERSHIP, TRANSFER OWNERSHIP
rules for, Names
grouping rows
in SELECT, Description--Query Block Level
groups
adding members to, ADD TO GROUP
creating, CREATE GROUP
dropping, DROP GROUP
in query result, Description--Query Block Level
removing members from, REMOVE FROM GROUP

H

hash
in CREATE TABLE, CREATE TABLE
specifying with SETOPT, SETOPT
HAVING
in SELECT, Parameters--Query Block Level
in simple queries, Using the SELECT Statement
hexadecimal string
in constants, Scope
host variables
declaration of, BEGIN DECLARE SECTION, END DECLARE SECTION
differences from local variables, Using Local Variables in Procedures
free log space, CHECKPOINT
in an expression , Expression
in CONNECT, CONNECT
in EXECUTE IMMEDIATE, EXECUTE IMMEDIATE
in FETCH, FETCH
in INSERT, SQL Syntax--SingleRowValues, Examples
in LIKE predicates, LIKE Predicate
in PREPARE, Description
in ROLLBACK WORK, ROLLBACK WORK
in SAVEPOINT, SAVEPOINT
in SELECT, SelectList
in SET CONNECTION, SET CONNECTION
in SQLEXPLAIN, SQLEXPLAIN
in UPDATE, UPDATE
in UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
input, Host Variables
naming rules, Host Variable Names
output, Host Variables
procedure parameter, CHECKPOINT
procedure value, CHECKPOINT
use of, Host Variables
HPODBSS
reserved owner name, Special Names
HPRDBSS
owner of system tables, Special Names
hyphen
as comment initiator, Using Comments within SQL Statements

I

IF
in procedures, IF
syntax, IF
IN predicate
explained, IN Predicate
syntax, IN Predicate
USER expression value, Parameters
INCLUDE
syntax, INCLUDE
incrementing
DBEFile size, CREATE DBEFILE
index
allocating storage for, Description
creating, Indexed Access, CREATE INDEX
defined, Indexed Access
dropping, DROP DBEFILE, DROP INDEX, DROP TABLE
duplicate keys, Description
locking explained, What Determines Lock Types
name in CREATE INDEX, CREATE INDEX
name in DROP INDEX, DROP INDEX
name rules for, Names
null values in, Description
number of keys in, CREATE INDEX
order of entries, Description
restrictions in using, Indexed Access
specifying with SETOPT, SETOPT
uses for, Indexed Access
INDEX DBEFiles, CREATE DBEFILE
indicator variables
example in predicates, Description
in expressions , Expression, Description
use of, Host Variables
INNER
in SELECT, Parameters--FromSpec
inner join
defined, Complex Queries, Outer Joins
syntax, Parameters--non-BULK HostVariableSpecification
INSERT
statement type in rules, Description--Insert Rows with SingleRowValues and BulkValues, Description--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
syntax, INSERT, SQL Syntax--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
use of, Inserting Data
inserting
rows in a table, Inserting Data
rows in INSERT, INSERT
values in constraint columns, Inserting Rows in Tables Having Constraints
instance of partition, Auditing DBEnvironments
INTEGER
conversions rules, Description--Query Expression Level
defined, Type Specifications
storage requirements, Type Specifications
integer values
in constants, Scope
integrity constraint
defined, Specifying Integrity Constraints, Using Integrity Constraints
example, Examples of Integrity Constraints
intention
exclusive lock, Types of Locks
share lock, Types of Locks
interactive database access
defined, ALLBASE/SQL Components
INTERVAL
conversions rules, Description--Query Expression Level
defined, ALLBASE/SQL Data Types
operations with values, Date/Time Operations
storage requirements, Type Specifications
values in arithmetic expressions, Use of Date/Time Data Types in Arithmetic Expressions
IS lock
explained, Types of Locks
isolation level
defined, Choice of Isolation Level
setting in BEGIN WORK, BEGIN WORK
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
ISQL
defined, ALLBASE/SQL Components
EXECUTE PROCEDURE in, Using a Procedure Cursor in ISQL
syntax summary, ISQL Syntax Summary
using to issue statements, Scoping of Transaction and Session Attributes
IX lock
explained, Types of Locks

K

keys
index, Description

L

label
in GOTO, GOTO
Labeled Statement, Labeled Statement
LANG = clause
for columns and tables, Specifying Native Language Tables and Columns
in ALTER TABLE, ALTER TABLE
in CREATE TABLE, Specifying Native Language Tables and Columns, CREATE TABLE
in START DBE NEW, Specifying a Native Language Parameter, START DBE NEW, Parameters--START DBE NEW
LANG variable
setting and resetting, Native Language Support
language
current language, Native Language Support
DBEnvironment and current, Specifying a Native Language Parameter
native language support, Native Language Support
setting and resetting, Native Language Support
LEFT JOIN
in SELECT, Description--Query Block Level
LEFT OUTER JOIN
in SELECT, Parameters--FromSpec
left outer join
defined, Outer Joins Using Explicit JOIN syntax
LIKE predicate
in search condition, Search Condition
syntax, LIKE Predicate
local variable
and DECLARE Variable, DECLARE Variable
differences from host variables, Using Local Variables in Procedures
naming rules, Local Variable Names
using in procedures, Using Local Variables in Procedures
LOCK TABLE
syntax, LOCK TABLE
locking
automatic, What Determines Lock Types, CREATE TABLE
concurrency control, Concurrency Control through Locks and Isolation Levels
deadlocks, Deadlocks
exclusive mode, Locking Structure Implicit at CREATE TABLE Time, LOCK TABLE
explicit, What Determines Lock Types, LOCK TABLE
granularity, Types of Locks
implicit, What Determines Lock Types
in COMMIT WORK, COMMIT WORK
in LOCK TABLE, LOCK TABLE
isolation levels, Choice of Isolation Level
levels of, What Determines Lock Types
mode, Choosing the Locking Mode and Default Access Authorities, What Determines Lock Types, Locking Structure Implicit at CREATE TABLE Time
mode associated authorities, Choosing the Locking Mode and Default Access Authorities
mode types of, Specifying Data Types
objects locked, What Determines Lock Types
overriding automatic locking, LOCK TABLE
page and table compared, Lock Granularities
PUBLIC, Locking Structure Implicit at CREATE TABLE Time
PUBLICREAD, Locking Structure Implicit at CREATE TABLE Time
release, Scope and Duration of Locks
released in deadlock, Deadlocks
released in STOP DBE, STOP DBE
releasing in ROLLBACK WORK, ROLLBACK WORK
releasing locks, Description
row and page compared, Lock Granularities
SET USER TIMEOUT , Description
share, Types of Locks, Locking Structure Implicit at CREATE TABLE Time, LOCK TABLE
share update mode, LOCK TABLE
locks
exclusive (X), Types of Locks
in RELEASE, RELEASE
intention exclusive (IX), Types of Locks
intention share (IS), Types of Locks
share (S), Types of Locks
share intention exclusive (SIX), Types of Locks
waits and timeout, Lock Waits
log buffer pages
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
log buffers
flushing, CHECKPOINT
LOG COMMENT
syntax, LOG COMMENT
log comment
generating, LOG COMMENT
log file
creating new, START DBE NEWLOG
defined, Physical Concepts
increasing or decreasing space, Description
orphaned, in wrapperDBE, Using Wrapper DBEnvironments
log file names
assigning, SQL Syntax--DBELogDefinition
in START DBE NEWLOG, START DBE NEWLOG
rules for, Names
logging
audit, Auditing DBEnvironments, START DBE NEW, START DBE NEWLOG
dual, START DBE NEW, START DBE NEWLOG
rollback, ROLLBACK WORK
row level DML atomicity, How Constraints are Enforced
logical operators, Search Condition
LONG
I/O string syntax, Defining Input and Output with the LONG Column I/O String
LONG BINARY
defined, Type Specifications
storage requirements, Type Specifications
long column
authorization in ALTER TABLE, Authorization
authorization in CREATE TABLE, Authorization
functions syntax, Long Column Functions
LONG data type
OUTPUT_DEVICE function, Long Column Functions
OUTPUT_NAME function, Long Column Functions
restricted from search condition, Description
syntax, defining column, Defining LONG Column Data with CREATE TABLE or ALTER TABLE
LONG VARBINARY
defined, Type Specifications
storage requirements, Type Specifications

M

MAX
syntax, Aggregate Functions
maximum
columns, Parameters--Column Definition
columns for a view, Parameters
columns in a query, Description--Query Block Level
concurrent transactions , Parameters, Parameters--START DBE NEW, Parameters--START DBE NEWLOG
DBEFile size, Parameters
hash key size, Description
host variable names, Parameters--HostVariableSpecification
host variables, Parameters
items for DISTINCT option, Parameters--Query Block Level
length of index key, Description
log file size, Parameters--NewLogDefinition
number of concurrent transactions, Parameters
number of partitions, START DBE NEW, Parameters--START DBE NEW, Parameters--START DBE NEWLOG
PrimaryPages, Parameters--CREATE TABLE
tables per query, Parameters--Query Block Level
TempSpace, CREATE TEMPSPACE
timeout , Parameters, Parameters--START DBE NEWLOG, Description
MAXPAGES, Parameters
maxpartitions
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
MaxTransactions, Parameters
message
buffer in procedures, Error Handling in Procedures Not Invoked by Rules
catalog, SQLEXPLAIN
error number, RAISE ERROR
for PRINT statements, Description
handling with SET PRINTRULES, SET PRINTRULES
number 5000, Description
MICROFOCUS
COBOL preprocessor, ALLBASE/SQL Components
MIN
syntax, Aggregate Functions
minimum
DBEFile size, Parameters
PrimaryPages, Parameters--CREATE TABLE
mixed DBEFiles, CREATE DBEFILE
module names
in DROP MODULE, DROP MODULE
in PREPARE, PREPARE
in REVOKE, SQL Syntax—Revoke RUN or EXECUTE or Authority
rules for, Names
modules
access plan for validation, Description
created by preprocessor, Preprocessor
dropping, DROP MODULE
effect of DBEnvironment changes on, DBEnvironment Changes
extracting, Description
owner of, Description
validating, VALIDATE
MONITOR
authority, MONITOR Authority
multi-transaction mode
explained, Using Multi-Transaction Mode with Multiple DBEnvironments
undetectable deadlocks, Setting Timeout Values
use with one DBE, Using Multi-Transaction Mode with One DBEnvironment
multiple
connections example, Setting Timeout Values
connections using, Using Multiple Connections and Transactions with Timeouts
DBEnvironments, Using Multiple Connections and Transactions with Timeouts
multitable operations
SELECT, SELECT
using, Simple Queries
multitransaction mode
in SET MULTITRANSACTION, SET MULTITRANSACTION
multiuser mode
defined, ALLBASE/SQL Data Access
in a DBE session, Starting and Terminating a DBE Session

N

names
basic, Names
used in ALLBASE/SQL, Names
naming
database objects, Names
DBEConfile, DBEnvironment and DBECon File Names
DBEnvironment, DBEnvironment and DBECon File Names
DBEUserID, DBEUserIDs
host variables, Host Variable Names
owners, DBEUserIDs
system files, DBEnvironment and DBECon File Names
with native language objects, Native Language Object Names
NATIVE CHAR
conversions rules, Description--Query Expression Level
native language
ALLBASE/SQL object names, Native Language Object Names
character data, Native Language Data
current language, Native Language Support
defaults, Native Language Support
in columns and tables, Specifying Native Language Tables and Columns
in creating a DBEnvironment, Specifying a Native Language Parameter
setting and resetting, Native Language Support
support overview, Native Language Support
tables in ALTER TABLE, ALTER TABLE
tables in CREATE TABLE, CREATE TABLE
NATIVE VARCHAR
conversions rules, Description--Query Expression Level
native-3000
and double quotes, Specifying Native Language Tables and Columns
defined, Native Language Support
NATURAL
in SELECT, Parameters--FromSpec
natural inner join
defined, Complex Queries, Outer Joins
NATURAL JOIN
in SELECT, Description--Query Block Level
NOT NULL
in CREATE TABLE, Description
in defining a column, Specifying Column Options
NULL predicate
in search condition, Search Condition
syntax, NULL Predicate
null values
and altering tables, ALTER TABLE
and FETCH, FETCH
and INSERT, Parameters--SingleRowValues
and SELECT, Parameters--Query Block Level
and UPDATE, UPDATE
and UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
as index keys, Description
behavior in Cartesian product, Description--Query Block Level
behavior in joins, Description--Query Block Level
defined, Null Values
in an expression , Description
in Cartesian product, Simple Queries
in comparison predicates, Description
in joins, Simple Queries
in search conditions, Description

O

objects
defined, ALLBASE/SQL Data Access
native language names in, Native Language Object Names
owner of, Ownership
OPEN
syntax, OPEN
operators
arithmetic , Expression
comparison, Comparison Predicate
logical, Search Condition
optimizer
displaying access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
modifying plan with SETOPT, SETOPT
ORDER BY
in simple queries, Using the SELECT Statement
specifying result columns, Description--Query Block Level
order of evaluation
of elements in an expression , Description
orphaned log files
wrapperDBE, Using Wrapper DBEnvironments
orphaned privilege
providing a parent, Parameters—Grant Table or View Authority
outer join
defined, Outer Joins
syntax, Parameters--non-BULK HostVariableSpecification
using UNION operator, Outer Joins Using the UNION Operator
OUTPUT_DEVICE, Long Column Functions
OUTPUT_NAME, Long Column Functions
overflow
in expression , Description
of data, Overflow and Truncation
owner
authorization group, Logical Concepts
changing, TRANSFER OWNERSHIP
class, Logical Concepts
how to become one, Ownership
individuals, Logical Concepts
of modules, Description
of system section tables, Special Names
of system tables, Special Names
privileges, Authorization Groups
use of name, Ownership
who can be one, Ownership
owner names
origin of, Ownership
rules governing, DBEUserIDs
specification of, Logical Concepts
use of, Ownership
ownership
and dropping authorization groups, DROP GROUP
creating objects, Ownership
how it is assigned, Ownership
of objects, Ownership
transferring, Ownership, TRANSFER OWNERSHIP

P

page buffers
flushing, CHECKPOINT
page level locking, Lock Granularities
pages
deadlocks, Deadlocks
in DBEFiles, CREATE DBEFILE
in TempSpaces, CREATE TEMPSPACE
PARALLEL FILL option
setting in BEGIN WORK, BEGIN WORK
setting in SET SESSION, SET SESSION
parameter
in procedures, Specifying Parameters
naming rules, Parameter Names
using in procedures, Creating Procedures
partition
creating, Partitions in Audit DBEnvironments, CREATE PARTITION
dropping, DROP PARTITION
instance, Auditing DBEnvironments
setting with ALTER TABLE, ALTER TABLE
understanding, Partitions in Audit DBEnvironments
Pascal preprocessor
defined, ALLBASE/SQL Components
pattern matching
in LIKE predicate, LIKE Predicate
performance
in procedures and rules, Performance Considerations
precision
defined, Type Specifications
in DECIMAL operations, Decimal Operations
predicates
BETWEEN, BETWEEN Predicate
COMPARISON, Comparison Predicate
compatible data types in, Description
definition of, Search Condition
EXISTS predicate, EXISTS Predicate, EXISTS Predicate
IN predicate, IN Predicate, IN Predicate
in search condition, Search Condition
LIKE predicate, LIKE Predicate
NULL predicates, NULL Predicate
null values in, Description
order of evaluation of, Description
quantified predicate, Quantified Predicate, Quantified Predicate
PREPARE
statements that cannot be prepared, Description
syntax, PREPARE
preparing statements
interactively and programmatically, PREPARE
preprocessor
defined, ALLBASE/SQL Components
tasks, Preprocessor
preserving authorization
and DROP MODULE, DROP MODULE
primary
in an expression , Expression
pages, Parameters--CREATE TABLE
PRIMARY KEY
in ALTER TABLE, ALTER TABLE
in CREATE TABLE, CREATE TABLE
PRINT
in procedures, PRINT
priority
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
private
locking, Locking Structure Implicit at CREATE TABLE Time
PRIVATE tables
in CREATE TABLE, CREATE TABLE
locking mode, Choosing the Locking Mode and Default Access Authorities
privilege
defined, Logical Concepts
grantable, Grantable Privileges
procedure
and transaction management, Procedures and Transaction Management
Assignment, Assignment (=)
BEGIN, BEGIN
built-in variables in, Using Built-in Variables in Procedures
caller recommended practices, Recommended Coding Practices for Procedures
checkpoint host variable, CHECKPOINT
coding practices, Recommended Coding Practices for Procedures
comments within, Recommended Coding Practices for Procedures
control flow statements in, Using SQL Statements in Procedures
control language, IF, WHILE
creating, Creating Procedures, CREATE PROCEDURE
defined, Constraints, Procedures, and Rules
executing, Executing Procedures
explained, Using Procedures
GOTO in control language, GOTO
local variables in, Using Local Variables in Procedures
parameters in, Specifying Parameters
PRINT statement, Error Handling in Procedures Not Invoked by Rules, PRINT
queries in, Queries inside Procedures
RAISE ERROR, RAISE ERROR
recommended practices, Recommended Coding Practices for Procedures
result set, Description
RETURN, RETURN
rule and non-rule invocation, Special Considerations for Procedures Invoked by Rules
runtime errors, Error Handling in Procedures Not Invoked by Rules
SELECT in, Using a Simple SELECT
specifying in DECLARE CURSOR, Description
using DECLARE Variable in, DECLARE Variable
using with rules, Techniques for Using Procedures with Rules
validating, VALIDATE
with multiple row sets, Description
with single format multiple row sets, Description
procedure cursor
authorization in CREATE PROCEDURE, Authorization
defined, Queries inside Procedures, Description, Description
in ISQL, Using a Procedure Cursor in ISQL
parameters in, Specifying Parameters
query types, Queries inside Procedures
procedure names
in GRANT, SQL Syntax--Grant RUN or EXECUTE Authority
in REVOKE, SQL Syntax—Revoke RUN or EXECUTE or Authority
procedures and rules
chains of, Using a Chained Set of Procedures and Rules
using, Using Procedures, Using Rules
programmatic database access
defined, ALLBASE/SQL Components
programs
effect of DBEnvironment changes on, DBEnvironment Changes
PUBLIC
special name, Special Names
PUBLIC tables
in CREATE TABLE, CREATE TABLE
in GRANT, SQL Syntax--Grant RUN or EXECUTE Authority
locking mode, Choosing the Locking Mode and Default Access Authorities
PUBLICREAD tables
in CREATE TABLE, CREATE TABLE
locking mode, Choosing the Locking Mode and Default Access Authorities
PUBLICROW tables
in CREATE TABLE, CREATE TABLE
locking mode, Choosing the Locking Mode and Default Access Authorities
purging DBEFiles
using DROP DBEFILE, DROP DBEFILE

Q

quantified predicate
explained, Quantified Predicate
syntax, Quantified Predicate
queries
available with a procedure cursor, Queries inside Procedures
defined, Using Queries
displaying access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
in procedures, Queries inside Procedures
range of complex types, Complex Queries
simple types, Simple Queries
updatable, Updatability of Queries
query
block in SELECT, SQL Syntax--Query Expression Level
blocks in expression, Complex Queries
complex, Complex Queries
expression, Complex Queries
expression in SELECT, SELECT
file space used, Description--Query Block Level
modifying access plan, SETOPT
processor defined, ALLBASE/SQL Components
result defined, Using the SELECT Statement
results, SELECT
syntax (SELECT), SELECT

R

RAISE ERROR
in procedures, Using RAISE ERROR in Procedures
in procedures invoked by rules, Using RAISE ERROR in Procedures Invoked by Rules
syntax, RAISE ERROR
RC isolation level
explained, Read Committed (RC)
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
read committed (RC)
explained, Read Committed (RC)
read committed isolation level
in BEGIN WORK, Parameters
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
read uncommitted (RU)
explained, Read Uncommitted (RU)
read uncommitted isolation level
in BEGIN WORK, Parameters
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
REAL
conversions rules, Description--Query Expression Level
data type defined, Type Specifications
storage requirements, Type Specifications
real values
in constants, Scope
recovery
rollback, ROLLBACK WORK
referenced table
defined, The Referenced Table
referencing table
defined, The Referencing Table
referential constraint
deferred error checking, Inserting Rows in Tables Having Constraints
defined, Referential Constraints
in ALTER TABLE, ALTER TABLE
in CREATE TABLE, CREATE TABLE
revoking, SQL Syntax—Revoke Table or View Authority
slowing TRUNCATE TABLE, Description
referential integrity
using constraints, Specifying Integrity Constraints, Using Integrity Constraints
REFETCH
syntax, REFETCH
relation
defined, Logical Concepts
relational database
defined, Logical Concepts
RELEASE
syntax, RELEASE
release
DBE session, RELEASE
in COMMIT WORK, COMMIT WORK
remote connections
establishment of, Using Multiple Connections and Transactions with Timeouts
REMOVE DBEFile
syntax, REMOVE DBEFILE
REMOVE FROM GROUP
syntax, REMOVE FROM GROUP
removing DBEFiles, REMOVE DBEFILE
RENAME COLUMN
syntax, RENAME COLUMN
RENAME TABLE
syntax, RENAME TABLE
renaming
columns, RENAME COLUMN
tables, RENAME TABLE
repeatable read (RR)
explained, Repeatable Read (RR)
repeatable read isolation level
in BEGIN WORK, Parameters
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
RESET
syntax, RESET
resetting ALLBASE/SQL system data, RESET
result
table defined, Using Queries
result columns
in SELECT, Description--Query Block Level
retrieving
data, SQL Queries
rows, SQL Queries, SELECT
RETURN
syntax, RETURN
return status
in DECLARE CURSOR
specifying, Description
revalidating rows, REFETCH
REVOKE
and CASCADE, Grantable Privileges
and grantable privilege, Grantable Privileges
syntax, REVOKE
revoking
authorities using REVOKE, REVOKE
DBEFileSet authority, SQL Syntax—Revoke DBEFileSet Authority
grants using CASCADE, Grantable Privileges
RIGHT OUTER JOIN
in SELECT, Parameters--FromSpec, Description--Query Block Level
right outer join
defined, Outer Joins Using Explicit JOIN syntax
roll forward
wrapperDBE, Using Wrapper DBEnvironments
rollback
recovery, ROLLBACK WORK
ROLLBACK WORK, ROLLBACK WORK
ROLLBACK WORK
in a procedure, Procedures and Transaction Management
syntax, ROLLBACK WORK
row level
DML atomicity, SET DML ATOMICITY
DML atomicity logging, How Constraints are Enforced
locking, Lock Granularities
rows
defined, Logical Concepts
fetching, FETCH
inserting, INSERT
joining, Description--Query Block Level
selecting, SELECT
RR isolation level
explained, Repeatable Read (RR)
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
RU isolation level
explained, Read Uncommitted (RU)
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
rule
and transaction management, Transaction Handling in Rules
creating, Creating Rules, CREATE RULE
defined, Constraints, Procedures, and Rules
differences from integrity constraints, Differences between Rules and Integrity Constraints
enabling and disabling, Enabling and Disabling Rules
explained, Using Rules
techniques for using procedures with, Techniques for Using Procedures with Rules
rules and procedures
chains of, Using a Chained Set of Procedures and Rules
CREATE PROCEDURE statement, CREATE PROCEDURE
CREATE RULE statement, CREATE RULE
DISABLE RULES statement, DISABLE RULES
DROP PROCEDURE statement, DROP PROCEDURE
DROP RULE statement, DROP RULE
ENABLE RULES statement, ENABLE RULES
TRUNCATE TABLE statement, Description
using, Using Procedures, Using Rules
RUN authority
granting, SQL Syntax--Grant RUN or EXECUTE Authority
purpose, Authorization
revoking, SQL Syntax—Revoke RUN or EXECUTE or Authority
run block
in START DBE, START DBE
in START DBE NEWLOG, START DBE NEWLOG
runtime control block pages
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
runtime errors
in a procedure, Error Handling in Procedures Not Invoked by Rules

S

S (SHARE) locks, Description
S lock
explained, Types of Locks
sample DBEnvironment, Sample DBEnvironment
SAVEPOINT
in a procedure, Procedures and Transaction Management
setting, SAVEPOINT
syntax, SAVEPOINT
using, ROLLBACK WORK
scale
defined, Type Specifications
in DECIMAL operations, Decimal Operations
scoping
transaction and session attributes, Scoping of Transaction and Session Attributes
search condition
compatible predicates, Description
defined, Using the SELECT Statement
definition, Search Conditions
in complex queries, Complex Queries
in DELETE, DELETE
subquery in, Subqueries
syntax, Search Condition
type conversion in, Description
use for, Search Conditions
value extensions in, Description
SearchCondition
in CREATE TABLE, Parameters--Check Constraint (Table Level)
section
authorization in PREPARE, Authorization
defined, Preprocessor
invalidation by TRUNCATE TABLE, Description
invalidation through procedures, Invalidation of Sections
semi-permanent, Parameters
validating, VALIDATE
section audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
SECTIONSPACE
authorization in CREATE RULE, Description
security
of database, Controlling Database Access
SELECT
displaying access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
in CREATE VIEW, CREATE VIEW
in DECLARE CURSOR, DECLARE CURSOR
in procedures, Using a Simple SELECT
syntax, SELECT, Scope, SQL Syntax--Query Block Level
use of, SQL Queries
with cursor in procedures, Using a Select Cursor
select cursor
authorization in CREATE PROCEDURE, Authorization
defined, Queries inside Procedures, Description, Description
within a procedure, Queries inside Procedures
select list
defined, Using the SELECT Statement, Parameters--Query Block Level
selecting data
discussed, SQL Queries
grouping rows, Description--Query Block Level
maximum columns, Parameters--SelectList
null values, Parameters--Query Block Level
SELECT, SELECT
unique rows, Parameters--Query Block Level
semi-permanent section
creating with PREPARE, Parameters
owner, Special Names
SEMIPREM owner, Special Names
serializable isolation level
in SET SESSION, Parameters
in SET TRANSACTION, Parameters
session
DBE, Starting and Terminating a DBE Session
SET CONNECTION
syntax, SET CONNECTION
set constraint type statement
explained, How Constraints are Enforced
SET CONSTRAINTS
syntax, SET CONSTRAINTS
SET DEFAULT DBEFILESET
syntax, SET DEFAULT DBEFILESET
SET DML ATOMICITY
syntax, SET DML ATOMICITY
SET MULTITRANSACTION
explained, Setting the Transaction Mode
syntax, SET MULTITRANSACTION
SET PRINTRULES
syntax, SET PRINTRULES
SET PRINTRULES ON
to trace rule chaining, Effects of Rule Chaining
SET SESSION
CS isolation level, Parameters
cursor stability isolation level, Parameters
RC isolation level, Parameters
read committed isolation level, Parameters
read uncommitted isolation level, Parameters
repeatable read isolation level, Parameters
RR isolation level, Parameters
RU isolation level, Parameters
serializable isolation level, Parameters
syntax, SET SESSION
SET TRANSACTION
CS isolation level, Parameters
cursor stability isolation level, Parameters
RC isolation level, Parameters
read committed isolation level, Parameters
read uncommitted isolation level, Parameters
repeatable read isolation level, Parameters
RR isolation level, Parameters
RU isolation level, Parameters
serializable isolation level, Parameters
syntax, SET TRANSACTION
SET USER TIMEOUT
syntax, SET USER TIMEOUT
SETOPT
syntax, SETOPT
validating modules, VALIDATE
setting
constraint checking with SET SESSION, SET SESSION
constraint checking with SET TRANSACTION, SET TRANSACTION
constraints to deferred, SET CONSTRAINTS
current connection, Setting the Current Connection
default DBEFileSet, SET DEFAULT DBEFILESET
DML atomicity, SET DML ATOMICITY
multiple-transaction mode, Using Multi-Transaction Mode with Multiple DBEnvironments
options with BEGIN WORK, BEGIN WORK
savepoints, SAVEPOINT
the current connection, SET CONNECTION
the FILL option, SET SESSION
timeout values, Setting Timeout Values
transaction mode, Setting the Transaction Mode
setting DML ATOMICITY
with SET SESSION, SET SESSION
with SET TRANSACTION, SET TRANSACTION
setting DML atomicity, How Constraints are Enforced
setting transaction attributes
with SET SESSION, SET SESSION
with SET TRANSACTION, SET TRANSACTION
share
intention exclusive lock, Types of Locks
lock defined, Types of Locks
SHARE mode
in LOCK TABLE, LOCK TABLE
share mode
locking, Locking Structure Implicit at CREATE TABLE Time
SHARE UPDATE mode
in LOCK TABLE, LOCK TABLE
simple names
defined, DBEUserIDs
simultaneous transactions
with BEGIN WORK, Description
single-transaction mode
explained, Using Single-Transaction Mode
in SET MULTITRANSACTION, SET MULTITRANSACTION
single-user mode
defined, ALLBASE/SQL Data Access
in a DBE session, Starting and Terminating a DBE Session
SIX (SHARE INTENT EXCLUSIVE) locks, Description
SIX lock
explained, Types of Locks
SMALLINT
conversions rules, Description--Query Expression Level
defined, Type Specifications
storage requirements, Type Specifications
SOME
in quantified predicate, Quantified Predicate
sorting
using TempSpace, Creating Physical Storage
space management
for tables and indexes, Creating Physical Storage
in CREATE DBEFILESET, CREATE DBEFILESET
special
authorities revoking, SQL Syntax—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
names, Special Names
special predicates
EXISTS predicate, EXISTS Predicate
IN predicate, IN Predicate
quantified predicate, Quantified Predicate
SQL
defined, Introduction
language structure, SQL Language Structure
naming rules, Names
usage, Introduction, Creating DBEnvironments
SQL statement
ADD DBEFile, ADD DBEFILE
ADD TO GROUP, ADD TO GROUP
ADVANCE, ADVANCE
ALTER DBEFILE, ALTER DBEFILE
ALTER TABLE, ALTER TABLE
Assignment, Assignment (=)
BEGIN, BEGIN
BEGIN ARCHIVE, BEGIN ARCHIVE
BEGIN DECLARE SECTION, BEGIN DECLARE SECTION
BEGIN WORK, BEGIN WORK
BULK FETCH, FETCH
BULK INSERT, INSERT
BULK SELECT, SELECT
CHECKPOINT, CHECKPOINT
CLOSE, CLOSE
COMMIT ARCHIVE, COMMIT ARCHIVE
COMMIT WORK, COMMIT WORK
CONNECT, CONNECT
CREATE DBEFILE, CREATE DBEFILE
CREATE DBEFILESET, CREATE DBEFILESET
CREATE GROUP, CREATE GROUP
CREATE INDEX, CREATE INDEX
CREATE PARTITION, CREATE PARTITION
CREATE PROCEDURE, CREATE PROCEDURE
CREATE RULE, CREATE RULE
CREATE SCHEMA, CREATE SCHEMA
CREATE TABLE, CREATE TABLE
CREATE TEMPSPACE, CREATE TEMPSPACE
CREATE VIEW, CREATE VIEW
DECLARE CURSOR, DECLARE CURSOR
DECLARE Variable, DECLARE Variable
DELETE, DELETE
DELETE WHERE CURRENT, DELETE WHERE CURRENT
DESCRIBE, DESCRIBE
DISABLE AUDIT LOGGING, DISABLE AUDIT LOGGING
DISABLE RULES, DISABLE RULES
DISCONNECT, DISCONNECT
DROP DBEFILE, DROP DBEFILE
DROP DBEFILESET, DROP DBEFILESET
DROP GROUP, DROP GROUP
DROP INDEX, DROP INDEX
DROP MODULE, DROP MODULE
DROP PARTITION, DROP PARTITION
DROP PROCEDURE, DROP PROCEDURE
DROP RULE, DROP RULE
DROP TABLE, DROP TABLE
DROP TEMPSPACE, DROP TEMPSPACE
DROP VIEW, DROP VIEW
ENABLE AUDIT LOGGING, ENABLE AUDIT LOGGING
ENABLE RULES, ENABLE RULES
END DECLARE SECTION, END DECLARE SECTION
EXECUTE, EXECUTE
EXECUTE IMMEDIATE, EXECUTE IMMEDIATE
EXECUTE PROCEDURE, EXECUTE PROCEDURE
FETCH, FETCH
GENPLAN, GENPLAN
GOTO, GOTO
GRANT, GRANT
GRANT ON DBEFILESET, SQL Syntax—Grant DBEFileSet Authority
IF, IF
INCLUDE, INCLUDE
INSERT, INSERT
Labeled Statement, Labeled Statement
length, SQL Statements
LOCK TABLE, LOCK TABLE
LOG COMMENT, LOG COMMENT
OPEN, OPEN
PREPARE, PREPARE
PRINT, PRINT
RAISE ERROR, RAISE ERROR
REFETCH, REFETCH
RELEASE, RELEASE
REMOVE DBEFILE, REMOVE DBEFILE
REMOVE FROM GROUP, REMOVE FROM GROUP
RENAME COLUMN, RENAME COLUMN
RENAME TABLE, RENAME TABLE
RESET, RESET
RETURN, RETURN
REVOKE, REVOKE
ROLLBACK WORK, ROLLBACK WORK
SAVEPOINT, SAVEPOINT
SELECT, SELECT, Scope, SQL Syntax--Query Block Level
SET CONNECTION, SET CONNECTION
SET CONSTRAINTS, SET CONSTRAINTS
SET DEFAULT DBEFILESET, SET DEFAULT DBEFILESET
SET DML ATOMICITY, SET DML ATOMICITY
SET MULTITRANSACTION, SET MULTITRANSACTION
SET PRINTRULES, SET PRINTRULES
SET SESSION, SET SESSION
SET TRANSACTION, SET TRANSACTION
SET USER TIMEOUT, SET USER TIMEOUT
SETOPT, SETOPT
SQLEXPLAIN, SQLEXPLAIN
START DBE, START DBE
START DBE NEW, START DBE NEW
START DBE NEWLOG, START DBE NEWLOG
STOP DBE, STOP DBE
summary table, SQL Statements
syntax summary, SQL Syntax Summary
TERMINATE QUERY, TERMINATE QUERY
TERMINATE TRANSACTION, TERMINATE TRANSACTION
TERMINATE USER, TERMINATE USER
TRANSFER OWNERSHIP, TRANSFER OWNERSHIP
TRUNCATE TABLE, TRUNCATE TABLE
UPDATE, UPDATE
UPDATE STATISTICS, UPDATE STATISTICS
UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
VALIDATE, VALIDATE
WHENEVER, WHENEVER
WHILE, WHILE
SQL statements
categories, SQL Statement Categories
within procedures, Using SQL Statements in Procedures
SQLAudit
auditing transactions, Using SQLAudit
defined, Utility Programs
SQLCA
INCLUDE SQLCA, INCLUDE
used with SQLEXPLAIN, SQLEXPLAIN
used with WHENEVER, WHENEVER
SQLCheck
defined, Utility Programs
SQLDA
INCLUDE SQLDA, INCLUDE
used with FETCH, FETCH
SQLEXPLAIN
on returning from procedures, Using RAISE ERROR in Procedures
syntax, SQLEXPLAIN
SQLGEN
defined, Utility Programs
SQLMigrate
defined, Utility Programs
SQLMON
authority, MONITOR Authority
defined, Utility Programs
grant authority to run, Parameters--Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
monitoring locking, Monitoring Locking with SQLMON
monitoring transactions, Monitoring Transactions
revoke authority to run, Parameters—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
SQLUtil
defined, Utility Programs
setting transaction limits, Transaction Limits and Timeouts
wrapdbe command, Using Wrapper DBEnvironments
SQLVer
defined, Utility Programs
standards flagging support, Standards Flagging Support
START DBE
syntax, START DBE
START DBE NEW
syntax, START DBE NEW
START DBE NEWLOG
syntax, START DBE NEWLOG
starting a DBE session
using CONNECT, CONNECT
using START DBE, START DBE
startup parameters
defined in START DBE NEW, Description
in START DBE NEW, Creating DBEnvironments
statement level
constraint error checking, SET CONSTRAINTS
DML atomicity, SET DML ATOMICITY
error enforcement explained, How Constraints are Enforced
STOP DBE
syntax, STOP DBE
stopping
ALLBASE/SQL using STOP DBE, STOP DBE
session using DISCONNECT, DISCONNECT
storage allocation
defined, Physical Concepts
storage audit element
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
Storage Manager
defined, ALLBASE/SQL Components
storage requirements
for specific data types, Type Specifications
stored modules
and DROP MODULE, DROP MODULE
STOREDSECT
owner of system section tables, Special Names
string
constants in constant, Scope
functions arguments in, String Functions
functions syntax, String Functions
value in constants, Scope
STRING_LENTH
in string functions, String Functions
Structured Query Language
defined, Introduction
subquery
as part of a predicate, Complex Queries
correlated, Correlated Versus Noncorrelated Subqueries
defined, Subqueries
in a quantified predicate, Using ANY or SOME with a Subquery
in an EXISTS predicate, EXISTS Predicate
in an IN predicate, Using the IN Predicate with a Subquery
SUBSTRING
in string functions, String Functions
SUM
defined, Parameters
syntax, Aggregate Functions
switching transactions
and MULTITRANSACTION, SET MULTITRANSACTION
symmetric outer join
and UNION, Outer Joins Using the UNION Operator
defined, Outer Joins Using Explicit JOIN syntax
using UNION operator, Symmetric Outer Join Using the UNION Operator
syntax summary
ISQL, ISQL Syntax Summary
SQL statements, SQL Syntax Summary
SYSTEM
as owner, Ownership
owner of system views, Special Names
table locking, What Determines Lock Types
view names in UPDATE STATISTICS, UPDATE STATISTICS
system catalog
contents, Initial Privileges, Understanding the System Catalog
defined, Physical Concepts
system tables, Initial Privileges
system views, Initial Privileges
table of system views, Understanding the System Catalog
updating statistics, UPDATE STATISTICS
system DBEFileset
defined, Physical Concepts
system views
summary of, Understanding the System Catalog
SYSTEM.ACCOUNT
resetting, RESET
SYSTEM.COLUMN
updating statistics for, UPDATE STATISTICS
SYSTEM.COUNTER
resetting, RESET
SYSTEM.DBEFILE
updating statistics for, UPDATE STATISTICS
SYSTEM.DBEFILESET
updating statistics for, UPDATE STATISTICS
SYSTEM.INDEX
updating statistics for, UPDATE STATISTICS
SYSTEM.SECTION
validating modules, Examples
SYSTEM.TABLE
monitoring for table size, Lock Granularities
updating statistics for, UPDATE STATISTICS

T

table
adding constraint to, ALTER TABLE
allocating storage for, Description
and check constraints, Check Constraints
changing locking , ALTER TABLE
creating, CREATE TABLE
defined, Logical Concepts, Creating a Table
defining default columns in, ALTER TABLE, Parameters--Column Definition
deleting all rows from, TRUNCATE TABLE
dropping, DROP DBEFILE, DROP TABLE
dropping constraint from, ALTER TABLE
explicit locking, LOCK TABLE
granting authorities, GRANT
implicit locking, CREATE TABLE
inserting rows into, INSERT
locking, Locking Structure Implicit at CREATE TABLE Time
locking explained, Lock Granularities
referenced, The Referenced Table
referencing, The Referencing Table
revoking authorities, REVOKE, SQL Syntax—Revoke Table or View Authority
updating statistics, UPDATE STATISTICS
TABLE DBEFiles, CREATE DBEFILE
table names
in ALTER TABLE, ALTER TABLE
in CREATE INDEX, CREATE INDEX
in CREATE TABLE, CREATE TABLE
in DELETE, DELETE
in DELETE WHERE CURRENT, DELETE WHERE CURRENT
in DROP INDEX, DROP INDEX
in DROP TABLE, DROP TABLE
in GRANT, Parameters—Grant Table or View Authority
in INSERT, INSERT
in LOCK TABLE, LOCK TABLE
in REVOKE, SQL Syntax—Revoke Table or View Authority
in TRANSFER OWNERSHIP, TRANSFER OWNERSHIP
in TRUNCATE TABLE, TRUNCATE TABLE
in UPDATE statements, UPDATE
in UPDATE STATISTICS, UPDATE STATISTICS
in UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
rules for, Names
TableSpec
in SELECT, FromSpec
TEMP
and modules not stored, Description
owner of modules, Special Names
temporary section
validating, VALIDATE
TempSpace
defined, Creating Physical Storage
dropping, DROP TEMPSPACE
names in CREATE TEMPSPACE, CREATE TEMPSPACE
names in DROP TEMPSPACE, DROP TEMPSPACE
using, CREATE TEMPSPACE
TERMINATE QUERY
syntax, TERMINATE QUERY
TERMINATE TRANSACTION
syntax, TERMINATE TRANSACTION
TERMINATE USER
syntax, TERMINATE USER
terminating
a DBE session, Starting and Terminating a DBE Session, DISCONNECT, RELEASE, TERMINATE QUERY, TERMINATE USER
transactions, ROLLBACK WORK, TERMINATE TRANSACTION
TERMINATION LEVEL
setting with SET SESSION, SET SESSION
setting with SET TRANSACTION, SET TRANSACTION
THEN
in procedures, IF
TID function
syntax, TID Function
TIME
conversions rules, Description--Query Expression Level
defined, ALLBASE/SQL Data Types
operations with values, Date/Time Operations
storage requirements, Type Specifications
values in arithmetic expression, Use of Date/Time Data Types in Arithmetic Expressions
timeout
and BEGIN WORK , Description
and lock waits, Lock Waits
SET SESSION statement, SET SESSION
SET TRANSACTION statement, SET TRANSACTION
SET USER TIMEOUT statement, SET USER TIMEOUT
START DBE NEWLOG, Description
value setting, Setting Timeout Values
values in DBECon file, START DBE
TO_CHAR function
syntax, Date/Time Functions
TO_DATE function
syntax, Date/Time Functions
TO_DATETIME function
syntax, Date/Time Functions
TO_INTEGER function
syntax, Date/Time Functions
TO_INTERVAL function
syntax, Date/Time Functions
TO_TIME function
syntax, Date/Time Functions
transaction attributes
setting in BEGIN WORK, BEGIN WORK
setting in SET SESSION, SET SESSION
setting in SET TRANSACTION, SET TRANSACTION
transactions
aborted, STOP DBE
and data consistency, ALLBASE/SQL Data Access
and multiple connections, Using Multiple Connections and Transactions with Timeouts
and recovery, ALLBASE/SQL Data Access
and timeouts, Using Multiple Connections and Transactions with Timeouts
automatic rollback of, ROLLBACK WORK
committing, Deleting Data
defined, ALLBASE/SQL Data Access, Deleting Data
effect of terminating, COMMIT WORK
errors in level constraint checking, SET CONSTRAINTS
implicit vs. explicit, Description
in a procedure, Procedures and Transaction Management
in a procedure invoked by a rule, Transaction Handling in Rules
in START DBE NEW, Parameters--START DBE NEW
locks released, Description
management, Deleting Data
maximum in START DBE, START DBE
maximum in START DBE NEWLOG, Parameters--START DBE NEWLOG
mode setting, Setting the Transaction Mode
priority, Deadlocks
SET USER TIMEOUT , Description
simultaneous with BEGIN WORK, Description
statements that must be in the same, Description
terminating, Description, COMMIT WORK, ROLLBACK WORK
TRANSFER OWNERSHIP
syntax, TRANSFER OWNERSHIP
transferring ownership, TRANSFER OWNERSHIP
when dropping authorization group, DROP GROUP
TRUNCATE TABLE
syntax, TRUNCATE TABLE
truncation
and native language data, Native Language Data
in aggregate functions, Description
in expressions , Description
of data, Overflow and Truncation
tuple
defined, Logical Concepts
type conversion
and overflow, Overflow and Truncation
and truncation, Overflow and Truncation
defined, Type Conversion
in aggregate functions, Description
in COMPARISON predicates, Description
in expressions , Description
in search conditions, Description

U

UDCs
use with ALLBASE/SQL, Sample DBEnvironment
underflow
defined, Underflow
in expression , Description
undetectable deadlock
in multi-transaction mode, Setting Timeout Values
UNION
and outer join, Outer Joins Using the UNION Operator
character constants with, Using Character Constants with UNION
in outer joins, Outer Joins Using the UNION Operator
in queries, UNION Queries
in SELECT, Parameters--Query Expression Level
UNION ALL form, UNION Queries
unique
column values DISTINCT, Example
indexes, CREATE INDEX
rows, Parameters--Query Block Level
unique constraint
defined, Unique Constraints
in ALTER TABLE, ALTER TABLE
in CREATE TABLE, CREATE TABLE
updatability
of cursors, Description
of views, Description
rules, Updatability of Queries
UPDATE
displaying access plan, Symmetric Outer Join Using the UNION Operator, GENPLAN
statement type in rules, Description, Description
syntax, UPDATE
UPDATE STATISTICS
syntax, UPDATE STATISTICS
validating modules, Description
UPDATE WHERE CURRENT
syntax, UPDATE WHERE CURRENT
updating
data, Updating Data
system catalog statistics, UPDATE STATISTICS
USER expression value
expressions, Parameters
IN predicate, Parameters
user mode
defined, ALLBASE/SQL Data Access
in CONNECT, CONNECT
user table locking
explained, What Determines Lock Types
user timeout value
in SET SESSION, SET SESSION
in SET TRANSACTION, SET TRANSACTION
in START DBE, START DBE
in START DBE NEW, START DBE NEW
in START DBE NEWLOG, START DBE NEWLOG
using ALLBASE/SQL
ad hoc queries, ALLBASE/SQL Users
application programming, ALLBASE/SQL Users
database administration, ALLBASE/SQL Users
using SQL
summarized, Creating DBEnvironments

V

VALIDATE
syntax, VALIDATE
validity checking
of data, Specifying Integrity Constraints
of databases, Using Integrity Constraints
value
comparisons, Value Comparisons
extensions in search conditions, Description
VARBINARY
conversions rules, Description--Query Expression Level
long data type defined, Type Specifications
storage requirements, Type Specifications
VARCHAR
conversions rules, Description--Query Expression Level
defined, Type Specifications
storage requirements, Type Specifications
variable-length strings
defined, Type Specifications
variables
BEGIN DECLARE SECTION, BEGIN DECLARE SECTION
END DECLARE SECTION, END DECLARE SECTION
indicator, Host Variables
input, Host Variables
output, Host Variables
verb
defined, SQL Language Structure
view names
in CREATE VIEW, CREATE VIEW
in DELETE, DELETE
in DELETE WHERE CURRENT, DELETE WHERE CURRENT
in DROP TABLE, DROP TABLE
in DROP VIEW, DROP VIEW
in INSERT, INSERT
in REVOKE, SQL Syntax—Revoke Table or View Authority
in TRANSFER OWNERSHIP, TRANSFER OWNERSHIP
in UPDATE, UPDATE
in UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
rules for, Names
views
and check constraints, Check Constraints
base tables, Creating a View
creating, Creating a View, CREATE VIEW
defined, Logical Concepts, Creating a View
dropping, DROP TABLE, DROP VIEW
granting authorities, GRANT
inserting data, Parameters - Insert Rows with Defined Values
restrictions in using, Creating a View, Description
revoking authorities, REVOKE, SQL Syntax—Revoke Table or View Authority
updatability of, Description
updatable, Updatability of Queries
uses for, Creating a View
WITH CHECK OPTION, Check Constraints
volume specification
creating DBEFile, CREATE DBEFILE

W

WHENEVER
in procedures, Error Handling in Procedures Not Invoked by Rules
syntax, WHENEVER
WHERE
and joins, Description--Query Block Level
in SELECT, Parameters--Query Block Level
in simple queries, Using the SELECT Statement
WHILE
syntax, WHILE
WITH CHECK OPTION
in CREATE VIEW, Description
view, Check Constraints
WITH GRANT OPTION
explained, Grantable Privileges
syntax in GRANT, GRANT
wrapdbe command
wrapperDBE, Using Wrapper DBEnvironments
wrapperDBE
archive logging, Using Wrapper DBEnvironments
audit information, Using Wrapper DBEnvironments
definition, Using Wrapper DBEnvironments
roll forward, Using Wrapper DBEnvironments
wrapdbe command, Using Wrapper DBEnvironments
writer of a procedure
recommended practices, Recommended Coding Practices for Procedures

X

X (EXCLUSIVE) locks, Description
explained, Types of Locks


Non-Standard Syntax Rules
  		 
Feedback to webmaster