HP 3000 Manuals HP 3000 Manuals
Index
A
adding a column with ALTER TABLE
adding a constraint
with ALTER TABLE
ALTER TABLE statement
used to add a column
used to add a constraint
used to drop a constraint
authorization
authorize once per session flag
for static conversion mode preprocessing
authorize once per session flag
B
built-in variables
use in procedures
BULK INSERT statement
use with dynamic parameters
C
check constraints
used in a table
used in a view
C host variables
for binary data
sqlbinary
sqlvarbinary
circular referential constraints
example of resolving
COBOL host variables
initializing with the VALUE clause
COBOL record descriptions
for non-bulk queries
column
adding
conversion
actual to default data types for dynamic parameters
CREATE PROCEDURE statement
parameter mapping to EXECUTE PROCEDURE parameters
specifying an OUTPUT parameter
D
data buffer
use with dynamic parameters
data integrity
error checking levels
introduction to
number of rows processed
statement level versus row level
debugging
using the PRINT statement for
DECLARE CURSOR statement
use with static conversion mode preprocessing
default data formats
for dynamic parameters
default data types
use with dynamic parameters
deferring constraint error checking
for referential constraints
for row level integrity
introduction to
defining a constraint
for a view
definitions
dynamic application
dynamic parameter
dynamic statement
multi-connect functionality
multi-transaction mode
procedure
row level integrity
severe error
single transaction mode
statement level integrity
static application
static conversion processing
static statement
dropping a constraint
for a view
with ALTER TABLE
dynamic application
defined
ways to create
dynamic parameters
conversion of actual to default data types
data buffer and format array must correspond
data overflow and truncation
default data formats
default data types used with
defined
example in COBOL using a BULK INSERT statemen
example in C using a BULK INSERT statemen
example in C using data structures and data buffers
example in Pascal using a BULK INSERT statemen
introduction to programming with
restrictions
usage by programming language
use with a BULK INSERT statemen
use with a data buffer
use with an SQLDA structure
use with data structures and a data buffer
use with host variables for non-bulk processing
use with the PREPARE statement
where to use
dynamic parameter substitution
introduction to
dynamic statement
defined
E
error checking
default level
defaults for integrity constraints
deferring for constraint errors and row level integrity
deferring for integrity constraints
example for timeouts
example of resolving circular constraints
in a procedure
locating multiple column referential constraint errors
locating multiple column unique constraint errors
locating single column referential constraint errors
locating single column unique constraint errors
setting the level
statement or row level
example comparing procedure code to application code
example in C
calling a procedure from an application
checking for all errors and warnings on return from a procedure
comparing procedure code to application code
executing a procedure that returns an OUTPUT parameter
executing a procedure with a return status code
host variable declaration for a procedure
preparing a statement with dynamic parameters
returning a built-in variable from a procedure
using a BULK INSERT statement with dynamic parameters
using data structures and data buffers to process a prepared
statement with dynamic parameters
using the PRINT statement
example in COBOL
calling a procedure from an application
checking for all errors and warnings on return from a procedure
comparing procedure code to application code
executing a procedure that returns an OUTPUT parameter
executing a procedure with a return status code
host variable declaration for a procedure
preparing a statement with dynamic parameters
returning a built-in variable from a procedure
using a BULK INSERT statement with dynamic parameters
using the PRINT statement
example in FORTRAN
preparing a statement with dynamic parameters
example in Pascal
preparing a statement with dynamic parameters
using a BULK INSERT statement with dynamic parameters
example of checking for a timeout error
example of creating a procedure
example of setting a timeout value
example of single-transaction mode with timeouts
example of timeouts with multi-connect functionality
example PRINT statement
example RAISE ERROR statement
EXECUTE PROCEDURE statement
example in an application
parameter mapping to CREATE PROCEDURE parameters
passing null values with
SQLCODE and SQLWARN0 settings when procedure does not exist
use with a return status code
G
GENPLAN statement
converting a query to
introduction to
used to analyze a query
used to tune performance
H
host variables
example declaration for a procedure
for binary data in a C application
to pass parameter values to and from a procedure
I
indicator variables
introduction to
use in expressions
infinite waits
preventing with timeouts
integrity constraints
adding
deferring
defining and dropping for a table
defining and dropping for a view
dropping
error checking defaults
example of resolving circular referential constraints
introduction to
locating errors
locating multiple column referential constraint errors
locating multiple column unique constraint errors
locating single column referential constraint errors
locatingsingle column unique constraint errors
table check
view check
WITH CHECK OPTION
introduction to multi-connect functionality
L
locating errors
integrity constraints
locks
related to a wait queue
M
messages
defining procedure error messages with RAISE ERROR
defining procedure warning messages with PRINT
handling in a procedure
multi-connect functionality
defined
example using single-transaction mode with timeouts
introduction to
permits one active transaction per connection
permits one DBEnvironment per transaction
preprocessing and installing applications
multi-transaction mode
defined
preventing infinite waits
preventing undetectable deadlocks
N
null values
passing from an application to a procedure
number of rows processed
data integrity
O
OUTPUT parameter
returning data values from a procedure
P
parameter substitution
introduction to
performance
static conversion mode preprocessing
tuning using GENPLAN statement
tuning using timeouts
PREPARE statement
use with dynamic parameters
preprocessing
introduction to static conversion mode
preprocessing and installing applications
with multi-connect functionality
preprocessing messages generated
for procedures
PRINT statement
example in C
example in COBOL
returning user defined warning messages from a procedure
use in debugging
procedure parameters
using host variables for
procedures
checking for all errors and warnings on return from
comparing a procedure to an application program
defined
error checking in
introduction to use in an application program
message handling in
obtaining the statement number with SQLEXPLAIN
preprocessing messages generated
returning a return status code from
returning data values in an OUTPUT parameter
runtime messages generated
SQLCODE set to non-zero if procedure not executed
SQLCODE set to non-zero when returning from
SQLCODE set to zero
SQLWARN0 set to W if error messages were generated
SQLWARN0 set to W if PRINT statement messages are generated
statement numbers assigned
using built-in variables in
using the RETURN statement for a built-in variable
R
RAISE ERROR statement
example
returning user defined error messages from a procedure
RecDB database application design
example of resolving circular referential constraints
referential constraints
example of resolving circular constraints
restrictions
dynamic parameters
static conversion mode preprocessing
RETURN statement
to return a built-in variable from a procedure
return status code
declaring in an application
returning from a procedure
undefined when SQLCODE is not zero
row level integrity defined
runtime messages generated
for procedures
S
SET CONSTRAINTS statement
used to defer constraint error checking
used to detect constraint errors
SET DML ATOMICITY statement
used to set error checking level
severe error
defined
single-transaction mode
example using timeouts
single transaction mode
defined
sqlbinary host variable
use with binary data in a C application
SQLCODE
message catalog number contained following procedure execution
set to non-zero
testing on return from a procedure
SQLDA
use with dynamic parameters
SQLEXPLAIN
using on return from a procedure
sqlvarbinary host variable
use with varbinary data in a C application
SQLWARN0
set to W if PRINT statement messages are generated
testing on return from a procedure
statement level integrity
defined
static application
defined
static conversion mode preprocessing
authorization
DECLARE CURSOR statement usage
introduction to
performance enhancement
restrictions based on dynamic parameters
syntax for C
syntax for Pascal
static conversion processing
defined
static statement
defined
syntax for static conversion mode preprocessing
T
table check constraints
template
to locate multiple column referential constraint errors
to locate multiple column unique constraint errors
to locate single column referential constraint errors
to locate single column unique constraint errors
timeouts
changing a timeout value
default timeout value
example of checking for a timeout error
example of setting a timeout value
locking and transaction management strategies
related to a wait queue
temporarily overriding a timeout value
to prevent infinite waits
to prevent undetectable deadlocks
to tune performance
use with multi-connect functionality
using SQLUtil to see DBECon file timeout values
transaction slots
related to a wait queue
U
undetectable deadlocks
possible in multi-transaction mode
preventing with timeouts
V
VALIDATE statement
introduction to
not for sections never validated under F.0 release
use following UPDATE STATISTICS statement
view check constraints
defining and dropping
not deferrable
W
wait queue
related to locks
related to timeouts
related to transaction slots
WHENEVER SQLERROR STOP statement
effect in a procedure
WITH CHECK OPTION
used to define a view check constraint