 |
» |
|
|
|
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
- 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
- in an expression, Expression
- in NULL predicates, NULL Predicate
- ALL
- 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
- 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
- asymmetric
outer join
- defined, Outer Joins Using Explicit JOIN syntax
- atomicity
- 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
- 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 logging
- enabling, ENABLE AUDIT LOGGING
- 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
- granting, Grants, GRANT
- granting
on DBEFileSET, Parameters — 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
- 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 select cursor, Authorization
- in
START DBE NEW, START DBE NEW
- long
column in ALTER TABLE, Authorization, Assignment (=)
- 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
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
- 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
C- C preprocessor
- defined, ALLBASE/SQL Components
- caller
of a procedure
- recommended practices for, Recommended Coding Practices for Procedures
- Cartesian
product
- defined, Simple Queries
- CASCADE
- explained, Grantable Privileges
- case sensitive
- comparison predicate, Description
- comparisons, Value Comparisons
- 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
- defined, Specifying Integrity Constraints, Check Constraints
- in
a view, Check Constraints
- in ALTER TABLE, ALTER TABLE
- in CREATE TABLE, CREATE TABLE, 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
- 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
- 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
- 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
- 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 TRANSACTION, SET TRANSACTION
- example, Examples of Integrity Constraints
- constraint
checking
- 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
- in
procedures, IF, WHILE
- controlling
- error
checking level, SET DML ATOMICITY
- conversion
rules
- data in query expressions, Description — Query Expression Level
- copying
rows
- to tables and views, Inserting Data
- correlated
subquery
- explained, Correlated Versus Noncorrelated Subqueries
- 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
- 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
- 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
- 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 SET SESSION, Parameters
- in SET TRANSACTION, Parameters
- cursors
- active
set, FETCH, REFETCH
- advancing, ADVANCE
- 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
- effect of, Data Types
- 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
- 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
- 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
- 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, Authorization — Grant Table or View 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
- 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
- DECLARE
- and
local variables in a procedure, Using Local Variables in Procedures
- DECLARE %%Variable%%
- syntax, DECLARE Variable
- DECLARE
CURSOR
- syntax, DECLARE CURSOR
- 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
- 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
SELECT, SELECT, Parameters — Query Block Level
- DML
ATOMICITY
- 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
- dynamic
parameters
- example of usage, Description
- 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 level 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, Authorization — Grant Table or View 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
- defined, Expressions
- in
BETWEEN predicate, BETWEEN Predicate
- in
COMPARISON predicate, Comparison Predicate
- in
EXISTS predicate, EXISTS Predicate
- in
IN predicate, IN Predicate
- in
LIKE predicate, LIKE Predicate
- in
NULL predicates, NULL Predicate
- 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
- fixed-length
strings
- defined, Type Specifications
- 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
- fully
qualified name, Compound Identifiers
G- generating
- log
comment, LOG COMMENT
- GENPLAN
- explained, Symmetric Outer Join Using the UNION Operator
- syntax, GENPLAN
- with
SYSTEM and CATALOG views, Description, GOTO
- GRANT
- MONITOR
authority, MONITOR Authority
- syntax, GRANT
- WITH
GRANT OPTION explained, Grantable Privileges
- GRANT ON DBEFILESET
- syntax, Parameters — Grant DBEFileSet Authority
- grantable
privileges
- explained, Grantable Privileges
- revoking, Grantable Privileges
- grants
- automatic, CREATE TABLE
- explicit
(GRANT), Authorization — Grant Table or View Authority
- grantable
privileges, Grantable Privileges
- implicit
(CREATE TABLE), CREATE TABLE
- issuing, GRANT
- issuing
for DBEFileSet, Parameters — 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
simple queries, Using the SELECT Statement
- group
names
- 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
- 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
- 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 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, Parameters — 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
- 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 TRANSACTION, SET TRANSACTION
- ISQL
- defined, ALLBASE/SQL Components
- EXECUTE
PROCEDURE in, Using a Procedure Cursor in ISQL
- using
to issue statements, Scoping of Transaction and Session Attributes
- IX lock
- explained, Types of Locks
J- join
- algorithm
specified by SETOPT, SETOPT
- asymmetric, Outer Joins Using Explicit JOIN syntax
- in
complex queries, Complex Queries
- inner
and outer, Parameters — non-BULK HostVariableSpecification
- natural, Description — Query Block Level
- nested
loop, Syntax — Join Algorithm
- not
using explicit join syntax, Description — Query Block Level
- outer
join, Outer Joins Using the UNION Operator
- sort
merge, Syntax — Join Algorithm
- symmetric, Outer Joins Using Explicit JOIN syntax
- three
or more tables, Description — Query Block Level
- JOIN
ON
- in SELECT, Parameters — FromSpec
- JOIN USING
- in
SELECT, Parameters — FromSpec, Description — Query Block Level
- joining
tables
- in
SELECT, Description — Query Block Level
- in simple queries, Simple Queries
L- 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
- 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, Parameters — NewLogDefinition, 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, Assignment (=)
- authorization in CREATE TABLE, Authorization
- LONG
data type
- 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- 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
- 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 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
- 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
- number
5000, Description
- MICROFOCUS
- COBOL
preprocessor, ALLBASE/SQL Components
- minimum
- PrimaryPages, Parameters—CREATE TABLE
- mixed DBEFiles, CREATE DBEFILE
- module
names
- in DROP MODULE, DROP MODULE
- in
PREPARE, PREPARE
- 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- n-computer
- and
double quotes, Specifying Native Language Tables and Columns
- defined, Native Language Support
- 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
- 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
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
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
- outer join
- defined, Outer Joins
- syntax, Parameters — non-BULK HostVariableSpecification
- using
UNION operator, Outer Joins Using the UNION Operator
- 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
- 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 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
- 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
- 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
single format multiple row sets, Description
- procedure
cursor
- 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, Authorization — Grant Table or View 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, Authorization — Grant Table or View 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
- 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
- grants
using CASCADE, Grantable Privileges
- RIGHT OUTER
JOIN
- in SELECT, 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 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, Authorization — Grant Table or View Authority
- purpose, Authorization
- 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
- 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
- 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 SESSION
- 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
- RU isolation level, Parameters
- serializable isolation level, Parameters
- 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 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
- timeout
values, Setting Timeout Values
- transaction
mode, Setting the Transaction Mode
- setting
DML ATOMICITY
- with SET TRANSACTION, SET TRANSACTION
- setting DML atomicity, How Constraints are Enforced
- setting
transaction attributes
- 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 RUN or EXECUTE or 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
- 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 %%Variable%%, DECLARE Variable
- DECLARE
CURSOR, DECLARE CURSOR
- 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
- GRANT, GRANT
- GRANT ON DBEFILESET, Parameters — Grant DBEFileSet Authority
- IF, IF
- INCLUDE, INCLUDE
- INSERT, INSERT
- Labeled
Statement, Labeled Statement
- length, SQL Statements A - D
- 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 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 A - D
- 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, Authorization — Grant RUN or EXECUTE Authority
- monitoring
locking, Monitoring Locking with SQLMON
- monitoring
transactions, Monitoring Transactions
- SQLUtil
- defined, Utility Programs
- setting
transaction limits, Transaction Limits and Timeouts
- wrapdbe
command, Using Wrapper DBEnvironments
- SQLVer
- defined, Utility Programs
- 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
- 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
- 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
- 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, Description
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 TRANSACTION, SET TRANSACTION
- THEN
- in
procedures, IF
- 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
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
- transaction
attributes
- setting in BEGIN WORK, BEGIN WORK
- setting in SET TRANSACTION, SET TRANSACTION
- transaction
level constraint checking
- errors, SET CONSTRAINTS
- 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
- 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
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
expressions, Description
- in search conditions, Description
U- 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
- 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
- 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
- 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 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
- updatable, Updatability of Queries
- uses
for, Creating a View
- WITH
CHECK OPTION, Check Constraints
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
|