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
ANSI setting
in full preprocessing mode
in POSIX full preprocessing mode
in POSIX static conversion mode preprocessing
in POSIX syntax checking mode preprocessing
in syntax checking mode preprocessing
authorization
authorize once per session flag
for full preprocessing mode
for static conversion mode preprocessing
for syntax checking mode preprocessing
authorize once per session flag
B
BEGIN WORK
issued by preprocessor
built-in variables
use in procedures
BULK INSERT statement
use with dynamic parameters
bulk processing
and static conversion mode preprocessing
C
check constraints
used in a table
used in a view
CHECKPOINT
before preprocessing
circular referential constraints
example of resolving
COBOL host variables
initializing with the VALUE clause
COBOL record descriptions
for non-bulk queries
column
adding
COMMIT WORK
issued by preprocessor
CONNECT
issued by preprocessor
conversion
actual to default data types for dynamic parameters
CREATE PROCEDURE statement
parameter mapping to EXECUTE PROCEDURE parameters
specifying an OUTPUT parameter
cursor
use with procedures
D
data buffer
use with dynamic parameters
data integrity
error checking levels
introduction to
number of rows processed
statement level versus row level
DBEFileSet authority
when preprocessing
DBEFileSetName
in full preprocessing mode
in POSIX full preprocessing mode
overridden in preprocessing
DBEnvironment access
and preprocessing
during full preprocessing
not required during full preprocessing
DBEnvironment name
not required during full preprocessing
DBE session
in preprocessing
debugging
using the PRINT statement for
DECLARE CURSOR
and static conversion mode preprocessing
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
definition
procedure cursor
select cursor
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
dropping a module
in full preprocessing mode
DYMANIC option
in static conversion mode preprocessing
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
input and output
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
with cursor processing
with EXECUTE PROCEDURE
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
full preprocessing
syntax checking mode preprocessing
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
F
FIPS 127.1
defined
FIPS flagger
and declaring the SQLCA
and host variable data type declarations
and host variable names
and implicit updatability
and non-standard secondary references
coding tips
identifying non-standard features
introduction to
setting the ANSI compiler directive
flagger setting
in full preprocessing mode
in POSIX full preprocessing mode
in POSIX static conversion mode preprocessing
in POSIX syntax checking mode preprocessing
in static conversion mode preprocessing
in syntax checking mode preprocessing
full preprocessing
example
full preprocessing mode
introduction to
parameters
syntax
G
GENPLAN statement
converting a query to
introduction to
used to analyze a query
used to tune performance
H
host variable data types
and the FIPS flagger
host variable names
and the FIPS flagger
host variables
example declaration for a procedure
for dynamic input and output parameters
to pass parameter values to and from a procedure
I
implicit updatability
and ALLBASE/SQL default updatability
and preprocessing
and the FIPS flagger
explained
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
i option
preprocesor syntax checking mode
L
link command
in preprocessing
locating errors
integrity constraints
locks
related to a wait queue
log file space
use during preprocessing
M
messages
defining procedure error messages with RAISE ERROR
defining procedure warning messages with PRINT
handling in a procedure
modified source file
in POSIX static conversion mode preprocessing
in POSIX syntax checking mode preprocessing
modified source file name
in POSIX full preprocessing mode
module
name
revoking RUN authority
module dropping
in full preprocessing mode
in POSIX full preprocessing mode
module name
in full preprocessing mode
in POSIX full preprocessing mode
module owner
in full preprocessing mode
in POSIX full preprocessing mode
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
multiple DBEnvironment access
and preprocessing
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
owner name
in POSIX full preprocessing mode
P
parameter substitution
introduction to
performance
static conversion mode preprocessing
tuning using GENPLAN statement
tuning using timeouts
POSIX preprocessor invocation
introduction to
PREPARE statement
use with dynamic parameters
preprocessing
DBEFileSetName overridden
introduction to static conversion mode
introduction to syntax checking mode
POSIX preprocessor invocation
preprocessing and installing applications
with multi-connect functionality
preprocessing messages generated
for procedures
preprocessing session
preprocessor
accessing multiple DBEnvironments
and CONNECT
and DBEFileSet authority
and DBEnvironment language
and implicit updatability
and linking
and row level locking
and START DBE
and UPDATE STATISTICS
authorization for full preprocessing mode
authorization for static conversion mode
authorization for syntax checking mode
bulk processing in static conversion mode
DBE sessions
DECLARE CURSOR in static conversion mode
full preprocessing mode
introduction to full preprocessing mode
POSIX full preprocessing options
POSIX static conversion mode
POSIX syntax checking mode
syntax checking mode
preprocessor invocation
for POSIX
PRINT statement
example in C
example in COBOL
returning user defined warning messages from a procedure
use in debugging
procedure cursor
available functionality
defined
procedure parameters
for dynamic 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
revoking RUN authority
in full preprocessing mode
in POSIX full preprocessing mode
ROLLBACK WORK
issued by preprocessor
rollforward logging
and preprocessing
row level integrity defined
RUN authority
in full preprocessing mode
in POSIX full preprocessing mode
runtime messages generated
for procedures
S
sample database
authorities
secondary references to non-standard objects
and the FIPS flagger
sections
not stored during full preprocessing
select cursor
available functionality
defined
session
in preprocessing
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
source file name
in POSIX full preprocessing mode
in POSIX static conversion mode preprocessing
in POSIX syntax checking mode preprocessing
SQLCA declaration
and the FIPS flagger
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
SQLWARN0
set to W if PRINT statement messages are generated
testing on return from a procedure
START DBE
and the preprocessor
START DBE NEWLOG
to increase log space
statement level integrity
defined
static application
defined
static conversion mode preprocessing
authorization
DECLARE CURSOR statement usage
introduction to
parameters
performance enhancement
restrictions based on dynamic parameters
syntax for C
syntax for Pascal
static conversion processing
defined
static statement
defined
syntax checking mode
syntax
syntax checking mode preprocessing
example
introduction to
parameters
syntax for full preprocessing mode
syntax for static conversion mode preprocessing
system catalog
pages locked during 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
updatability
and the FIPS flagger
implicit
UPDATE STATISTICS
before preprocessing
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