HP 3000 Manuals HP 3000 Manuals
Index
Special characters
*
in SELECT
A
active set
and cursors
and sequential processing
in sequential processing
using the CLOSE command before re-accessing
ADD_MONTHS function
example with SELECT
syntax
aggregate function
and WHERE clause
null values in
ALTER TABLE command
syntax for LONG columns
ANSI SQL1 level 2
specifying a default value
ANSI SQL86 level 2
floating point data
atomic operation
transaction as
authority
DBA
authorization
and program maintenance
changing
dynamic preprocessing
granting
to execute
to maintain
to preprocess
autostart mode
B
base table
BEGIN DECLARE SECTION
and include files
delimiting the declare section
BEGIN WORK
in transaction management
issued by preprocessor
binary data
compatibility
host variable definition
how stored
using the LONG phrase with
C
CHAR(1)
type description
character data
conversion
truncation
type description
CHAR(n)
type description
clause
FOR UPDATE
GROUP BY
HAVING
IN
ORDER BY
WHERE
CLOSE
before ending a transaction
with COMMIT WORK
with KEEP CURSOR
cluster count
coding considerations
for date/time functions
for LONG columns
colon
before host variable name
column specifications for floating point data
command
BEGIN DECLARE SECTION
BEGIN WORK
CLOSE
COMMIT WORK
CONNECT TO
data definition
data manipulation
DECLARE CURSOR
DELETE
DELETE WHERE CURRENT
dynamic
embedded SQL
embedding SQL
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
FETCH
INCLUDE SQLCA
INSERT
OPEN
PREPARE
ROLLBACK WORK
SELECT
SQLEXPLAIN
UPDATE
UPDATE WHERE CURRENT
WHENEVER
WHENEVER SQLERROR
comments
in embedded SQL files
comments in ALLBASE/SQL commands
COMMIT WORK
in transaction management
issued by preprocessor
with CLOSE
with KEEP CURSOR
common block
SQLCA
communication area
SQLCA
comparison predicate
in WHERE clause
compiler
and linker
in program development cycle
input files
separate compilable section
compiler directive
ELSE
ENDIF
IF
INCLUDE
SET
compiler message
line number
concurrency
condition
in WHENEVER
join
search
types in WHENEVER
CONNECT
in application programs
issued by preprocessor
CONNECT TO
constant
as default data value
constraint test matrix for integrity constraints
continuation lines
CONTINUE action
in WHENEVER
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
and DELETE WHERE CURRENT
of active set
CURRENT_TIME function result
used as default data value
cursor
and sequential processing
effect of commands on
in sequential processing
managing a query result
cursor processing
transaction management
D
data access
Database Environment Configuration
data compatibility
binary
floating point
for date/time function parameters
for default data values
LONG binary
LONG varbinary
data consistency
through status checking
data definition commands
embedding in programs
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(3) with FORTRAN
data manipulation
embedded commands for
data manipulation commands
embedding in programs
data retrieval using date/time functions
data storage
binary data
data structure
data type compatibility
data type conversion
data types
binary
compatibility with ALLBASE/SQL types
floating point
for host variables
used with LONG columns
data values
data visibility
date/time ADD_MONTHS function
overview
where to use
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
creating
DBEnvironment
access
accessed by preprocessor
session
starting a session
terminating a session
DBEnvironment access
preprocessor
program
DBEnvironment Name
host variables and
DBE session
in preprocessing
DDL operations
used with integrity constraints
used with LONG columns
deadlock
recovering from
restarting transaction following
deadlock detection
DECIMAL
type description
decimal data
and DOUBLE PRECISION variables
declaration
section
declaration of data
FLOAT
DECLARE Command
BEGIN
END
DECLARE CURSOR
declaring
arrays
data variables
dynamic command variables
host variables
indicator variables
message variables
passed host variables
savepoint number 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
basic use
DELETE command
used with LONG columns
with TO_DATETIME function
DELETE WHERE CURRENT
DELETE WHERE CURRENT command
used with LONG columns
designing an application using statement level integrity
directive
compiler
directives
preprocessor
DISTINCT clause
DML operations
used with date/time functions
used with integrity constraints
used with LONG columns
DOUBLE PRECISION
type description
DROP MODULE
DROP option
full preprocessing mode
dynamic command
host variables for
passing to ALLBASE/SQL
type description
using host variables for
dynamic FETCH command
used with LONG columns
dynamic operation
embedded commands for
uses of
using host variables with
dynamic operations
dynamic commands
handling non-queries
sample programs
techniques
dynamic preprocessing
authorization for
E
editor
in program development cycle
ELSE
compiler directive
embedded SQL
defined
embedded SQL Commands
in program development cycle
embedding SQL commands
continuation lines
general rules
introduction
overview
prefix
END DECLARE SECTION
and include files
delimiting the declare section
ENDIF
compiler directive
error checking
changes for this release
using SQLERRD(3) with FORTRAN
with row level integrity
with statement level integrity
errors
preprocessing
example
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 ADD_MONTHS 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
INSERT command with LONG columns
examples of date/time input functions
examples of date/time output functions
EXEC SQL
command delimiter
prefix
executable program
in program development cycle
EXECUTE
non-dynamic queries
EXECUTE IMMEDIATE
executing a program
executing programs
explicit status checking
embedded commands for
expression
defined
external procedure
F
FETCH
FETCH command
used dynamically with LONG columns
used with LONG columns
with TO_INTEGER function
field
SQLCode
SQLErrd(3)
SQLWarn(0)
SQLWarn(6)
file
Database Environment Configuration
DBECon
include
installable module
modified source code
file equations
back referenced DBEnvironment
message catalog
file IO
KEEP CURSOR
file name
fully qualified
relative
FLOAT
type description
FLOAT data
host variables and
FLOAT data declaration
floating point data
4-byte
8-byte
column specifications
compatibility
REAL keyword
forex2
sample program
forex9a
FOR UPDATE clause
in DECLARE CURSOR
in DELETE WHERE CURRENT
in UPDATE WHERE CURRENT
full preprocessing mode
invocation
preprocessor command
fully qualified file name
function
aggregate
G
GOTO action
in WHENEVER
GRANT
for required authorities
GROUP BY clause
in SELECT
H
HAVING clause
in SELECT
heap space input and output
host variable
declaring for DBEnvironment names
host variable declaration section
host variable names
host variables
data description entries
data types
data values
declaring
defined
embedded declarations for
for dynamic commands
indicator variables
input
naming
null indicators
output
used for binary data
used for LONG column I/O strings
used with date/time functions
using
with SELECT
I
IF
compiler directive
implicit status checking
embedded commands for
IN clause
in DECLARE CURSOR
INCLUDE
compiler directive
include file
as input file
created by preprocessor
in program development cycle
overwritten
SQLVAR
INCLUDE SQLCA
index
count
preventing duplicate values
index scan
and locking
indicator variable
declaring
for null values
setting a column to null with
type description
use of
using host variables for
indicator variable declaration
input device specification
definition
input host variables
input tree
part of section
INSERT
basic use
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
installable module
created by preprocessor
in program development cycle
installable module file
INTEGER
type description
INTEGER*2
type description
INTEGER data
host variables and
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
ISQL
in program development cycle
J
job mode
preprocessor running in
join
join condition
join operation
join variable
K
KEEP CURSOR
file IO
terminal IO
KEEP CURSOR WITH NOLOCKS command
use with OPEN command
L
label
GOTO
in error handling
with WHENEVER commands
language
current language
native language support
of DBEnvironment
line numbers
SQLMSG
linker
and compiler
in program development cycle
separate linked objects
locking
and scan types
in WHERE clause
locks
releasing after a CLOSE
log file space
use during preprocessing
logical data consistency
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 declarationtitle;
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 DELETE [WHERE CURRENT] command
used with dynamic FETCH command
used with FETCH or REFETCH commands
used with INSERT command
used with SELECT command
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
main program unit
in a separate file
maintaining ALLBASE/SQL programs
ManufDB database
examples using date/time functions
message catalog
and SQLEXPLAIN
and status checking
defaults
variables for messages
with SQLEXPLAIN
message catalog message
type description
message catalog messages
host variables and
message file
mode
autostart
modified source file
created by preprocessor
creation
sample
sample for forex2
module
creation
dropping
installable
installation
name
owner
ownership
storage
stored by preprocessor
updating
module name
specifying with preprocessor
module owner
name
multiple rows
detecting with SQLCode
multiple users of LONG columns
multiuser mode
commands with
N
name
module
module owner
naming conventions for LONG column files
NATIVE-3000
defined
native language
and SQLEXPLAIN
current language
defaults
native language support
message catalog
overview
SQLMSG
NODROP option
full preprocessing mode
non-dynamic commands
NOT FOUND condition
with WHENEVER
NOT NULL
columns defined as
NULL
as default data value
null indicator variable
for updates
null predicate
in WHERE clause
NULL result of a dynamic fetch of a LONG column
null value
and GROUP BY clause
indicating
in UPDATE
null value indicators
host variables for
using host variables for
number of rows processed
data integrity
numeric data
conversion
O
OPEN
OPEN command
use with KEEP CURSOR WITH NOLOCKS command
operation
join
operations
using host variables with
optimization
in WHERE clause
option
DISTINCT clause
ORDER BY clause
in SELECT
in SELECT command defining a cursor
output device specification
definition
output file attributes
preprocessor files
output host variables
overflow
from data conversion
OWNER authority
granting
OWNER option
full preprocessing mode
P
passing SQLCA
performance
integrity constraints
LONG columns
permanent section
and DBEnvironment
predicate
in a search condition
prefix
EXEC SQL
PREPARE
non-dynamic queries
preprocess
defined
preprocessing
log file space
single-user mode
preprocessor
access to DBEnvironment
authorization required
directives
effect of mode on modified source
effect on DBEnvironment
effect on source code
errors
full preprocessing mode
functions
in program development cycle
input
invocation
modes and invocation
options
output
output file attributes
parsing SQLIN
permanent files
running in job mode
syntax checking mode
temporary files
UDC's
using
preprocess-time events
PRESERVE option
full preprocessing mode
procedure
external
program
DBEnvironment access
development cycle
executable
execution
FORTRAN application
main program unit
maintenance
obsolescence
structure,skeleton example
subprogram units
user authorization
program development steps
program segmentation
PSQLC
DBEnvironment access
Q
qualify
more than one row
no rows qualify
one or more rows qualify
query
overview
query efficiency
query result
and SELECT
R
REAL*8
type description
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
restrictions
integrity constraints
LONG columns
retrieving LONG column data
with SELECT, FETCH, or REFETCH commands
REVOKE
REVOKE option
full preprocessing mode
ROLLBACK WORK
issued by preprocessor
to ensure data consistency
row
more than one row qualifies
multiple
no rows qualify
one or more rows qualify
row level integrity
definition
run authority
preserving
RUN authority
revoking
runtime
performance
status checking
runtime events
run tree
part of section
S
sample modified source file
sample program
dynamic queries, execute immediate
forex2
sample sourcefilename
sample SourceFileName.sql
savepoint number
declaring variables for
type description
using host variables for
scan
scan types
and locking
search condition
specified by WHERE clause
section
components of
creation
defined
dynamic vs. non-dynamic
identifying number
number
permanently stored
purpose
stored
system catalog information
SYSTEM.SECTION view
temorarily stored
temporary
type
validity
SELECT
basic use
overview
SELECT command
used with LONG columns
with ADD_MONTHS function
with TO_CHAR function
with TO_DATETIME function
with TO_INTERVAL function
select list
with SELECT
sequential table processing
embedded commands for
overview
uses of
using cursors
serial scan
and locking
session
starting DBE
SET
compiler directive
shared memory
SQLCode indicating not enough
shared memory problem
restarting after
simple data manipulation
commands
defined
embedded commands for
transaction management
single-user mode
commands with
size maximum
LONG columns
SMALLINT
type description
source code
in program development cycle
sourcefilename
sample
SourceFileName.sql
space allocation for LONG column data
SQL
Communication Area (SQLCA)
Communications Area (SQLCA)
EXEC SQL
SQLEXPLAIN
SQLIND
SQLCA
common block
data items you can use
embedded commands for
fields
INCLUDE
SQLCode
SQLErrd(3)
SQLWarn(0)
SQLWarn(1)
SQLWarn(2)
SQLWarn(6)
sqlca.sqlwarn(1)
usage
sqlca.sqlwarn(2)
usage
SQLCode
0
100
-10002
-14024
-4008
after last row fetched
after the last fetch
and SQLErrd(3)
in creating a warning for users
multiple values for
of 100
of -10002
possible values of
SQL command
length
location
prefix
SQL commands
BEGIN DECLARE SECTION
COMMIT WORK
END DECLARE SECTION
WHENEVER NOT FOUND
WHENEVER SQLERROR
WHENEVER SQLWARNING
SQL communication area
SQLCTxxx.PUB.SYS
SQLErrd(3)
determining number of rows with
in creating a warning for users
possible values of
set to number of rows processed
SQLERRD(3)
error checking with FORTRAN
SQLERROR
WHENEVER
SQLERROR condition
with WHENEVER
SQLEXPLAIN
and approaches to status checking
and message catalog
obtaining multiple SQLCodes
SQLIN
preprocessor input
SQLIND
host variables and
type description
SQLMOD
SQLMSG
defaults
line numbers
SQLOUT
preprocessor output
SQLVAR
preprocessor output
type declarations in
SQLWarn0
SQLWarn(0)
and warnings from ALLBASE/SQL
SQLWarn1
sqlwarn(1)
usage
SQLWarn2
sqlwarn(2)
usage
SQLWarn6
SQLWarn(6)
on rollback by ALLBASE/SQL
SQLWarning
SQLWARNING condition
with WHENEVER
START DBE
and the preprocessor
starting DBE session
statement level integrity
and integrity constraints
status checking
code generated by preprocessor
embedded commands for
explicit
implicit
why do it?
status checking action
in WHENEVER
status handling
code generated by preprocessor
status information
STOP action
in WHENEVER
storage
LONG columns
stored section
string
truncation of
subprogram units
in separate files
passing variables
preprocessing and compiling
syntax checking mode
preprocessor command
preprocessor invocation
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
information on sections
pages locked during preprocessing
SYSTEM.SECTION
T
table
table processing
embedded commands for
sequential
temporary section
terminal IO
KEEP CURSOR
terminating
DBE session
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
embedded commands for
transaction management
cursor processing
simple data manipulation
truncated strings
detecting with indicator variable
truncation
from data conversion
of character data
of numeric data
type conversion
character data
numeric data
type declarations
in include files
type declaration section
U
UDC's
PFOR
PPFOR
preprocess, compile, link
unique index
on column named in a WHERE clause
UPDATE
basic use
UPDATE command
used with LONG columns
used with TO_DATE function
used with TO_DATETIME function
UPDATE STATISTICS
before preprocessing
UPDATE WHERE CURRENT
UPDATE WHERE CURRENT command
used with LONG columns
updating application programs
USCs
preprocess
USER
as default data value
using default data values
introduction to
V
varbinary data
using the LONG phrase with
VARCHAR data
host variables and
VARCHAR(n)
type description
variable
join
variable declaration include file
variable types
compatibile with ALLBASE/SQL
view
W
WHENEVER
and implicit status checking
CONTINUE
GOTO
NOT FOUND
SQLERROR
SQLWARNING
STOP
WHERE clause
in DELETE
in SELECT