HP 3000 Manuals HP 3000 Manuals
Index
A
access
optimization
validation
active set
ADD_MONTHS function
example with BULK SELECT
syntax
aggregate function
simple data manipulation
ALTER TABLE command
syntax for LONG columns
ANSI SQL1 level 2
specifying a default value
ANSI SQL86 level 2
floating point data
application development
arrays
BULK SELECT
declarations of
atomic operation
defined
authorization
and program maintenance
changing
dynamic preprocessing
granting
automatic rollback
autostart mode
B
BEGIN DECLARE SECTION
declaring host variables
BEGIN WORK
defining transactions
in transaction management
binary data
compatibility
host variable definition
how stored
using the LONG phrase with
BULK FETCH
basic uses of
BULK FETCH command
used in example program
BULK INSERT
basic uses of
BULK INSERT command
used in example program
used with LONG columns
bulk processing
INTO clause
bulk processing variables
BULK SELECT
basic uses
[BULK] SELECT command
used with LONG columns
BULK SELECT command
example with LONG columns
with ADD_MONTHS function
BULK table processing
BULK FETCH
BULK INSERT
BULK SELECT
commands
overview
sample program
techniques
C
CHAR data
CLOSE
before ending a transaction
freeing buffer space with
with COMMIT WORK
with KEEP CURSOR
COBEX10A
COBEX10B
COBEX2
COBEX5
COBEX7
COBEX8
COBEX9
COBOL compiler directives
$SQL COPY
$SQL NOCOPY
COBOL COPY statement
code expansion
compiler directives for
introduction to
REPLACING clause
use of NOLIST reserved word
where used
COBOL SET and IF statement
use of NOMIXED reserved word
COBOL SET and IF statements
where used
COBOL subprograms
coding considerations
for date/time functions
for LONG columns
column specifications for floating point data
comments, ALLBASE/SQL
comments, COBOL
COMMIT WORK
defining transactions
in transaction management
with CLOSE
with KEEP CURSOR
comparison predicate
compiler
separate compilable section
compiler directive
$INCLUDE
compiler directives
for COBOL COPY statement
compiling and linking
C subprogram COBOL calls
concurrency
CONNECT
CONNECT authority
with START DBE
constant
as default data value
constraint test matrix for integrity constraints
continuation lines
conversion
COPY statement in COBOL
code expansion
compiler directives for
introduction to
REPLACING clause
use of NOLIST reserved word
where used
CREATE TABLE command
syntax for LONG columns
C subprogram COBOL calls
CURRENT_DATE function result
used as default data value
CURRENT_DATETIME function result
used as default data value
current language
current row
DELETE WHERE CURRENT
CURRENT_TIME function result
used as default data value
cursor
and BULK FETCH
closing
deleting with
effect of commands on
introduction to
opening
positioning
updating with
use of
cursor processing
CLOSE
commands
DECLARE CURSOR
definition
DELETE WHERE CURRENT
FETCH
OPEN
techniques
transaction management
UPDATE and FETCH
UPDATE WHERE CURRENT
D
Database Environment Configuration File
data compatibility
binary
floating point
for date/time function parameters
for default data values
LONG binary
LONG varbinary
data consistency
in sample database
data definition
overview
data description entries
DATA DIVISION
data input using date/time functions
data integrity
changes to error checking
introduction to
number of rows processed
row level versus statement level
using sqlerrd[2]
data manipulation
commands
overview
techniques
data retrieval using date/time functions
data storage
binary data
data type
compatibility
data type conversion
data types
binary
compatibility
equivalency
floating point
used with LONG columns
date/time ADD_MONTHS function
overview
where to use
date/time data conversion
example program
example programs
date/time functions
coding considerations
data compatibility
example program
example programs
examples using ManufDB database
example using default format specifications
how used
introduction to
leading zeros required for input functions
parameters for
unspecified format elements default filled
used to add a number of months
used when inputting data
used when retrieving data
using host variables for format specifications
using host variables for input and output data
using host variables with
where to use ADD_MONTHS
where to use input functions
where to use output functions
where to use TO_CHAR
where to use TO_DATE
where to use TO_DATETIME
where to use TO_INTEGER
where to use TO_INTERVAL
where to use TO_TIME
where used
date/time input functions
examples
not intended for use in select list
overview
where to use
date/time output functions
examples
overview
where to use
DBA authority
DBECon file
DBEnvironment
access
DBE session
and autostart mode
terminating
DDL operations
used with integrity constraints
used with LONG columns
deadlock
and error recovery
status checking
DECIMAL data
declaration of data
FLOAT
DECLARE CURSOR
FOR UPDATE OF
preprocessor directive
SELECT
specify location of stored section
syntax
DECLAREing for UPDATE
KEEP CURSOR
declare section
defined
declaring
host variables
indicator variables
SQLCA
default data values
constant
data compatibility
for columns allowing nulls
in addition to null
not used with LONG BINARY data
not used with LONG columns
not used with LONG VARBINARY data
NULL
result of CURRENT_DATE function
result of CURRENT_DATETIME function
result of CURRENT_TIME function
USER
default format specification example
date/time functions
defining integrity constraints
defining LONG columns
in a table
input and output specification
with the LONG column I/O string
definitions
input device specification
LONG column I/O string
output device specification
row level integrity
DELETE
and simple data manipulation
DELETE command
used with LONG columns
with TO_DATETIME function
DELETE WHERE CURRENT
current row
restrictions
syntax
DELETE WHERE CURRENT command
used with LONG columns
delimiting SQL commands
designing an application using statement level integrity
directives
DML operations
used with date/time functions
used with integrity constraints
used with LONG columns
DROP MODULE
obsoleting programs
updating programs
dynamic command
passing to ALLBASE/SQL
dynamic commands
and authorization
dynamic FETCH command
used with LONG columns
dynamic operations
dynamic commands
overview
queries, using C, Pascal routines
techniques
dynamic preprocessing
authorization for
E
embedding commands
continuation lines
introduction
prefix
suffix
embedding SQL commands
comments
general rules
punctuation
END DECLARE SECTION
declaring host variables
END-EXEC
error checking
changes for this release
example COBOL copy file
using sqlerrd[2]
with row level integrity
with statement level integrity
error messages
example
BULK SELECT command with ADD_MONTHS function
BULK SELECT command with LONG columns
DELETE command with TO_DATETIME function
FETCH command with TO_INTEGER function
INSERT command with TO_DATE function
INSERT command with TO_DATETIME function
INSERT command with TO_INTERVAL function
INSERT command with TO_TIME function
LONG column descriptor declaration
SELECT command with TO_CHAR function
SELECT command with TO_DATETIME function
SELECT command with TO_INTERVAL function
UPDATE command with TO_DATE function
UPDATE command with TO_DATETIME function
example application design
using integrity constraints
example COBOL copy file
for error checking
example data file
BULK INSERT command with LONG columns
example program
date/time data conversion
using date/time functions
example programs
date/time data conversion
date/time functions
examples of date/time input functions
examples of date/time output functions
EXEC SQL
EXECUTE
non-dynamic queries
using
EXECUTE IMMEDIATE
using
executing programs
explicit status checking
defined
introduction
uses of
expression
F
FETCH
and null values
cursor processing
FETCH command
used dynamically with LONG columns
used with LONG columns
with TO_INTEGER function
file
Database Environment Configuration
DBECon
file IO
KEEP CURSOR
file name
fully qualified
relative
FLOAT data
host variables and
FLOAT data declaration
floating point data
4-byte
8-byte
column specifications
compatibility
REAL keyword
FOR UPDATE OF
UPDATE WHERE CURRENT
FROM clause
fully qualified file name
G
GOTO vs. GO TO
GRANT
GROUP BY clause
H
heap space input and output
host variables
and data manipulation
and modified source code
bulk processing
declaring
declaring for savepoints
for dynamic commands
for messages
for savepoint numbers
in arrays
in data types
indicator
initialization
input
names
output
overview
purpose
used for binary data
used for LONG column I/O strings
used with date/time functions
uses
I
IF statement in COBOL
use of NOMIXED reserved word
implicit status checking
defined
introduction
usage
$INCLUDE
compiler directive
INCLUDE
include files
contents of
creation
index scan
indicator variables
declaring
location of
null
null values
truncation
input device specification
definition
INSERT
and null values in unnamed columns
and simple data manipulation
INSERT command
used with LONG columns
using host variables for LONG column I/O strings
with LONG columns:example data file
with TO_DATE function
with TO_DATETIME function
with TO_INTERVAL function
with TO_TIME function
INSTALL
INTEGER data
integrity constraint definition
integrity constraints
and statement level integrity
commands used with
constraint test matrix
designing an application
example application using RecDB database
in RecDB database
introduction to
restrictions
unique and referential
J
job mode
join condition
joining tables
join variable
K
KEEP CURSOR
DECLAREing for UPDATE
example code
file IO
terminal IO
KEEP CURSOR WITH NOLOCKS command
use with OPEN command
L
language
current language
native language support
linker
separate linked objects
locking
and cursors
table level
logging
LONG binary data
compatibility
definition
how stored
LONG binary versus LONG varbinary data usage
LONG column definition
in a table
input and output specification
with the LONG column I/O string
LONG column descriptor
contents of
example declaration
general concept
how used
introduction to
LONG column I/O string
general concept
heap space input and output
how used
input device specification
output device specification
used with host variable
used with INSERT command
LONG columns
changing data
coding considerations
commands used with
considering multiple users
data types used with
deciding on space allocation
deleting data
file usage from an application
general concepts
input options
introduction to
maximum per table definition
output options
performance
putting data in
restrictions
retrieving data from
size maximum
specifying a DBEFileSet
storage
storing and retrieving data
used with [BULK] INSERT command
used with [BULK] SELECT command
used with DELETE [WHERE CURRENT] command
used with dynamic FETCH command
used with FETCH or REFETCH commands
used with UPDATE [WHERE CURRENT] command
using file naming conventions
using file versus heap space
using the LONG column descriptor
LONG phrase
used with binary data
used with varbinary data
LONG varbinary data
compatibility
definition
how stored
M
maintaining ALLBASE/SQL programs
ManufDB database
examples using date/time functions
program using date/time functions
message catalog
and SQLEXPLAIN
defaults
introduction
message catalog number
related to SQLCODE
messages from SQLEXPLAIN
when produced
modified source
creation
inserted statements
sample
modified source file
module
creation
DBEfileset
definition
installation
name
owner
ownership
storage
updating
multiple rows
not allowed in simple data manipulation
multiple rows qualify
runtime error
multiple users of LONG columns
multiple warnings
SQLEXPLAIN
N
name qualification
naming conventions for LONG column files
NATIVE-3000
defined
native language
current language
defaults
native language support
message catalog
SQLMSG
NOLIST reserved word
used with COBOL COPY files
NOMIXED reserved word
used with COBOL SET and IF statements
non-dynamic commands
NULL
as default data value
null predicate
NULL result of a dynamic fetch of a LONG column
null value
in key column of unique index
null values
and unnamed columns in an INSERT
indicator variables mandatory
in groups
in UPDATE
properties of
runtime errors
using indicator variables with
with FETCH
with SELECT
number of rows processed
data integrity
NumberOfRows variable
usage
O
odd-byte columns
OPEN
cursor processing
OPEN command
use with KEEP CURSOR WITH NOLOCKS command
optimization
ORDER BY clause
output device specification
definition
output file
attributes
preprocessor
overflow
OWNER
authority
OWNER authority
P
padding of DECIMAL values
Pascal subprogram COBOL calls
passing SQLCA
performance
integrity constraints
LONG columns
permanent section
and DBEnvironment
precision
predicates
prefix
PREPARE
non-dynamic queries
using
preprocessing
directives
preprocessor
access to DBEnvironment
and authorization
and DBE sessions
effect on source code
events
input
invoking
job mode
logging
modes
modified source file
modifying output of
output
transactions
UDC's
vs. COBOL preprocessor
preprocessor directive
DECLARE CURSOR
PROCEDURE DIVISION
program
compiling and linking
creation steps
date/time data conversion
execution
maintenance
obsolescence
starting DBE session
user authorization
programs
date/time functions
program structure
punctuation
PurchDB database
date/time conversion example programs
Q
query result
R
REAL keyword
floating point data
RecDB database application design
example maintenance menu
example of deleting data
example of error checking
example of inserting data
example of updating data
integrity constraints defined
REFETCH command
used with LONG columns
relative file name
RELEASE
introduction
without ending transaction
REPLACING clause
used with COBOL COPY Statement
restrictions
integrity constraints
LONG columns
retrieving LONG column data
with SELECT, FETCH, or REFETCH commands
REVOKE
robust program
defined
ROLLBACK WORK
defining transactions
to ensure data consistency
row level integrity
definition
RUN authority
with START DBE
running the preprocessor
run-time
defining SQL commands at
runtime
authorization
events
runtime errors
bulk processing
multiple rows qualify
null values
runtime status checking
possible errors
status codes
runtime warnings
S
sample database
data consistency
sample program
COBEX10A
COBEX10B
COBEX2
COBEX5
COBEX7
COBEX8
COBEX9
simple data manipulation
scale
section
commands requiring
creation
dynamic vs. non-dynamic
permanently stored
purpose
temorarily stored
temporary
validity
segmenter
SELECT
and simple data manipulation
DECLARE CURSOR
SELECT command
used with LONG columns
with TO_CHAR function
with TO_DATETIME function
with TO_INTERVAL function
select list
SELECT with CURSOR
input host variables only
self-joins
sequential table processing
overview
serial scan
SET and statements in COBOL
where used
shared memory problem
status checking
simple data manipulation
commands
DELETE
INSERT
multiple rows not allowed
overview
sample program
SELECT
techniques
transaction management
UPDATE
size maximum
LONG columns
slack byte
odd byte columns
SMALLINT data
space allocation for LONG column data
sqlca
declaring
SQLCA
declaring
elements of
in subprograms
overview
purpose
SQLCODE
and SQLWARN6
a negative number
deadlock detected
introduction
multiple messages
multiple SQLCODEs
of 0
of 100
of -14024
related to message catalog number
SQLEXPLAIN
usage
SQLCODE of -10002
SQLCODE of -4008
SQL commands
and data manipulation
defining at run time
delimiting
embedding
for data definition
for data manipulation
length
length of
location
prefix
suffix
use of
SQLCONST
$SQL COPY
COBOL compiler directive
sqlerrd[2]
error checking
SQLERRD(3)
introduction
usage
uses for
SQLEXPLAIN
introduction
multiple messages
multiple warnings
no message for SQLCODE=100
overview
simultaneous warning and error
SQLCODE
SQLWARN0
using
when messages are available
SQLIN
SQLMOD
SQLMSG
defaults
$SQL NOCOPY
COBOL compiler directive
SQLOUT
SQLVAR
SQLWARN0
introduction
SQLEXPLAIN
usage
SQLWARN1
introduction
string data truncation
usage
SQLWARN2
introduction
usage
SQLWARN6
introduction
transaction rollback
usage
START DBE
StartIndex variable
usage
statement level integrity
and integrity constraints
status checking
deadlock
explicit
explicit defined
implicit
implicit defined
information available
introduction to explicit
kinds of
procedures
purposes of
runtime techniques
shared memory problem
status codes
runtime status checking
storage
LONG columns
stored sections
string data truncation
SQLWARN1
subprograms
COBOL
C subprogram COBOL calls
Pascal subprogram COBOL calls
SQLCA declaration
suffix
syntax for date/time functions
ADD_MONTHS
input functions
output functions
TO_CHAR
TO_DATE
TO_DATETIME
TO_INTEGER
TO_INTERVAL
TO_TIME
syntax for LONG columns
ALTER TABLE command
CREATE TABLE command
select list
system catalog
T
temporary files
temporary section
terminal IO
KEEP CURSOR
TID function
TO_CHAR function
example with SELECT command
syntax
TO_DATE function
example with INSERT command
example with UPDATE command
syntax
TO_DATETIME function
example with DELETE command
example with INSERT command
example with SELECT command
example with UPDATE command
syntax
TO_INTEGER function
example with FETCH command
syntax
TO_INTERVAL function
example with INSERT command
example with SELECT command
syntax
TO_TIME function
example with INSERT command
syntax
transaction management
automatic
cursor processing
overview
simple data manipulation
truncation
detecting in strings
type
compatibility
U
UDC's
PCOB
PPCOB
preprocess
preprocess, compile, link
unique index
UPDATE
and simple data manipulation
UPDATE and FETCH
cursor processing
UPDATE command
used with LONG columns
used with TO_DATE function
used with TO_DATETIME function
UPDATE WHERE CURRENT
FOR UPDATE OF
restrictions
syntax
UPDATE WHERE CURRENT command
used with LONG columns
updating application programs
USER
as default data value
using default data values
introduction to
using host variables
using indicator variables
assigning null values
V
validation
varbinary data
using the LONG phrase with
VARCHAR data
views
and DELETE
and SELECT
and UPDATE
restrictions
W
warning message
and SQLCODE
and SQLWARN0
and SQLWARN1
SQLWARN2
warning messages
warnings
runtime handling
WHENEVER
components of
duration of command
for different conditions
introduction to
transaction roll back
when starting DBE session