HPlogo ALLBASE/SQL Advanced Application Programming Guide: HP 3000 MPE/iX Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

A

adding a column with ALTER TABLE, Adding a Column to the Recreation Database
adding a constraint
with ALTER TABLE, Adding a Constraint to the Recreation Database
ALTER TABLE statement
used to add a column, Adding a Column to the Recreation Database
used to add a constraint, Adding a Constraint to the Recreation Database
used to drop a constraint, Dropping a Constraint from the Recreation Database
ANSI setting
in full preprocessing mode, Parameters, Parameters
in POSIX full preprocessing mode, Parameters
in POSIX static conversion mode preprocessing, Parameters
in POSIX syntax checking mode preprocessing, Parameters
in syntax checking mode preprocessing, Parameters
authorization
authorize once per session flag, Enhancing Performance
for full preprocessing mode, Description
for static conversion mode preprocessing, Authorization
for syntax checking mode preprocessing, Authorization
authorize once per session flag, Enhancing Performance

B

BEGIN WORK
issued by preprocessor, Description
built-in variables
use in procedures, Messages from the Last SQL Statement Executed by the Procedure
BULK INSERT statement
use with dynamic parameters, Using a BULK INSERT Statement with Dynamic Parameters
bulk processing
and static conversion mode preprocessing, Description

C

check constraints
used in a table, Using Table Check Constraints
used in a view, Defining and Dropping View Constraints
CHECKPOINT
before preprocessing, Description
circular referential constraints
example of resolving, Coding with Deferred Constraint Error Checking
COBOL host variables
initializing with the VALUE clause, Host Variables Initialized With The VALUE Clause
COBOL record descriptions
for non-bulk queries, Record Descriptions For Non-Bulk Queries
column
adding, Adding a Column to the Recreation Database
COMMIT WORK
issued by preprocessor, Description, DBEnvironment Access in Full Preprocessing Mode
CONNECT
issued by preprocessor, Description
conversion
actual to default data types for dynamic parameters, Conversion of Actual Data Types to Default Data Types
CREATE PROCEDURE statement
parameter mapping to EXECUTE PROCEDURE parameters, Using Host Variables to Pass Parameter Values
specifying an OUTPUT parameter, Returning Output Values
cursor
use with procedures, Using Cursors with Procedures

D

data buffer
use with dynamic parameters, Using the Data Buffer for Input
data integrity
error checking levels, Setting the Error Checking Level
introduction to, Using Data Integrity Features
number of rows processed , Setting the Error Checking Level
statement level versus row level, Setting the Error Checking Level
DBE session
in preprocessing, Description
DBEFileSet authority
when preprocessing, Description
DBEFileSetName
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
overridden in preprocessing, Parameters
DBEnvironment access
and preprocessing, Accessing Multiple DBEnvironments in Full Preprocessing Mode
during full preprocessing, DBEnvironment Access in Full Preprocessing Mode
not required during full preprocessing, DBEnvironment Access in Full Preprocessing Mode
DBEnvironment name
not required during full preprocessing, Parameters
debugging
using the PRINT statement for, Messages from the PRINT Statement
DECLARE CURSOR
and static conversion mode preprocessing, Description
DECLARE CURSOR statement
use with static conversion mode preprocessing, Converting a Static Application to a Dynamic Application
default data formats
for dynamic parameters, Dynamic Parameter Formats
default data types
use with dynamic parameters, Using Default Data Types with Dynamic Parameters
deferring constraint error checking
for referential constraints, Deferring Constraint Error Checking
for row level integrity, Deferring Constraint Error Checking
introduction to, Deferring Constraint Error Checking
defining a constraint
for a view, Defining and Dropping View Constraints
definition
procedure cursor, Using Cursors with Procedures
select cursor, Using Cursors with Procedures
definitions
dynamic application, Comparing Static and Dynamic Applications
dynamic parameter, Understanding Dynamic Parameters
dynamic statement, Comparing Static and Dynamic SQL
multi-connect functionality, Transaction Management with Multiple DBEnvironment Connections
multi-transaction mode, Transaction Management with Multiple DBEnvironment Connections
procedure, Using Procedures in Application Programs
row level integrity, Setting the Error Checking Level
severe error, Using Procedures in Application Programs
single transaction mode, Transaction Management with Multiple DBEnvironment Connections
statement level integrity, Setting the Error Checking Level
static application, Comparing Static and Dynamic Applications
static conversion processing, Static Conversion Mode
static statement, Comparing Static and Dynamic SQL
dropping a constraint
for a view, Defining and Dropping View Constraints
with ALTER TABLE, Dropping a Constraint from the Recreation Database
dropping a module
in full preprocessing mode, Parameters
DYMANIC option
in static conversion mode preprocessing, Parameters
dynamic application
defined, Comparing Static and Dynamic Applications
ways to create, Comparing Static and Dynamic Applications
dynamic parameter substitution
introduction to, Using Parameter Substitution in Dynamic Statements
dynamic parameters
conversion of actual to default data types, Conversion of Actual Data Types to Default Data Types
data buffer and format array must correspond, Using the SQLDA for Input
data overflow and truncation, Data Overflow and Truncation
default data formats, Dynamic Parameter Formats
default data types used with, Using Default Data Types with Dynamic Parameters
defined, Understanding Dynamic Parameters
example in C using a BULK INSERT statemen, Example in C Using a BULK INSERT
example in C using data structures and data buffers, Example in C Using Output and Input Data Buffers
example in COBOL using a BULK INSERT statemen, Example in COBOL Using a BULK INSERT
example in Pascal using a BULK INSERT statemen, Example in Pascal Using a BULK INSERT
input and output, Using Dynamic Procedure Parameters
introduction to programming with, Programming with Dynamic Parameters
restrictions, Restrictions
usage by programming language, Programming with Dynamic Parameters
use with a BULK INSERT statemen, Using a BULK INSERT Statement with Dynamic Parameters
use with a data buffer, Using the Data Buffer for Input
use with an SQLDA structure, Using the SQLDA for Input
use with data structures and a data buffer, Using Data Structures and a Data Buffer to Process Dynamic Parameters
use with host variables for non-bulk processing, Using Host Variables to Process Dynamic Parameters
use with the PREPARE statement, Understanding Dynamic Parameters
where to use, Where to Use Dynamic Parameters
with cursor processing, Using Dynamic Procedure Parameters
with EXECUTE PROCEDURE, Using Dynamic Procedure Parameters
dynamic statement
defined, Comparing Static and Dynamic SQL

E

error checking
default level, Setting the Error Checking Level
defaults for integrity constraints, Deferring Constraint Error Checking
deferring for constraint errors and row level integrity, Deferring Constraint Error Checking
deferring for integrity constraints, Deferring Constraint Error Checking
example for timeouts, Understanding Timeouts
example of resolving circular constraints, Coding with Deferred Constraint Error Checking
in a procedure, Additional Error and Message Handling
locating multiple column referential constraint errors, Template for Multiple Column Referential Constraint Errors
locating multiple column unique constraint errors, Template for Multiple Column Unique Constraint Errors
locating single column referential constraint errors, Template for Single Column Referential Constraint Errors
locating single column unique constraint errors, Template for Single Column Unique Constraint Errors
setting the level, Setting the Error Checking Level
statement or row level, Setting the Error Checking Level
example
full preprocessing, Authorization
syntax checking mode preprocessing, Example of Syntax Checking of a C Application
example comparing procedure code to application code, Comparing a Procedure and an Embedded SQL Application
example in C
calling a procedure from an application, Using Host Variables to Pass Parameter Values
checking for all errors and warnings on return from a procedure, Checking for All Errors and Warnings
comparing procedure code to application code, Comparing a Procedure and an Embedded SQL Application
executing a procedure that returns an OUTPUT parameter, Returning Output Values
executing a procedure with a return status code, Returning a Return Status Code
host variable declaration for a procedure, Using Host Variables to Pass Parameter Values
preparing a statement with dynamic parameters, Examples in C of Preparing a Statement with Dynamic Parameters
returning a built-in variable from a procedure, Messages from the Last SQL Statement Executed by the Procedure
using a BULK INSERT statement with dynamic parameters, Example in C Using a BULK INSERT
using data structures and data buffers to process a prepared statement with dynamic parameters, Example in C Using Output and Input Data Buffers
using the PRINT statement, Messages from the PRINT Statement
example in COBOL
calling a procedure from an application, Using Host Variables to Pass Parameter Values
checking for all errors and warnings on return from a procedure, Checking for All Errors and Warnings
comparing procedure code to application code, Comparing a Procedure and an Embedded SQL Application
executing a procedure that returns an OUTPUT parameter, Returning Output Values
executing a procedure with a return status code, Returning a Return Status Code
host variable declaration for a procedure, Using Host Variables to Pass Parameter Values
preparing a statement with dynamic parameters, Examples in COBOL of Preparing a Statement with Dynamic Parameters
returning a built-in variable from a procedure, Messages from the Last SQL Statement Executed by the Procedure
using a BULK INSERT statement with dynamic parameters, Example in COBOL Using a BULK INSERT
using the PRINT statement, Messages from the PRINT Statement
example in FORTRAN
preparing a statement with dynamic parameters, Examples in FORTRAN of Preparing a Statement with Dynamic Parameters
example in Pascal
preparing a statement with dynamic parameters, Examples in Pascal of Preparing a Statement with Dynamic Parameters
using a BULK INSERT statement with dynamic parameters, Example in Pascal Using a BULK INSERT
example of checking for a timeout error, Understanding Timeouts
example of creating a procedure, Using Host Variables to Pass Parameter Values
example of setting a timeout value, Understanding Timeouts
example of single-transaction mode with timeouts, Example Using Single-transaction Mode with Timeouts
example of timeouts with multi-connect functionality, Example Using Single-transaction Mode with Timeouts
example PRINT statement, Messages from the PRINT Statement
example RAISE ERROR statement, Messages from Errors Caused by the RAISE ERROR Statement
EXECUTE PROCEDURE statement
example in an application, Using Host Variables to Pass Parameter Values
parameter mapping to CREATE PROCEDURE parameters, Using Host Variables to Pass Parameter Values
passing null values with, Using Host Variables to Pass Parameter Values
SQLCODE and SQLWARN0 settings when procedure does not exist, Messages from Failure of the EXECUTE PROCEDURE Statement
use with a return status code, Returning a Return Status Code

F

FIPS 127.1
defined, Flagging Non-Standard SQL with the FIPS Flagger
FIPS flagger
and declaring the SQLCA, Declaring the SQLCA
and host variable data type declarations, Host Variable Data Type Declarations
and host variable names, Host Variable Name Length Standards
and implicit updatability, Understanding Implicit Updatability
and non-standard secondary references, Secondary References to Non-Standard SQL
coding tips, Coding Tips
identifying non-standard features, Identifying Non-Standard Features
introduction to, Flagging Non-Standard SQL with the FIPS Flagger
setting the ANSI compiler directive, Setting the ANSI Compiler Directive
flagger setting
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
in POSIX static conversion mode preprocessing, Parameters
in POSIX syntax checking mode preprocessing, Parameters
in static conversion mode preprocessing, Parameters
in syntax checking mode preprocessing, Parameters
full preprocessing
example, Authorization
full preprocessing mode
introduction to, Full Preprocessing Mode
parameters, Parameters
syntax, Full Preprocessing Mode Syntax Specification

G

GENPLAN statement
converting a query to, Analyzing Queries with GENPLAN
introduction to, Analyzing Queries with GENPLAN
used to analyze a query, Analyzing Queries with GENPLAN
used to tune performance, Analyzing Queries with GENPLAN

H

host variable data types
and the FIPS flagger, Host Variable Data Type Declarations
host variable names
and the FIPS flagger, Host Variable Name Length Standards
host variables
example declaration for a procedure, Using Host Variables to Pass Parameter Values
for dynamic input and output parameters, Using Dynamic Procedure Parameters
to pass parameter values to and from a procedure, Using Host Variables to Pass Parameter Values

I

i option
preprocesor syntax checking mode, Parameters
implicit updatability
and ALLBASE/SQL default updatability, Understanding Implicit Updatability
and preprocessing, Description
and the FIPS flagger, Understanding Implicit Updatability
explained, Understanding Implicit Updatability
indicator variables
introduction to, Programming with Indicator Variables in Expressions
use in expressions, Programming with Indicator Variables in Expressions
infinite waits
preventing with timeouts, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
integrity constraints
adding, Adding a Constraint to the Recreation Database
deferring, Deferring Constraint Error Checking
defining and dropping for a table, Defining and Dropping Table Constraints
defining and dropping for a view, Defining and Dropping View Constraints
dropping, Dropping a Constraint from the Recreation Database
error checking defaults, Deferring Constraint Error Checking
example of resolving circular referential constraints, Coding with Deferred Constraint Error Checking
introduction to, Using Data Integrity Features
locating errors, Locating Constraint Errors
locating multiple column referential constraint errors, Template for Multiple Column Referential Constraint Errors
locating multiple column unique constraint errors, Template for Multiple Column Unique Constraint Errors
locating single column referential constraint errors, Template for Single Column Referential Constraint Errors
locatingsingle column unique constraint errors, Template for Single Column Unique Constraint Errors
table check, Using Table Check Constraints
view check, Defining and Dropping View Constraints
WITH CHECK OPTION, Defining and Dropping View Constraints
introduction to multi-connect functionality, Transaction Management with Multiple DBEnvironment Connections

L

link command
in preprocessing, Accessing Multiple DBEnvironments in Full Preprocessing Mode
locating errors
integrity constraints, Locating Constraint Errors
locks
related to a wait queue, Understanding Timeouts
log file space
use during preprocessing, Description

M

messages
defining procedure error messages with RAISE ERROR, Messages from Errors Caused by the RAISE ERROR Statement
defining procedure warning messages with PRINT, Messages from the PRINT Statement
handling in a procedure, Additional Error and Message Handling
modified source file
in POSIX static conversion mode preprocessing, Parameters
in POSIX syntax checking mode preprocessing, Parameters
modified source file name
in POSIX full preprocessing mode, Parameters
module
name, DBEnvironment Access in Full Preprocessing Mode
revoking RUN authority, Parameters
module dropping
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
module name
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
module owner
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
multi-connect functionality
defined, Transaction Management with Multiple DBEnvironment Connections
example using single-transaction mode with timeouts, Example Using Single-transaction Mode with Timeouts
introduction to, Transaction Management with Multiple DBEnvironment Connections
permits one active transaction per connection, Transaction Management with Multiple DBEnvironment Connections
permits one DBEnvironment per transaction, Transaction Management with Multiple DBEnvironment Connections
preprocessing and installing applications, Preprocessing and Installing Applications
multi-transaction mode
defined, Transaction Management with Multiple DBEnvironment Connections
preventing infinite waits, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
preventing undetectable deadlocks, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
multiple DBEnvironment access
and preprocessing, Accessing Multiple DBEnvironments in Full Preprocessing Mode

N

null values
passing from an application to a procedure, Using Host Variables to Pass Parameter Values
number of rows processed
data integrity, Setting the Error Checking Level

O

OUTPUT parameter
returning data values from a procedure, Returning Output Values
owner name
in POSIX full preprocessing mode, Parameters

P

parameter substitution
introduction to, Using Parameter Substitution in Dynamic Statements
performance
static conversion mode preprocessing, Enhancing Performance
tuning using GENPLAN statement, Analyzing Queries with GENPLAN
tuning using timeouts, Using Timeouts to Tune Performance
POSIX preprocessor invocation
introduction to, POSIX Preprocessor Invocation
PREPARE statement
use with dynamic parameters, Understanding Dynamic Parameters
preprocessing
DBEFileSetName overridden, Parameters
introduction to static conversion mode, Static Conversion Mode
introduction to syntax checking mode, Syntax Checking Mode
POSIX preprocessor invocation, POSIX Preprocessor Invocation
preprocessing and installing applications
with multi-connect functionality, Preprocessing and Installing Applications
preprocessing messages generated
for procedures, Additional Error and Message Handling
preprocessing session , Description
preprocessor
accessing multiple DBEnvironments, Accessing Multiple DBEnvironments in Full Preprocessing Mode
and CONNECT, Description
and DBEFileSet authority, Description
and DBEnvironment language, Description
and implicit updatability, Description
and linking, Accessing Multiple DBEnvironments in Full Preprocessing Mode
and row level locking, Description
and START DBE, Description
and UPDATE STATISTICS, Description
authorization for full preprocessing mode, Description
authorization for static conversion mode, Authorization
authorization for syntax checking mode, Authorization
bulk processing in static conversion mode, Description
DBE sessions, DBEnvironment Access in Full Preprocessing Mode
DECLARE CURSOR in static conversion mode, Description
full preprocessing mode, Full Preprocessing Mode Syntax Specification
introduction to full preprocessing mode, Full Preprocessing Mode
POSIX full preprocessing options, POSIX Full Preprocessing Mode for C Applications
POSIX static conversion mode, POSIX Static Conversion Mode for C Applications
POSIX syntax checking mode, POSIX Syntax Checking Mode for C Applications
syntax checking mode, Syntax Checking Mode Syntax Specification
preprocessor invocation
for POSIX, POSIX Preprocessor Invocation
PRINT statement
example in C, Messages from the PRINT Statement
example in COBOL, Messages from the PRINT Statement
returning user defined warning messages from a procedure, Messages from the PRINT Statement
use in debugging, Messages from the PRINT Statement
procedure cursor
available functionality, Using Cursors with Procedures
defined, Using Cursors with Procedures
procedure parameters
for dynamic parameters, Using Dynamic Procedure Parameters
using host variables for, Using Host Variables to Pass Parameter Values
procedures
checking for all errors and warnings on return from, Checking for All Errors and Warnings
comparing a procedure to an application program, Comparing a Procedure and an Embedded SQL Application
defined, Using Procedures in Application Programs
error checking in, Additional Error and Message Handling
introduction to use in an application program, Using Procedures in Application Programs
message handling in, Additional Error and Message Handling
obtaining the statement number with SQLEXPLAIN, Messages from the Last SQL Statement Executed by the Procedure
preprocessing messages generated, Additional Error and Message Handling
returning a return status code from, Returning a Return Status Code
returning data values in an OUTPUT parameter, Returning Output Values
runtime messages generated, Additional Error and Message Handling
SQLCODE set to non-zero if procedure not executed, Testing SQLCODE and SQLWARN0 on Return from a Procedure
SQLCODE set to non-zero when returning from, Testing SQLCODE and SQLWARN0 on Return from a Procedure
SQLCODE set to zero, Testing SQLCODE and SQLWARN0 on Return from a Procedure
SQLWARN0 set to W if error messages were generated, Testing SQLCODE and SQLWARN0 on Return from a Procedure
SQLWARN0 set to W if PRINT statement messages are generated, Messages from the PRINT Statement
statement numbers assigned, Messages from the Last SQL Statement Executed by the Procedure
using built-in variables in, Messages from the Last SQL Statement Executed by the Procedure
using the RETURN statement for a built-in variable, Messages from the Last SQL Statement Executed by the Procedure

R

RAISE ERROR statement
example, Messages from Errors Caused by the RAISE ERROR Statement
returning user defined error messages from a procedure, Messages from Errors Caused by the RAISE ERROR Statement
RecDB database application design
example of resolving circular referential constraints, Coding with Deferred Constraint Error Checking
referential constraints
example of resolving circular constraints, Coding with Deferred Constraint Error Checking
restrictions
dynamic parameters, Restrictions
static conversion mode preprocessing, Converting a Static Application to a Dynamic Application
RETURN statement
to return a built-in variable from a procedure, Messages from the Last SQL Statement Executed by the Procedure
return status code
declaring in an application, Returning a Return Status Code
returning from a procedure, Returning a Return Status Code
undefined when SQLCODE is not zero, Returning a Return Status Code
revoking RUN authority
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
ROLLBACK WORK
issued by preprocessor, Description
rollforward logging
and preprocessing, Description
row level integrity defined, Setting the Error Checking Level
RUN authority
in full preprocessing mode, Parameters
in POSIX full preprocessing mode, Parameters
runtime messages generated
for procedures, Additional Error and Message Handling

S

sample database
authorities, Authorization
secondary references to non-standard objects
and the FIPS flagger, Secondary References to Non-Standard SQL
sections
not stored during full preprocessing, Parameters
select cursor
available functionality, Using Cursors with Procedures
defined, Using Cursors with Procedures
session
in preprocessing, Description
SET CONSTRAINTS statement
used to defer constraint error checking, Deferring Constraint Error Checking
used to detect constraint errors, Locating Constraint Errors
SET DML ATOMICITY statement
used to set error checking level, Setting the Error Checking Level
severe error
defined, Using Procedures in Application Programs
single transaction mode
defined, Transaction Management with Multiple DBEnvironment Connections
single-transaction mode
example using timeouts, Example Using Single-transaction Mode with Timeouts
source file name, Parameters
in POSIX full preprocessing mode, Parameters
in POSIX static conversion mode preprocessing, Parameters
in POSIX syntax checking mode preprocessing, Parameters
SQLCA declaration
and the FIPS flagger, Declaring the SQLCA
SQLCODE
message catalog number contained following procedure execution, Additional Error and Message Handling
set to non-zero, Testing SQLCODE and SQLWARN0 on Return from a Procedure
testing on return from a procedure, Testing SQLCODE and SQLWARN0 on Return from a Procedure
SQLDA
use with dynamic parameters, Using the SQLDA for Input
SQLEXPLAIN
using on return from a procedure, Messages from the Last SQL Statement Executed by the Procedure
SQLWARN0
set to W if PRINT statement messages are generated, Messages from the PRINT Statement
testing on return from a procedure, Testing SQLCODE and SQLWARN0 on Return from a Procedure
START DBE
and the preprocessor, Description
START DBE NEWLOG
to increase log space, Description
statement level integrity
defined, Setting the Error Checking Level
static application
defined, Comparing Static and Dynamic Applications
static conversion mode preprocessing
authorization, Authorization
DECLARE CURSOR statement usage, Converting a Static Application to a Dynamic Application
introduction to, Static Conversion Mode
parameters, Parameters
performance enhancement, Enhancing Performance
restrictions based on dynamic parameters, Converting a Static Application to a Dynamic Application
syntax for C, Static Conversion Mode Syntax Specification
syntax for Pascal, Static Conversion Mode Syntax Specification
static conversion processing
defined, Static Conversion Mode
static statement
defined, Comparing Static and Dynamic SQL
syntax checking mode, Syntax Checking Mode
syntax, Syntax Checking Mode Syntax Specification
syntax checking mode preprocessing, Syntax Checking Mode Syntax Specification
example, Example of Syntax Checking of a C Application
introduction to, Syntax Checking Mode
parameters, Parameters
syntax for full preprocessing mode, Full Preprocessing Mode Syntax Specification
syntax for static conversion mode preprocessing, Static Conversion Mode Syntax Specification
system catalog
pages locked during preprocessing, Description

T

table check constraints, Using Table Check Constraints
template
to locate multiple column referential constraint errors, Template for Multiple Column Referential Constraint Errors
to locate multiple column unique constraint errors, Template for Multiple Column Unique Constraint Errors
to locate single column referential constraint errors, Template for Single Column Referential Constraint Errors
to locate single column unique constraint errors, Template for Single Column Unique Constraint Errors
timeouts
changing a timeout value, Understanding Timeouts
default timeout value, Understanding Timeouts
example of checking for a timeout error, Understanding Timeouts
example of setting a timeout value, Understanding Timeouts
locking and transaction management strategies, Understanding Timeouts
related to a wait queue, Understanding Timeouts
temporarily overriding a timeout value, Understanding Timeouts
to prevent infinite waits, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
to prevent undetectable deadlocks, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
to tune performance, Using Timeouts to Tune Performance
use with multi-connect functionality, Example Using Single-transaction Mode with Timeouts
using SQLUtil to see DBECon file timeout values, Understanding Timeouts
transaction slots
related to a wait queue, Understanding Timeouts

U

undetectable deadlocks
possible in multi-transaction mode, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
preventing with timeouts, Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
updatability
and the FIPS flagger, Understanding Implicit Updatability
implicit, Understanding Implicit Updatability
UPDATE STATISTICS
before preprocessing, Description

V

VALIDATE statement
introduction to, Using the VALIDATE Statement
not for sections never validated under F.0 release, Using the VALIDATE Statement
use following UPDATE STATISTICS statement, Using the VALIDATE Statement
view check constraints
defining and dropping, Defining and Dropping View Constraints
not deferrable, Defining and Dropping View Constraints

W

wait queue
related to locks, Understanding Timeouts
related to timeouts, Understanding Timeouts
related to transaction slots, Understanding Timeouts
WHENEVER SQLERROR STOP statement
effect in a procedure, Testing SQLCODE and SQLWARN0 on Return from a Procedure
WITH CHECK OPTION
used to define a view check constraint, Defining and Dropping View Constraints


Correcting the Pascal Language Program
  		 
Feedback to webmaster