HP 3000 Manuals HP 3000 Manuals
Index
A
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
ANSI standards
SQLCODE
arrays
BULK SELECT
declarations of
in sqlda declaration
referencing
arrays, char data
arrays, declaring
atomic operation
defined
authority option
program maintenance
authorization
and program maintenance
changing
dynamic preprocessing
granting
program development
runtime
automatic rollback
autostart mode
B
basic SQL statements
BEGIN DECLARE SECTION
as delimiter
BEGIN WORK
binary data
compatibility
host variable definition
how stored
using the LONG phrase with
BULK FETCH
BULK FETCH command
used in example Pascal program
BULK INSERT
basic uses of
BULK INSERT command
used in example Pascal program
used with LONG columns
BULK option
not used for dynamic FETCH
bulk processing
INTO clause
bulk processing variables
BULK SELECT
basic uses
[BULK] SELECT command
used with LONG columns
BULK SELECT command
with ADD_MONTHS function
BULK table processing
BULK INSERT
BULK SELECT
commands
overview
sample program
techniques
C
CHAR data declaration
CLOSE
before ending a transaction
freeing buffer space with
with COMMIT WORK
with KEEP CURSOR
coding considerations
for date/time functions
for LONG columns
column specifications for floating point data
comments
Pascal
SQL
COMMIT WORK
and termination
with CLOSE
with KEEP CURSOR
comparison predicate
compatibility
compiler
separate compilable section
compiler directive for SQLCODE
concurrency
CONNECT
authority
granting authority
to start DBE session
consistency
constant
as default data value
constraint test matrix for integrity constraints
conversion
copy of module
CREATE TABLE command
syntax for LONG columns
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
and dynamic queries
and sections
closing
definition
deleting with
effect of commands on
opening
positioning
sample program
techniques
UPDATE and FETCH
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 buffer
declaration
layout
null indicator suffix
parsing
rows to retrieve
use of
varchar prefix
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 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 structures
for dynamic query
data type
and declarations
compatibility
conversion
equivalency
data types
binary
floating point
used with LONG columns
date/time ADD_MONTHS function
overview
where to use
date/time data conversion
example program in Pascal
example programs
date/time functions
coding considerations
data compatibility
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
DDL operations
used with integrity constraints
used with LONG columns
deadlock
and error recovery
status checking
DECIMAL data declaration
declaration of data
char
FLOAT
integer
smallint
varchar
declaration part
DECLARE CURSOR
FOR UPDATE OF
preprocessor directive
SELECT
specify location of stored section
syntax
DECLAREing for UPDATE
KEEP CURSOR
declare section
and delimiters
declaring, arrays
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
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
DESCRIBE
dynamic non-query
dynamic query
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
and RUN authorities
dynamically deleting data
DELETE WHERE CURRENT command cannot be prepared
error checking strategy
dynamically updating data
error checking strategy
UPDATE WHERE CURRENT command cannot be prepared
using SELECT command with FOR UPDATE OF clause
dynamic command
passing to ALLBASE/SQL
queries
query with known query result format
query with unknown query result format
dynamic commands
and authorization
dynamic FETCH
BULK option not used
dynamic FETCH command
used with LONG columns
dynamic operations
dynamic commands
handling non-queries
overview
queries vs. non-queries
sample program
techniques
dynamic preprocessing
authorization for
dynamic query data structures
E
embedding SQL commands
END DECLARE SECTION
as delimiter
error checking
changes for this release
using sqlerrd[2]
when dynamically deleting data
when dynamically updating data
with row level integrity
with statement level integrity
error messages
example
BULK SELECT command with ADD_MONTHS function
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 data file
BULK INSERT command with LONG columns
example program in Pascal
date/time data conversion
example programs
date/time data conversion
examples of date/time input functions
examples of date/time output functions
EXEC SQL
EXECUTE
non-dynamic queries
executing programs
explicit status checking
defined
introduction
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
include
user include
file IO
KEEP CURSOR
file name
fully qualified
relative
FLOAT data declaration
floating point data
4-byte
8-byte
column specifications
compatibility
REAL keyword
format array
declaration
fields
manditory declaration for dynamic query
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 variable
and data manipulation
and modified source
declaration
declaration summary
declaring
declaring for ALLBASE/SQL messages
declaring for data
declaring for DBEnvironment names
declaring for null values
declaring for savepoints
overview
scope
host variables
bulk processing
indicator
initialization
input
names
output
purpose
used for binary data
used for LONG column I/O strings
used with date/time functions
uses
I
implicit status checking
defined
usage
INCLUDE
include file
include files
creation
include file, user
index scan
indicator variables
location of
null
null values
truncation
input device specification
definition
INSERT
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 declaration
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
join condition
joining tables
join variables
K
KEEP CURSOR
DECLAREing for UPDATE
file IO
terminal IO
KEEP CURSOR WITH NOLOCKS command
use with OPEN command
L
language
current language
native language support
setting and resetting
LANG variable
setting and resetting
length of commands
linker
separate linked objects
locking
and cursors
table level
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
memory problem
status checking
message catalog
defaults
message catalog number
related to sqlcode
modified source
creation
inserted constructs
module
copy
creation
definition
installation
name
owner
ownership
storage
updating
multiple rows qualify
runtime error
multiple SQLCODEs
multiple users of LONG columns
N
name qualification
naming conventions for LONG column files
native language
current language
setting and resetting
native language support
message catalog
SQLMSG
non-dynamic commands
NULL
as default data value
null indicator suffix
data buffer
null indicator variable
in dynamic command
null predicate
NULL result of a dynamic fetch of a LONG column
null values
and groups
and unique indexes
in a structure declaration
indicator variables mandatory
in INSERT
in UPDATE
properties of
runtime errors
with FETCH
with SELECT
number of rows processed
data integrity
NumberOfRows variable
usage
O
OPEN
cursor processing
OPEN command
use with KEEP CURSOR WITH NOLOCKS command
optimization
and section creation
ORDER BY clause
output device specification
definition
overflow
of numeric values
OWNER
authority for
OWNER authority
and program development
granting
OWNER authorization
and CONNECT
granting of
P
Pascal comments
Pascal program
date/time data conversion
pasex10a
pasex10b
pasex2
pasex5
pasex7
pasex8
pasex9
performance
integrity constraints
LONG columns
permanent section
and DBEnvironment
predicates
PREPARE
non-dynamic queries
preprocessor
access to DBEnvironment
and authorization
and DBE sessions
directives
effect on source code
errors
events
input
invocation
modes
modes and invocation
modifying output of
options
output
parsing
syntax checking mode
transactions
UDCs
using
preprocessor directive
DECLARE CURSOR
procedure part
program
compiling and linking
creation steps
development
execution
maintenance
name
obsolescence
user authorization
program structure
punctuation
PurchDB database
date/time conversion example programs
Q
query
dynamic data structures
result
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
restrictions
integrity constraints
LONG columns
retrieving LONG column data
with SELECT, FETCH, or REFETCH commands
REVOKE
robust program
defined
ROLLBACK WORK
row level integrity
definition
rows to retrieve
data buffer
RUN authority
runtime authorization
runtime errors
bulk processing
multiple rows qualify
null values
runtime events
runtime status checking
possible errors
status codes
runtime warnings
S
sample database
data consistency
sample program
cursor processing
simple data manipulation
status checking
sample programs
pasex10a
pasex10b
pasex2
pasex5
pasex7
pasex8
pasex9
section
and system catalog
commands requiring
creation
definition
dynamic vs. non-dynamic
permanently stored
purpose
temorarily stored
temporary
types
validity
SELECT
and DECLARE CURSOR
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
SELECT with CURSOR
input host variables only
self-joins
semi-colon
sequential table processing
overview
sample programs
serial scan
shared memory problem
status checking
simple data manipulation
commands
DELETE
INSERT
overview
sample program
SELECT
techniques
transaction management
UPDATE
size maximum
LONG columns
SMALLINT data declaration
source file
and preprocessor
definition of
space allocation for LONG column data
SQLCA
declaring
elements of
overview
sqlca.sqlcode
introduction
SQLCA.SQLCODE
SQLCA.SQLCODE vs. SQLCODE
sqlca.sqlerrd[2]
introduction
SQLCA.SQLERRD[3]
sqlca.sqlwarn[0]
introduction
SQLCA.SQLWARN[0]
sqlca.sqlwarn[1]
introduction
SQLCA.SQLWARN[1]
usage
sqlca.sqlwarn[2]
introduction
SQLCA.SQLWARN[2]
usage
sqlca.sqlwarn[3]
introduction
SQLCA.SQLWARN[3]
usage
sqlca.sqlwarn[6]
introduction
usage
sqlcode
and sqlerrd[3]
deadlock detected
of 100
of -14024
of -4008
SQLCODE
and sqlerrd[3]
and sqlwarn[1]
and sqlwarn[2]
and sqlwarn[3]
a negative number
multiple messages
multiple SQLCODEs
of 100
of -10002
related to message catalog number
sqlwarn[0]
SQLCODE of 100
SQLCODE of -10002
SQLCODE vs. SQLCA.SQLCODE
SQL commands
and data manipulation
delimiting
embedding
for data definition
for data manipulation
length
location
prefix
suffix
use of
SQL comments
sqlda
declaring
fields
when fields are set
sqlerrd[2]
error checking
sqlerrd[3]
as counter
in display counter
ussage
SQLERRD[3]
sqlerre[3]
uses for
SQLEXPLAIN
introduction
multiple messages
no message for SQLCODE=100
simultaneous warning and error
SQLCODE
sqlwarn[0]
using
when messages are available
SQLMSG
defaults
SQLSECNUM
in preprocessor-generated calls
sqlwarn[0]
SQLEXPLAIN
usage
SQLWARN[0]
sqlwarn[1]
string truncation
usage
SQLWARN[1]
usage
SQLWARN[2]
usage
SQLWARN[3]
usage
sqlwarn[6]
transaction rollback
usage
START DBE
authorization
StartIndex variable
usage
statement level integrity
and integrity constraints
status checking
deadlock
elements available
explicit
explicit defined
implicit
implicit defined
information available
introduction to explicit
kinds of
memory problem
procedures
purposes of
runtime techniques
shared memory problem
status codes
runtime status checking
storage
LONG columns
syntax checking mode
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
storing a section
T
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
of numeric values
of UPDATE or DELETE strings
type compatibility
decimal
type conversion
type precedence
in numeric conversion
type precision
U
UDC's
PPPAS
preprocess
UDCs
PPPAS
preprocess, compile, link
unique index
null values
WHERE clause
UPDATE
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 indicator variables
assigning null values
V
validation
varbinary data
using the LONG phrase with
VARCHAR
dynamic command declaration
VARCHAR data declaration
varchar prefix in the data buffer
views
and DELETE
and SELECT
and UPDATE
restrictions
W
warning message
and sqlcode
and sqlwarn[0]
warning messages
warnings
runtime handling
WHENEVER
components of
duration of command
for different conditions
transaction roll back