HP 3000 Manuals HP 3000 Manuals
Index
A
active set
re-access
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
character data
declarations of
in sqlda declaration
referencing
atomic operation
defined
authorization
changing
dynamic preprocessing
granting
program development
program maintenance
automatic rollback
B
basic SQL statements
BEGIN DECLARE SECTION
declaring host variables
delimiting the declare section
BEGIN WORK
in transaction management
binary data
compatibility
host variable definition
using the LONG phrase with
BULK FETCH
basic uses of
BULK FETCH command
used in example program
with TO_INTEGER function
BULK INSERT
basic uses of
BULK INSERT command
used in example program
used with LONG columns
using host variables for LONG column I/O strings
with LONG columns:example data file
with LONG columns:example program
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
used with LONG columns
with ADD_MONTHS function
BULK table processing
BULK FETCH
BULK INSERT
BULK SELECT
commands
sample program
techniques
C
cex10a
cex10b
cex2
source code
cex2.c
preprocessor modified source code
cex5
cex7
cex8
cex9
CHAR data declaration
CLOSE
after BULK FETCH
before ending a transaction
freeing buffer space with
to re-access the active set
with COMMIT WORK
with KEEP CURSOR
coding considerations
for date/time functions
for LONG columns
column specifications for floating point data
comments in SQL commands
COMMIT WORK
and revalidation of sections
in transaction management
issued by preprocessor
with CLOSE
with KEEP CURSOR
compatibility of variables
concurrency
CONNECT
in application programs
to start a DBE session
CONNECT authority
and preprocessing
constant
as default data value
constraint test matrix for integrity constraints
conversion
numeric
string data
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
cursor processing
CLOSE
commands
DECLARE CURSOR
definition
DELETE WHERE CURRENT
FETCH
OPEN
sample program
techniques
transaction management
UPDATE and FETCH
UPDATE WHERE CURRENT
D
data buffer
declaration
layout
null indicator suffix
parsing
rows to retrieve
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 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 retrieval using date/time functions
data structures
for dynamic query
data type
compatibility
conversion
declarations
equivalency
data types
floating point
used with LONG columns
date/time ADD_MONTHS function
overview
where to use
date/time data conversion
example program
date/time functions
coding considerations
data compatibility
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
and preprocessing
and START DBE
DBAAuthority
DCL defined
DDL defined
DDL operations
used with integrity constraints
used with LONG columns
deadlock
and error recovery
status checking
DECIMAL data declaration
decimal type compatibility
declaration of data
CHAR
DATE
DATETIME
DECIMAL
FLOAT
INTEGER
INTERVAL
SMALLINT
TIME
VARCHAR
declaration part
host variable
DECLARE CURSOR
FOR UPDATE OF
preprocessor directive
SELECT
syntax
used with BULK FETCH
declare section
BEGIN and END DECLARE SECTION commands
defined
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
delimiting SQL commands
DESCRIBE
dynamic non-query
dynamic query
designing an application using statement level integrity
detecting end of scan
DML defined
DML operations
used with date/time functions
used with integrity constraints
used with LONG columns
DROP MODULE
DROP option
full preprocessing mode
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
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
queries vs. non-queries
sample programs
techniques
dynamic preprocessing
authorization for
dynamic query data structures
E
END DECLARE SECTION
declaring host variables
delimiting the declare section
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
example
BULK FETCH command with TO_INTEGER function
BULK SELECT command with ADD_MONTHS function
DELETE command with TO_DATETIME 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
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
BULK INSERT command with LONG columns
date/time data conversion
LONG column descriptor declaration
examples of date/time input functions
examples of date/time output functions
EXECUTE
non-dynamic queries
executing programs
explicit status checking
defined
introduction
uses of
externals include file
sample
F
FETCH
current row
FETCH command
used dynamically with LONG columns
used with LONG columns
file IO
KEEP CURSOR
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
full preprocessing mode
preprocessor command
G
general rules
skeleton program
GOTO vs. GO TO
GRANT
for required authorities
H
heap space input and output
host variable
bulk processing
declaration
declaration part
declaration summary
declaring for ALLBASE/SQL messages
declaring for DBEnvironment names
declaring for savepoints
indicator
initialization
input
names
output
purpose
scope
uses
host variables
used for binary data
used for LONG column I/O strings
used with date/time functions
host variable scope
at preprocessing time
at run time
I
implicit status checking
defined
usage
include files
as input files
contents
created by preprocessor
samples
user specified
indicator variables
location of
null
null values
truncation
INFO command
and null indicator variables
and null values
and type compatibility
input device specification
definition
INSERT
and simple data manipulation
INSERT command
used with LONG columns
using host variables for LONG column I/O strings
with TO_DATE function
with TO_DATETIME function
with TO_INTERVAL function
with TO_TIME function
INSTALL
installable module file
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
job mode
K
KEEP CURSOR
file IO
terminal IO
KEEP CURSOR WITH NOLOCKS command
use with OPEN command
L
language
current language
native language support
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 [BULK] INSERT command
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
message catalog
default
native language
preprocessor input
message catalog number
related to sqlcode
message file
messages from SQLEXPLAIN
when produced
modified source file
contents
created by preprocessor
creation
inserted constructs
module
definition
installable
installation
name
owner
OWNER authority for
ownership
storage
updating
validation
MODULE option
full preprocessing mode
multiple rows
not allowed in simple data manipulation
multiple rows qualify
runtime error
multiple users of LONG columns
multiple warnings
SQLEXPLAIN
N
naming conventions for LONG column files
NATIVE-3000
defined
native language
current language
defaults
message catalog
native language data
verifying column definition
native language support
overview
non-dynamic commands
NULL
as default data value
null indicator suffix
data buffer
null indicator variable
in dynamic command
null indicator variables
and the INFO command
NULL result of a dynamic fetch of a LONG column
null value
in key column of unique index
null values
and the INFO command
and unnamed columns in an INSERT
in a structure declaration
indicator variables mandatory
properties of
runtime errors
using indicator variables with
with FETCH
with SELECT
number of rows processed
data integrity
number of rows variable
O
OLTP defined
OPEN
before BULK FETCH
cursor processing
OPEN command
use with KEEP CURSOR WITH NOLOCKS command
optimization
output device specification
definition
overflow
of numeric values
OWNER authority
and program development
granting
OWNER option
full preprocessing mode
P
performance
integrity constraints
LONG columns
permanent section
and DBEnvironment
PREPARE
non-dynamic queries
preprocessor
authorization
DBE sessions
effect of mode on modified source
effect on source code
errors
events
identifying input
include files
invocation
job mode
logging
messages
modes
modes and invocation
options
parsing
UDC's
preprocessor banner
900 series
preprocessor directive
DECLARE CURSOR
program
execution
maintenance
methods of linking
name
obsolescence
steps in compiling
steps in creating
user authorization
program example
date/time data conversion
program structure
example
Q
query
dynamic data structures
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
restrictions
integrity constraints
LONG columns
retrieving LONG column data
with [BULK] SELECT, FETCH, or REFETCH commands
REVOKE
REVOKE option
full preprocessing mode
robust program
defined
ROLLBACK WORK
to ensure data consistency
row level integrity
definition
rows to retrieve
data buffer
RUN authority
and program development
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
authorities
data consistency
views
sample program
bulk processing
cex10a
cex10b
cex2
cex5
cex7
cex8
cex9
cursor processing
dynamic queries, known format
dynamic queries, unknown format
modified source file
simple data manipulation
status checking
section
and system catalog
creation
definition
dynamic vs. non-dynamic
permanently stored
purpose
temorarily stored
temporary
types
validity
SELECT
and simple data manipulation
DECLARE CURSOR
use of COMMIT WORK with
SELECT command
used with LONG columns
with TO_CHAR function
with TO_DATETIME function
with TO_INTERVAL function
SELECT with CURSOR
input host variables only
shared memory problem
status checking
simple data manipulation
commands
DELETE
INSERT
multiple rows not allowed
sample program
SELECT
techniques
transaction management
UPDATE
size maximum
LONG columns
skeleton program
SMALLINT data declaration
source file
source file;
space allocation for LONG column data
SQL
basic statements
sqlca
elements of
purpose
sqlca.sqlcode
introduction
usage
sqlca.sqlerrd[2]
introduction
usage
sqlca.sqlwarn[0]
introduction
usage
sqlca.sqlwarn[1]
introduction
usage
sqlca.sqlwarn[2]
introduction
usage
sqlca.sqlwarn[3]
introduction
usage
sqlca.sqlwarn[6]
introduction
usage
sqlcode
and sqlwarn[6]
a negative number
ANSI standards
deadlock detected
detecting end of scan
multiple messages
multiple sqlcodes
of 0
of 100
of -10002
of -14024
of -4008
related to message catalog number
SQLEXPLAIN
usage
used with sqlerrd[2]
sqlcode of 100
SQL commands
comments within
delimiters for
location in the code
syntax
sqlda
declaring
fields
when fields are set
sqlerrd[2]
as counter in display routine
error checking
usage
used with sqlcode
uses for
SQLEXPLAIN
and message catalogs
introduction
multiple messages
multiple warnings
no message for sqlcode=100
simultaneous warning and error
sqlcode
sqlwarn[0]
using
when messages are available
sqlmsg
sqlwarn[0]
SQLEXPLAIN
usage
sqlwarn[1]
string truncation
usage
sqlwarn[2]
usage
sqlwarn[3]
usage
sqlwarn[6]
transaction rollback
usage
start a DBE session
CONNECT
START DBE
START DBE
and DBA authority
to start a DBE session
StartIndex variable
defined
statement level integrity
and integrity constraints
status checking
deadlock
elements available
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
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
syntax within embedded SQL
system catalog
T
temporary section
terminal IO
KEEP CURSOR
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 BULK 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
cursor processing
simple data manipulation
truncation
detecting in strings
in string operations
of numeric values
of UPDATE or DELETE strings
type compatibility
and the INFO command
decimal
type conversion
type include file
sample
type precedence
in numeric conversion
U
UDC's
PC
PPC
preprocess
preprocess, compile, link
unique index
WHERE clause
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 STATISTICS
invalidating sections
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
module
varbinary data
using the LONG phrase with
VARCHAR
data declaration
data storage
dynamic command declaration
varchar prefix in the data buffer
variable include file
sample
views
and sections
W
warning message
and sqlcode
and sqlwarn[0]
warnings
runtime handling
WHENEVER
components of
duration of command
for different conditions
transaction roll back