HPlogo ALLBASE/SQL FORTRAN Application Programming Guide: HP 9000 Computer Systems

Index
» 

Technical documentation

» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

Symbols

*
in SELECT, The SELECT Command
300/400 differences, DBEnvironment Access
compiler command, The Compiler and the Linker
debugging, Setting Signal Handling for Debugging
preprocessor banner, ALLBASE/SQL Message File
shared memory, Series 300 Shared Memory

A

absolute pathname
use in file referencing, File Referencing
access optimization, Purpose of Sections
access validation, Purpose of Sections
criteria, Section Validity
active set
and cursors, Introducing the Cursor
and sequential processing, Overview of Data Manipulation
in sequential processing, Processing with Cursors
using the CLOSE command before re-accessing, The CLOSE Command
ADD_MONTHS function
example with SELECT, Example ADD_MONTHS Function
syntax, Using the Date/Time ADD_MONTHS Function
aggregate function, The SELECT Command, Selecting Using Views
and WHERE clause, The SELECT Command
null values in, Indicator Variables
ALLBASE/SQL
maintaining programs, Maintaining ALLBASE/SQL Programs
ALTER TABLE command
syntax for LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
ANSI SQL1 level 2
specifying a default value, Using Default Data Values
ANSI SQL86 level 2
floating point data, FLOAT Data
application program
FORTRAN, Getting Started with ALLBASE/SQL Programming in FORTRAN
atomic operation
transaction as, Maintaining Data Consistency
authority
-r (revoke), Full Preprocessing Mode
DBA, Authorization
preserving RUN authority, Updating Application Programs
revoking RUN authority, Updating Application Programs
authorization, Authorization
changing, Maintaining ALLBASE/SQL Programs
dynamic preprocessing, Differences between Dynamic and Non-Dynamic Preprocessing
granting, Granting Required Owner Authorization
runtime, Authorization
to execute, Authorization, Granting Program User Authorization
to install a module, The Executable Program
to maintain, Authorization
to preprocess, Authorization
autostart mode, Starting a DBE Session

B

background preprocessing, Invoking the Fortran Preprocessor
base table, Selecting Using Views
BEGIN DECLARE SECTION, Preprocessor Source File, Location of SQL Commands, Declaring Host Variables
and include files, Effect of Preprocessing on Source Code
BEGIN WORK, Defining Transactions
in transaction management, Transaction Management for Simple Operations
issued by preprocessor, Full Preprocessing Mode
binary data
compatibility, Binary Data Compatibility
host variable definition, Binary Data Compatibility
how stored, BINARY Data
using the LONG phrase with, Using the LONG Phrase with Binary Data Types

C

catalog
system, Stored Sections
CHAR(1)
type description, INTEGER Data
CHAR(n)
type description, INTEGER Data
character data
conversion, Character Data Conversion
truncation, Character Data Truncation
type description, INTEGER Data
CHECKPOINT, Full Preprocessing Mode
clause
FOR UPDATE, The DECLARE CURSOR Command, The UPDATE WHERE CURRENT Command, The DELETE WHERE CURRENT Command
GROUP BY, The SELECT Command, Selecting Using Views
HAVING, The SELECT Command
IN, The DECLARE CURSOR Command
ORDER BY, The SELECT Command, The DECLARE CURSOR Command
WHERE, The SELECT Command, The DELETE Command
CLOSE, Introducing the Cursor, Sequential Table Processing Commands, The CLOSE Command
before ending a transaction, The CLOSE Command, Transaction Management for Cursor Operations
with COMMIT WORK, OPEN Command Using KEEP CURSOR WITH LOCKS
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS
cluster count, Query Efficiency
coding considerations
for date/time functions, Coding Considerations
for LONG columns, Coding Considerations, File Naming Conventions, Considering Multiple Users, Deciding How Much Space to Allocate and Where
colon
before host variable name, Host Variable Names
column specifications for floating point data, FLOAT Data
command, INTEGER Data
BEGIN DECLARE SECTION, Preprocessor Source File, Location of SQL Commands, Declaring Host Variables
BEGIN WORK, Defining Transactions
CHECKPOINT, Full Preprocessing Mode
CLOSE, Introducing the Cursor, Sequential Table Processing Commands, The CLOSE Command
COMMIT WORK, Defining Transactions
CONNECT TO, Starting a DBE Session
data definition, Defining and Manipulating Data
data manipulation, Defining and Manipulating Data, Data Manipulation, Simple Data Manipulation
DECLARE CURSOR, Introducing the Cursor, Sequential Table Processing Commands, The DECLARE CURSOR Command
DELETE, Overview of Data Manipulation, The DELETE Command
DELETE WHERE CURRENT, Sequential Table Processing Commands, The DELETE WHERE CURRENT Command
DROP MODULE, Updating Application Programs
dynamic, Using Host Variables
embedded SQL, Getting Started with ALLBASE/SQL Programming in FORTRAN
embedding SQL, Embedding SQL Commands
END DECLARE SECTION, Preprocessor Source File, Location of SQL Commands, Declaring Host Variables
EXECUTE, Dynamic Operations
EXECUTE IMMEDIATE, Dynamic Operations
FETCH, Using SQLCode of 100, Introducing the Cursor, Sequential Table Processing Commands, The FETCH Command
GRANT, Granting Required Owner Authorization
INCLUDE SQLCA, Location of SQL Commands, Declaring the SQLCA, Declaring Host Variables Passed from Subprograms, The SQLCA COMMON Block
INSERT, Overview of Data Manipulation, The INSERT Command
OPEN, Introducing the Cursor, Sequential Table Processing Commands, The OPEN Command
PREPARE, Dynamic Operations
REVOKE, Changing Program-Related Authorization
ROLLBACK WORK, Defining Transactions
SELECT, Overview of Data Manipulation, The SELECT Command, The SELECT Command
SQLEXPLAIN, Obtaining ALLBASE/SQL Messages, Runtime Status Checking and the SQLCA, SQLCA.SQLCODE, Approaches to Status Checking
UPDATE, Overview of Data Manipulation, The UPDATE Command
UPDATE WHERE CURRENT, Sequential Table Processing Commands, The UPDATE WHERE CURRENT Command
WHENEVER, Implicit Status Checking, SQLCA.SQLCODE, SQLCA.SQLWARN(0)
WHENEVER SQLERROR, Implicit Status Checking
commands
COMMIT WORK, Stored Sections
comments
in embedded SQL files, FORTRAN Comments
comments in ALLBASE/SQL commands, FORTRAN Comments
COMMIT WORK, Stored Sections, Defining Transactions
in transaction management, Transaction Management for Simple Operations
issued by preprocessor, Full Preprocessing Mode
with CLOSE, OPEN Command Using KEEP CURSOR WITH LOCKS
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS
common block, Declaring Host Variables Passed from Subprograms
SQLCA, Program Structure
communication area
SQLCA, Declaring the SQLCA
comparison predicate
in WHERE clause, The SELECT Command
compiler, The Compiler and the Linker
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
input files, Preprocessor Input and Output
separate compilable section, DBEnvironment Access
step in program creation, The Compiler and the Linker
used after preprocess, Getting Started with ALLBASE/SQL Programming in FORTRAN
compiler command
300/400 differences, The Compiler and the Linker
compiler directive, The Compiler and the Linker
ELSE, FORTRAN Preprocessor Compiler Directives
ENDIF, FORTRAN Preprocessor Compiler Directives
IF, FORTRAN Preprocessor Compiler Directives
INCLUDE, FORTRAN Preprocessor Compiler Directives
SET, FORTRAN Preprocessor Compiler Directives
concurrency, Defining Transactions, Transaction Management for Simple Operations
condition
in WHENEVER, Implicit Status Checking
join, Selecting from Multiple Tables, Selecting Using Views
search, The SELECT Command
types in WHENEVER, Implicit Status Checking
CONNECT
issued by preprocessor, Full Preprocessing Mode
CONNECT TO, Starting a DBE Session
constant
as default data value, Using Default Data Values
constraint test matrix for integrity constraints, Using Unique and Referential Integrity Constraints
continuation lines, Continuation Lines
CONTINUE action
in WHENEVER, Implicit Status Checking
CREATE TABLE command
syntax for LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
current language, Native Language Support
current row
and DELETE WHERE CURRENT, The DELETE WHERE CURRENT Command
of active set, Introducing the Cursor
CURRENT_DATE function result
used as default data value, Using Default Data Values
CURRENT_DATETIME function result
used as default data value, Using Default Data Values
CURRENT_TIME function result
used as default data value, Using Default Data Values
cursor, Data Definition
and sequential processing, Overview of Data Manipulation
effect of commands on, Introducing the Cursor
in sequential processing, Processing with Cursors
managing a query result, Introducing the Cursor
cursor processing
transaction management, Transaction Management for Cursor Operations

D

d (drop), Updating Application Programs
module, Full Preprocessing Mode
data access, Selecting Using Views
data compatibility
binary, Binary Data Compatibility
floating point, Floating Point Data Compatibility
for date/time function parameters, Defining and Using Host Variables with Date/Time Functions
for default data values, Coding Considerations
LONG binary, Using the LONG Phrase with Binary Data Types
LONG varbinary, Using the LONG Phrase with Binary Data Types
data consistency, SQLCA.SQLERRD(3)
through status checking, Maintaining Data Consistency
data definition commands
embedding in programs, Defining and Manipulating Data
data input using date/time functions, Using Date/Time Input Functions
data integrity
changes to error checking , Comparing Statement Level and Row Level Integrity
introduction to, Programming with Constraints
number of rows processed , Comparing Statement Level and Row Level Integrity
row level versus statement level, Comparing Statement Level and Row Level Integrity
using SQLERRD(3) with FORTRAN, Comparing Statement Level and Row Level Integrity
data manipulation
embedded commands for, Data Manipulation
data manipulation commands, Data Manipulation, Overview of Data Manipulation, Simple Data Manipulation, Simple Data Manipulation
embedding in programs, Defining and Manipulating Data
data retrieval using date/time functions, Using Date/Time Output Functions
data storage
binary data, BINARY Data
data structure, Declaring the SQLCA
data type compatibility, Data Type Compatibility
data type conversion, Data Type Compatibility
data types, INTEGER Data
binary, BINARY Data
compatibility with ALLBASE/SQL types, Host Variables
floating point, FLOAT Data
for host variables, Data Types
used with LONG columns, General Concepts
data values, Using Host Variables
data visibility, Selecting Using Views
DataBase Administrator (DBA), Granting Program User Authorization
Database Environment Configuration, File Referencing
date/time ADD_MONTHS function
overview, Using the Date/Time ADD_MONTHS Function
where to use, Using the Date/Time ADD_MONTHS Function
date/time functions
coding considerations, Coding Considerations
data compatibility, Defining and Using Host Variables with Date/Time Functions
example using default format specifications, Example Using the INSERT Command
examples using ManufDB database, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions, Using Date/Time Output Functions, Example ADD_MONTHS Function
how used, Defining and Using Host Variables with Date/Time Functions
introduction to, Programming with Date/Time Functions
leading zeros required for input functions, Coding Considerations
parameters for, Defining and Using Host Variables with Date/Time Functions
unspecified format elements default filled, Coding Considerations
used to add a number of months, Using the Date/Time ADD_MONTHS Function
used when inputting data, Using Date/Time Input Functions
used when retrieving data, Using Date/Time Output Functions
using host variables for format specifications, Defining and Using Host Variables with Date/Time Functions
using host variables for input and output data, Defining and Using Host Variables with Date/Time Functions
using host variables with, Defining and Using Host Variables with Date/Time Functions
where to use ADD_MONTHS, Using the Date/Time ADD_MONTHS Function
where to use input functions, Using Date/Time Input Functions
where to use output functions, Using Date/Time Output Functions
where to use TO_CHAR, Using Date/Time Output Functions
where to use TO_DATE, Using Date/Time Input Functions
where to use TO_DATETIME, Using Date/Time Input Functions
where to use TO_INTEGER, Using Date/Time Output Functions
where to use TO_INTERVAL, Using Date/Time Input Functions
where to use TO_TIME, Using Date/Time Input Functions
where used, Where Date/Time Functions Can Be Used
date/time input functions
examples, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions
not intended for use in select list, Using Date/Time Input Functions
overview, Using Date/Time Input Functions
where to use, Using Date/Time Input Functions
date/time output functions
examples, Example TO_CHAR Function, Example TO_INTEGER Function
overview, Using Date/Time Output Functions
where to use, Using Date/Time Output Functions, Using the Date/Time ADD_MONTHS Function
DBA, Granting Program User Authorization
authority, Authorization
DBE session
in preprocessing, Full Preprocessing Mode
DBECon file
creating, File Referencing
DBEFileSet, Stored Sections
DBEnvironment
accessed by preprocessor, The Preprocessor and Program Development
accessing in programs, DBEnvironment Access
naming, Full Preprocessing Mode
naming in programs, DBEnvironment Access
naming in psqlfor command, DBEnvironment Access
programs that can access, The Executable Program
session, Granting Program User Authorization, Starting a DBE Session, Terminating a DBE Session
starting a session, Starting a DBE Session
terminating a session, Terminating a DBE Session
used by preprocessor, DBEnvironment Access
DBEnvironment Name
host variables and, DBEnvironment Name
DDL operations
used with integrity constraints, Using Unique and Referential Integrity Constraints
used with LONG columns, Programming with LONG Columns
deadlock, Full Preprocessing Mode, SQLWARN(6)
recovering from, Handling Runtime Errors and Warnings
restarting transaction following, SQLWARN(6)
deadlock detection, SQLWARN(6)
debugging, Setting Signal Handling for Debugging
setting flags, Setting Signal Handling for Debugging
signals, Setting Signal Handling for Debugging
DECIMAL
type description, INTEGER Data
decimal data
and DOUBLE PRECISION variables, DECIMAL Data
declaration
FORTRAN COMMON BLOCK, Preprocessor Modified Source File
section, Declaring Variables for Data Types
type, Effect of Preprocessing on Source Code
declaration of data
FLOAT, FLOAT Data
DECLARE Command
BEGIN, Location of SQL Commands
END, Location of SQL Commands
DECLARE CURSOR, Introducing the Cursor, Sequential Table Processing Commands, The DECLARE CURSOR Command
declaring
arrays, Declaring Host Variables for Data Values and Indicator Variables
data variables, Declaring Host Variables for Data Values and Indicator Variables
dynamic command variables, Declaring Host Variables for Dynamic Commands
host variables, Declaring Host Variables, Host Variables, Declaring Host Variables
indicator variables, Declaring Host Variables for Data Values and Indicator Variables
message variables, Declaring Host Variables for Message Catalog Messages
passed host variables, Declaring Host Variables Passed from Subprograms
savepoint number variables, Declaring Host Variables for Savepoint Numbers
SQLCA, Declaring the SQLCA, The SQLCA COMMON Block
default data values
constant, Using Default Data Values
data compatibility, Coding Considerations
for columns allowing nulls, Using Default Data Values
in addition to null, Using Default Data Values
not used with LONG BINARY data, When the DEFAULT Clause Cannot be Used
not used with LONG columns, When the DEFAULT Clause Cannot be Used
not used with LONG VARBINARY data, When the DEFAULT Clause Cannot be Used
NULL, Using Default Data Values
result of CURRENT_DATE function, Using Default Data Values
result of CURRENT_DATETIME function, Using Default Data Values
result of CURRENT_TIME function, Using Default Data Values
USER, Using Default Data Values
default format specification example
date/time functions, Example Using the INSERT Command
defining integrity constraints, Using Unique and Referential Integrity Constraints
defining LONG columns
in a table, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
input and output specification, Defining Input and Output with the LONG Column I/O String
with the LONG column I/O string, Defining Input and Output with the LONG Column I/O String
definitions
fast ipc, Choosing an Interprocess Communication Option
input device specification, Defining Input and Output with the LONG Column I/O String
LONG column I/O string, Defining Input and Output with the LONG Column I/O String
output device specification, Defining Input and Output with the LONG Column I/O String
row level integrity, Comparing Statement Level and Row Level Integrity
signal ipc, Choosing an Interprocess Communication Option
DELETE, The DELETE Command
basic use, Overview of Data Manipulation
DELETE command
used with LONG columns, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
with TO_DATETIME function, Example Using the DELETE Command
DELETE WHERE CURRENT, Sequential Table Processing Commands, The DELETE WHERE CURRENT Command
DELETE WHERE CURRENT command
used with LONG columns, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
deleting a module, Updating Application Programs
designing an application using statement level integrity, Designing an Application Using Statement Level Integrity Checks
directive
compiler, The Compiler and the Linker, FORTRAN Preprocessor Compiler Directives
directives, ALLBASE/SQL FORTRAN Programs
DISTINCT clause, Selecting Using Views
DML operations
used with date/time functions, Where Date/Time Functions Can Be Used
used with integrity constraints, Using Unique and Referential Integrity Constraints
used with LONG columns, Programming with LONG Columns
DOUBLE PRECISION
type description, INTEGER Data
DROP, Updating Application Programs
drop
-d, Updating Application Programs, Full Preprocessing Mode
modules, Maintaining ALLBASE/SQL Programs, Updating Application Programs, Full Preprocessing Mode
DROP MODULE, Updating Application Programs
dynamic command, Authorization, Using Dynamic Operations
host variables for, Declaring Host Variables for Dynamic Commands
passing to ALLBASE/SQL, Passing Dynamic Commands to ALLBASE/SQL
type description, INTEGER Data
using host variables for, Using Host Variables
dynamic FETCH command
used with LONG columns, Using LONG Columns with a Dynamic FETCH Command
dynamic operation, Overview of Data Manipulation
embedded commands for, Data Manipulation
uses of, Dynamic Operations
using host variables with, Data Manipulation
dynamic operations
dynamic commands, Review of Preprocessing Events
handling non-queries, Using EXECUTE IMMEDIATE
sample programs, Programs Using Dynamic Operations
techniques, Using Dynamic Operations
dynamic preprocessing, Review of Preprocessing Events
authorization for, Differences between Dynamic and Non-Dynamic Preprocessing

E

editor
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
ELSE
compiler directive, FORTRAN Preprocessor Compiler Directives
embedded SQL
defined, Getting Started with ALLBASE/SQL Programming in FORTRAN
embedded SQL Commands
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
embedding SQL commands
continuation lines, Continuation Lines
general rules, General Rules for Embedding SQL
introduction, Program Structure
overview, Embedding SQL Commands
prefix, Program Structure
END DECLARE SECTION, Preprocessor Source File, Location of SQL Commands, Declaring Host Variables
and include files, Effect of Preprocessing on Source Code
end SQL preprocessor, Preprocessor Modified Source File
ENDIF
compiler directive, FORTRAN Preprocessor Compiler Directives
environment variables
HPSQLfast_ipc, Setting the HPSQLfast_ipc Environment Variable
error
invocation, Preprocessor Invocation Errors
source file, Source File Errors
error checking
changes for this release, Comparing Statement Level and Row Level Integrity
using SQLERRD(3) with FORTRAN, Comparing Statement Level and Row Level Integrity
with row level integrity, Comparing Statement Level and Row Level Integrity
with statement level integrity, Comparing Statement Level and Row Level Integrity
error messages
in sqlmsg, ALLBASE/SQL Message File
errors
preprocessing, Preprocessing Errors
example
DELETE command with TO_DATETIME function, Example Using the DELETE Command
FETCH command with TO_INTEGER function, Example TO_INTEGER Function
INSERT command with TO_DATE function , Example Using the INSERT Command
INSERT command with TO_DATETIME function, Example Using the INSERT Command
INSERT command with TO_INTERVAL function, Example Using the INSERT Command
INSERT command with TO_TIME function, Example Using the INSERT Command
LONG column descriptor declaration, Example LONG Column Descriptor Declaration
SELECT command with ADD_MONTHS function, Example ADD_MONTHS Function
SELECT command with TO_CHAR function, Example TO_CHAR Function
SELECT command with TO_DATETIME function, Example Using the SELECT Command, Example TO_CHAR Function
SELECT command with TO_INTERVAL function, Example Using the SELECT Command
UPDATE command with TO_DATE function, Example Using the UPDATE Command
UPDATE command with TO_DATETIME function, Example Using the UPDATE Command
example application design
using integrity constraints, Designing an Application Using Statement Level Integrity Checks
example data file
INSERT command with LONG columns, Example Data File
examples of date/time input functions, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions
examples of date/time output functions, Example TO_CHAR Function, Example TO_INTEGER Function
EXEC SQL, Prefix
command delimiter, Program Structure
prefix, General Rules for Embedding SQL
executable program, Getting Started with ALLBASE/SQL Programming in FORTRAN, DBEnvironment Access, The Executable Program
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
EXECUTE, Dynamic Operations
non-dynamic queries, Using PREPARE and EXECUTE
EXECUTE IMMEDIATE, Dynamic Operations
executing a program, Authorization
executing ALLBASE/SQL FORTRAN programs, The Executable Program
explicit status checking, Runtime Status Checking and the SQLCA, Approaches to Status Checking, Explicit Status Checking, Explicitly Invoking Status-Checking Subprogram Units
embedded commands for, Explicit Status Checking
expression
defined, The SELECT Command
external procedure, Effect of Preprocessing on Source Code

F

fast ipc
definition, Choosing an Interprocess Communication Option
how to set, Choosing an Interprocess Communication Option
when to use, Choosing an Interprocess Communication Option
fc -c
compile only option, DBEnvironment Access
FETCH, Using SQLCode of 100, Introducing the Cursor, Sequential Table Processing Commands, The FETCH Command
FETCH command
used dynamically with LONG columns, Using LONG Columns with a Dynamic FETCH Command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
with TO_INTEGER function, Example TO_INTEGER Function
field
SQLCode, Declaring the SQLCA
SQLErrd(3), Declaring the SQLCA
SQLWarn(0), Declaring the SQLCA
SQLWarn(6), Declaring the SQLCA
file
Database Environment Configuration, File Referencing
DBECon, File Referencing
include, Getting Started with ALLBASE/SQL Programming in FORTRAN, The Preprocessor and Program Development, Preprocessor Modified Source File
installable module, Getting Started with ALLBASE/SQL Programming in FORTRAN
log, Full Preprocessing Mode
modified source code, Getting Started with ALLBASE/SQL Programming in FORTRAN, The Compiler and the Linker
variable declaration include, Variable Declaration Include File
file IO
KEEP CURSOR, Writing KEEP CURSOR Applications
FLOAT
type description, INTEGER Data
FLOAT data
host variables and, FLOAT Data
FLOAT data declaration, FLOAT Data
floating point data
4-byte, FLOAT Data
8-byte, FLOAT Data
column specifications, FLOAT Data
compatibility, Floating Point Data Compatibility
REAL keyword, FLOAT Data
FOR UPDATE clause
in DECLARE CURSOR, The DECLARE CURSOR Command
in DELETE WHERE CURRENT, The DELETE WHERE CURRENT Command
in UPDATE WHERE CURRENT, The UPDATE WHERE CURRENT Command
forex2
sample program, Preprocessor Source File
forex9a, Programs Using Dynamic Operations
FORTRAN application program, Getting Started with ALLBASE/SQL Programming in FORTRAN
FORTRAN COMMON BLOCK, Preprocessor Modified Source File
full preprocessing mode, Preprocessor Modes, Full Preprocessing Mode
in preprocessor, The Preprocessor and Program Development
function, The SELECT Command
aggregate, The SELECT Command

G

GOTO action
in WHENEVER, Implicit Status Checking
GRANT Command, Granting Required Owner Authorization
granting authorization, Granting Required Owner Authorization
GROUP BY clause, Selecting Using Views
in SELECT, The SELECT Command

H

HAVING clause
in SELECT, The SELECT Command
host variable
declaring for DBEnvironment names, Declaring Host Variables for DBEnvironment Names
host variable declaration section, Declaring Host Variables
host variable names, Host Variable Names
host variables, Effect of Preprocessing on Source Code
data description entries, VARCHAR Data
data types, Data Types
data values, Data Values and Null Indicators
declaring, Declaring Host Variables, Declaring Host Variables
defined, Host Variables
embedded declarations for, Location of SQL Commands
for dynamic commands, Declaring Host Variables for Dynamic Commands
indicator variables, Indicator Variables
input, Input and Output Host Variables
naming, Using Host Variables
null indicators, Data Values and Null Indicators
output, Input and Output Host Variables
referenced in SQL commands, ALLBASE/SQL FORTRAN Programs
used for binary data, Binary Data Compatibility
used for LONG column I/O strings, Insert Using Host Variables for LONG Column I/O Strings
used with date/time functions, Defining and Using Host Variables with Date/Time Functions
using, Using Host Variables
with SELECT, The SELECT Command
hpsqlcat, Running the Program
HPSQLfast_ipc environment variable
to set interprocess communication, Setting the HPSQLfast_ipc Environment Variable

I

i SourceFileName.sql, Syntax Checking Mode, Full Preprocessing Mode
preprocessor option, DBEnvironment Access
IF
compiler directive, FORTRAN Preprocessor Compiler Directives
implicit status checking, Runtime Status Checking and the SQLCA, SQLCA.SQLCODE, Approaches to Status Checking, Implicit Status Checking
embedded commands for, Implicit Status Checking
IN clause
in DECLARE CURSOR, The DECLARE CURSOR Command
INCLUDE
compiler directive, FORTRAN Preprocessor Compiler Directives
include file, The Preprocessor and Program Development, Preprocessor Modified Source File
created by preprocessor, Getting Started with ALLBASE/SQL Programming in FORTRAN
host variable type declarations, The Preprocessor and Program Development
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
variable declaration, Variable Declaration Include File
INCLUDE SQLCA, Location of SQL Commands, Declaring the SQLCA, Declaring Host Variables Passed from Subprograms, The SQLCA COMMON Block
index, Query Efficiency
count, Query Efficiency
preventing duplicate values, The SELECT Command
index scan, Query Efficiency
and locking, Introducing the Cursor
indicator variable, Indicator Variables
declaring, Declaring Host Variables
for null values, The UPDATE Command
setting a column to null with, The UPDATE Command
type description, INTEGER Data
use of, Declaring Host Variables
using host variables for, Using Host Variables
indicator variable declaration, Indicator Variable Declaration
input device specification
definition, Defining Input and Output with the LONG Column I/O String
input host variables, Input and Output Host Variables
input tree
part of section, Stored Sections
INSERT, The INSERT Command
basic use, Overview of Data Manipulation
INSERT command
used with LONG columns, Putting Data into a LONG Column with an INSERT Command
using host variables for LONG column I/O strings, Insert Using Host Variables for LONG Column I/O Strings
with LONG columns
example data file, Example Data File
with TO_DATE function, Example Using the INSERT Command
with TO_DATETIME function, Example Using the INSERT Command
with TO_INTERVAL function, Example Using the INSERT Command
with TO_TIME function, Example Using the INSERT Command
INSTALL, Updating Application Programs, Installable Module File
install command, The Executable Program
installable module, The Executable Program, Installing the Program Module
created by preprocessor, Getting Started with ALLBASE/SQL Programming in FORTRAN
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
preprocessor output, Installable Module File
INTEGER
type description, INTEGER Data
INTEGER data
host variables and, VARCHAR Data, INTEGER Data
INTEGER*2
type description, INTEGER Data
integrity constraint definition, Using Unique and Referential Integrity Constraints
integrity constraints
and statement level integrity, Using Unique and Referential Integrity Constraints
commands used with, Using Unique and Referential Integrity Constraints
constraint test matrix, Using Unique and Referential Integrity Constraints
designing an application, Designing an Application Using Statement Level Integrity Checks
example application using RecDB database, Designing an Application Using Statement Level Integrity Checks
in RecDB database, Designing an Application Using Statement Level Integrity Checks
introduction to, Programming with Constraints
restrictions, Using Unique and Referential Integrity Constraints
unique and referential, Using Unique and Referential Integrity Constraints
interprocess communication options
fast ipc, Choosing an Interprocess Communication Option
how to set, Choosing an Interprocess Communication Option
HPSQLfast_ipc environment variable, Setting the HPSQLfast_ipc Environment Variable
introduction to, Choosing an Interprocess Communication Option
signal ipc, Choosing an Interprocess Communication Option
when to use, Choosing an Interprocess Communication Option
invalid
section, Stored Sections
sections, Section Validity
stored section, Stored Sections
invocation
errors, Preprocessor Invocation Errors
invoke
preprocessor, DBEnvironment Access
ISQL
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN

K

KEEP CURSOR
file IO, Writing KEEP CURSOR Applications
terminal IO, Writing KEEP CURSOR Applications
KEEP CURSOR WITH NOLOCKS command
use with OPEN command , The OPEN Command, Using KEEP CURSOR

L

label
GOTO, Implicit Status Checking
in error handling, SQLCA.SQLCODE
with WHENEVER commands, Implicit Status Checking
LANG variable
setting and resetting, Native Language Support
language
current language, Native Language Support
native language support, Native Language Support
of DBEnvironment, Full Preprocessing Mode
setting and resetting, Native Language Support
link command
300/400 differences, DBEnvironment Access
options, DBEnvironment Access
linker
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
separate linked objects, DBEnvironment Access
step in program creation, The Compiler and the Linker
locking
and scan types, Introducing the Cursor
in WHERE clause, Query Efficiency
locks
releasing after a CLOSE, The CLOSE Command
log file, Full Preprocessing Mode
log file space
use during preprocessing, Full Preprocessing Mode
logging, Full Preprocessing Mode
logical data consistency, SQLCA.SQLERRD(3)
LONG binary data
compatibility, Using the LONG Phrase with Binary Data Types
definition, Using the LONG Phrase with Binary Data Types
how stored, Using the LONG Phrase with Binary Data Types
LONG binary versus LONG varbinary data usage, Using the LONG Phrase with Binary Data Types
LONG column definition
in a table, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
input and output specification , Defining Input and Output with the LONG Column I/O String
with the LONG column I/O string, Defining Input and Output with the LONG Column I/O String
LONG column descriptor
contents of, Using the LONG Column Descriptor
example declarationtitle;, Example LONG Column Descriptor Declaration
general concept, General Concepts
how used, Using the LONG Column Descriptor
introduction to, Defining Input and Output with the LONG Column I/O String
LONG column I/O string
general concept, General Concepts
how used , Defining Input and Output with the LONG Column I/O String
input device specification, Defining Input and Output with the LONG Column I/O String
output device specification, Defining Input and Output with the LONG Column I/O String
shared memory input and output, Insert Using Host Variables for LONG Column I/O Strings
used with host variable, Insert Using Host Variables for LONG Column I/O Strings
used with INSERT command, Insert Using Host Variables for LONG Column I/O Strings
LONG columns
changing data, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
coding considerations, Coding Considerations
commands used with, Programming with LONG Columns
considering multiple users, Considering Multiple Users
data types used with, General Concepts
deciding on space allocation, Deciding How Much Space to Allocate and Where
deleting data, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
file usage from an application, Defining Input and Output with the LONG Column I/O String
general concepts, General Concepts
input options, Defining Input and Output with the LONG Column I/O String
introduction to, Programming with LONG Columns
maximum per table definition, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
output options, Defining Input and Output with the LONG Column I/O String
performance, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
putting data in, Putting Data into a LONG Column with an INSERT Command
restrictions, Restrictions
retrieving data from, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
size maximum, General Concepts
specifying a DBEFileSet, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
storage, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
storing and retrieving data, General Concepts
used with DELETE [WHERE CURRENT] command, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
used with dynamic FETCH command, Using LONG Columns with a Dynamic FETCH Command
used with FETCH or REFETCH commands, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
used with INSERT command, Putting Data into a LONG Column with an INSERT Command
used with SELECT command, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
used with UPDATE [WHERE CURRENT] command, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
using file naming conventions, File Naming Conventions
using file versus shared memory, Coding Considerations
using the LONG column descriptor, Using the LONG Column Descriptor
LONG phrase
used with binary data, Using the LONG Phrase with Binary Data Types
used with varbinary data, Using the LONG Phrase with Binary Data Types
LONG varbinary data
compatibility, Using the LONG Phrase with Binary Data Types
definition, Using the LONG Phrase with Binary Data Types
how stored, Using the LONG Phrase with Binary Data Types
lsql option, The Compiler and the Linker

M

m ModuleName, Full Preprocessing Mode
preprocessor option, Effect of Preprocessing on DBEnvironments
maintaining program, Maintaining ALLBASE/SQL Programs
ManufDB database
examples using date/time functions, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions, Using Date/Time Output Functions, Example ADD_MONTHS Function
message catalog, Using Host Variables, Runtime Status Checking and the SQLCA
and SQLEXPLAIN, Obtaining ALLBASE/SQL Messages
and status checking, Explicit Status Checking
default, Running the Program
native language, Running the Program
variables for messages, Declaring Host Variables for Message Catalog Messages
with SQLEXPLAIN, Obtaining ALLBASE/SQL Messages
message catalog message
type description, INTEGER Data
message catalog messages
host variables and, Message Catalog Variable Declaration
mode
autostart, Starting a DBE Session
multiuser, Full Preprocessing Mode
preprocessing, Preprocessor Modified Source File
preprocessor, Preprocessor Modes
syntax checking, Syntax Checking Mode
modified source file
sample, Preprocessor Modified Source File
ModifiedSourceFileName
-p, Syntax Checking Mode
ModifiedSourceFileName.f, The Compiler and the Linker
-p, Full Preprocessing Mode
created by preprocessor, Getting Started with ALLBASE/SQL Programming in FORTRAN
FORTRAN compiler input, Preprocessor Input and Output
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
preprocessor output, Preprocessor Input and Output
sample programs, Preprocessor Modified Source File
ModifiedSourceFileName.sqlm
content of, Installable Module File
preprocessor output, Preprocessor Input and Output
ModifiedSourceFileName.sqlv
FORTRAN compiler input, Preprocessor Input and Output
preprocessor output, Preprocessor Input and Output
type declarations in, Effect of Preprocessing on Source Code
module
-d (drop), Full Preprocessing Mode
-m name, Full Preprocessing Mode
associated sections, Stored Sections
creation, Effect of Preprocessing on DBEnvironments
DBEFileSet, Stored Sections
deleting, Updating Application Programs
DROP MODULE, Updating Application Programs
dropping, Updating Application Programs
installable, Getting Started with ALLBASE/SQL Programming in FORTRAN, Installing the Program Module
name, Preprocessor Source File, Stored Sections, Full Preprocessing Mode
object code, The Compiler and the Linker
owner, Stored Sections, Full Preprocessing Mode
storage, Permanently Stored vs. Temporary Sections
stored by preprocessor, Getting Started with ALLBASE/SQL Programming in FORTRAN
module owner
name, Stored Sections
ModuleName
specifying with preprocessor, Effect of Preprocessing on DBEnvironments
moving programs, The Executable Program
multiple rows
detecting with SQLCode, Using SQLCode of -10002
multiple users of LONG columns, Considering Multiple Users
multiuser mode, Full Preprocessing Mode
commands with, Starting a DBE Session

N

n-computer
defined, Native Language Support
name
-m module, Full Preprocessing Mode
-o OwnerName, Full Preprocessing Mode
DBEnvironment, Full Preprocessing Mode
login, Full Preprocessing Mode
module, Preprocessor Source File, Full Preprocessing Mode
module owner, Stored Sections
OwnerName.ModuleName, The Preprocessor and Program Development
PROGRAM statement, Full Preprocessing Mode
subroutine, Preprocessor Source File
naming conventions for LONG column files, File Naming Conventions
native language
and SQLEXPLAIN, Obtaining ALLBASE/SQL Messages
current language, Native Language Support
defaults, Native Language Support
message catalog, Running the Program
setting and resetting, Native Language Support
native language support
overview, Native Language Support
non-dynamic commands, Using Dynamic Operations
NOT FOUND condition
with WHENEVER, Implicit Status Checking
NOT NULL
columns defined as, Indicator Variables
NULL
as default data value, Using Default Data Values
null indicator variable
for updates, The UPDATE Command
null predicate
in WHERE clause, The SELECT Command
NULL result of a dynamic fetch of a LONG column, Using LONG Columns with a Dynamic FETCH Command
null value
and GROUP BY clause, The SELECT Command
in UPDATE, The UPDATE Command
indicating, Indicator Variables
null value indicators
host variables for, Indicator Variables
using host variables for, Using Host Variables
number
section, Stored Sections
number of rows processed
data integrity, Comparing Statement Level and Row Level Integrity
numeric data
conversion, Numeric Data Conversion

O

o OwnerName, Full Preprocessing Mode
object code modules, The Compiler and the Linker
OPEN, Introducing the Cursor, Sequential Table Processing Commands, The OPEN Command
OPEN command
use with KEEP CURSOR WITH NOLOCKS command, The OPEN Command, Using KEEP CURSOR
operation
join, Selecting Using Views
operations
using host variables with, Data Manipulation
optimization, Query Efficiency
access, Purpose of Sections
in WHERE clause, Query Efficiency
option
-d (drop), Updating Application Programs, Full Preprocessing Mode
-i, DBEnvironment Access
-i SourceFileName, Full Preprocessing Mode
-i SourceFileName.sql, Syntax Checking Mode
-m, Effect of Preprocessing on DBEnvironments
-m ModuleName, Full Preprocessing Mode
-o OwnerName, Full Preprocessing Mode
-p, DBEnvironment Access
-p ModifiedSourceFileName.f, Full Preprocessing Mode
-r, Updating Application Programs
-r (revoke), Full Preprocessing Mode
DISTINCT clause, Selecting Using Views
DROP, Updating Application Programs
preserve, Updating Application Programs
ORDER BY clause
in SELECT, The SELECT Command
in SELECT command defining a cursor, The DECLARE CURSOR Command
output device specification
definition, Defining Input and Output with the LONG Column I/O String
output file attributes
preprocessor files, Output File Attributes
output host variables, Input and Output Host Variables
overflow
from data conversion, Data Type Compatibility
OwnerName
-o, Full Preprocessing Mode
OwnerName.ModuleName, The Preprocessor and Program Development

P

p
ModifiedSourceFileName.f, Syntax Checking Mode
p ModifiedSourceFileName
preprocessor option, DBEnvironment Access
p ModifiedSourceFileName.f, Full Preprocessing Mode
passing SQLCA, The SQLCA COMMON Block
pathname
absolute, File Referencing
relative, File Referencing
performance
integrity constraints, Programming with Constraints
LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
permanent section
and DBEnvironment, Differences between Dynamic and Non-Dynamic Preprocessing
predicate, Query Efficiency
in a search condition, The SELECT Command
prefix
EXEC SQL, General Rules for Embedding SQL, Prefix
PREPARE, Dynamic Operations
non-dynamic queries, Using PREPARE and EXECUTE
preprocess
defined, Getting Started with ALLBASE/SQL Programming in FORTRAN
preprocess-time events, Authorization, The ALLBASE/SQL FORTRAN Preprocessor
preprocessing
full, Preprocessor Modes
log file space, Full Preprocessing Mode
modes, Preprocessor Modified Source File
single-user mode, Full Preprocessing Mode
preprocessor, Authorization
-1 option, DBEnvironment Access
-d option, Updating Application Programs, Full Preprocessing Mode
-i SourceFileName.sql option, Syntax Checking Mode, Full Preprocessing Mode
-m ModuleName option, Full Preprocessing Mode
-m option, Effect of Preprocessing on DBEnvironments
-o OwnerName option, Full Preprocessing Mode
-p ModifiedSourceFileName.f option, Full Preprocessing Mode
-p option, DBEnvironment Access
-r (revoke) option, Full Preprocessing Mode
-r option, Updating Application Programs
authorization required, Authorization
effect on DBEnvironment, Effect of Preprocessing on DBEnvironments
effect on source code, Effect of Preprocessing on Source Code
end SQL preprocessor, Preprocessor Modified Source File
errors, Preprocessing Errors
functions, Getting Started with ALLBASE/SQL Programming in FORTRAN
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
input, Preprocessor Input and Output
invocation, Invoking the Fortran Preprocessor
invoke, DBEnvironment Access, Full Preprocessing Mode
invoking, Invoking the Fortran Preprocessor
logging, Full Preprocessing Mode
messages, ALLBASE/SQL Message File
modes, The Preprocessor and Program Development, Preprocessor Modes
output, Preprocessor Input and Output
output file attributes, Output File Attributes
parsing SQLIN, Preprocessor Source File
running in background, Running the Preprocessor in the Background
start SQL preprocessor, Preprocessor Modified Source File
statements generated, Effect of Preprocessing on Source Code
temporary files, Output File Attributes
using, The Preprocessor and Program Development
preprocessor actions
full preprocessing mode, Preprocessor Modified Source File
syntax checking mode, Preprocessor Modified Source File
preprocessor banner
300/400 differences, ALLBASE/SQL Message File
PRESERVE option, Updating Application Programs
preserving RUN authority, Updating Application Programs
procedure
external, Effect of Preprocessing on Source Code
program
development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
executable, Getting Started with ALLBASE/SQL Programming in FORTRAN, DBEnvironment Access
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
execution, Authorization, The Executable Program
FORTRAN application, Getting Started with ALLBASE/SQL Programming in FORTRAN
structure,skeleton example, Program Structure
program development steps, Getting Started with ALLBASE/SQL Programming in FORTRAN
program segmentation, The Preprocessor and Program Development
PROGRAM STATEMENT, Preprocessor Source File
PROGRAM statement, Full Preprocessing Mode
psqldor, Full Preprocessing Mode
psqlfor command
naming a DBEnvironment in, DBEnvironment Access

Q

qualify
more than one row, Determining Number of Rows Processed
no rows qualify, Determining Number of Rows Processed
one or more rows qualify, Determining Number of Rows Processed
query
overview, The Query
query efficiency, Query Efficiency
query result
and SELECT, The SELECT Command

R

r (revoke), Updating Application Programs
authority/, Full Preprocessing Mode
re-preprocessing, Maintaining ALLBASE/SQL Programs
REAL keyword
floating point data, FLOAT Data
REAL*8
type description, INTEGER Data
RecDB database application design
example maintenance menu, Designing an Application Using Statement Level Integrity Checks
example of deleting data, Delete a Club in the Recreation Database, Delete an Event in the Recreation Database
example of error checking, Designing an Application Using Statement Level Integrity Checks
example of inserting data, Insert a Member in the Recreation Database
example of updating data, Update an Event in the Recreation Database
integrity constraints defined, Designing an Application Using Statement Level Integrity Checks
REFETCH command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
relative pathname
use in file referencing, File Referencing
restrictions
integrity constraints, Using Unique and Referential Integrity Constraints
LONG columns, Restrictions
retrieving LONG column data
with SELECT, FETCH, or REFETCH commands, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
REVOKE, Changing Program-Related Authorization
revoke
-r, Updating Application Programs
-r authority, Full Preprocessing Mode
revoking RUN authority, Updating Application Programs
rollback logging, Full Preprocessing Mode
ROLLBACK WORK, Defining Transactions
issued by preprocessor, Full Preprocessing Mode
to ensure data consistency, Transaction Management for Simple Operations
row
more than one row qualifies, Determining Number of Rows Processed
multiple, Using SQLCode of -10002
no rows qualify, Determining Number of Rows Processed
one or more rows qualify, Determining Number of Rows Processed
row level integrity
definition, Comparing Statement Level and Row Level Integrity
RUN authority
preserving, Updating Application Programs
revoking, Updating Application Programs, Full Preprocessing Mode
run tree
part of section, Stored Sections
running the preprocessor, Invoking the Fortran Preprocessor, Full Preprocessing Mode
runtime
status checking, Runtime Status Checking and the SQLCA
runtime authorization, Authorization
runtime library, The Compiler and the Linker

S

sample modified source file, Preprocessor Modified Source File
sample program
dynamic queries, execute immediate, Programs Using Dynamic Operations
sample programs
ModifiedSourceFileName.f, Preprocessor Modified Source File
sample sourcefilename, Preprocessor Source File, Embedding SQL Commands
sample SourceFileName.sql, Embedding SQL Commands
sample sqlmsg, ALLBASE/SQL Message File
savepoint number
declaring variables for, Declaring Host Variables for Savepoint Numbers
type description, INTEGER Data
using host variables for, Using Host Variables
scan, Query Efficiency
scan types
and locking, Introducing the Cursor
search condition
specified by WHERE clause, The SELECT Command
section
components of, Stored Sections
creation, Effect of Preprocessing on DBEnvironments
defined, Effect of Preprocessing on DBEnvironments
dynamic vs. non-dynamic, Differences between Dynamic and Non-Dynamic Preprocessing
execution, Section Validity
invalid, Stored Sections
number, Stored Sections
permanently stored, Permanently Stored vs. Temporary Sections
purpose, Purpose of Sections
stored, The Stored Section, Stored Sections
system catalog information, Stored Sections
SYSTEM.SECTION view, Stored Sections
temorarily stored, Differences between Dynamic and Non-Dynamic Preprocessing
temporary, Using PREPARE and EXECUTE
type, Stored Sections
use of, Stored Sections
valid, Stored Sections
validating, Section Validity, Stored Sections
validity, Section Validity, Stored Sections
segmenation, The Compiler and the Linker
SELECT, The SELECT Command
basic use, Overview of Data Manipulation
overview, The SELECT Command
SELECT command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command, Using LONG Columns with a SELECT Command
with ADD_MONTHS function, Example ADD_MONTHS Function
with TO_CHAR function, Example TO_CHAR Function
with TO_DATETIME function, Example Using the SELECT Command, Example TO_CHAR Function
with TO_INTERVAL function, Example Using the SELECT Command
select list
with SELECT, The SELECT Command
sequential table processing, Overview of Data Manipulation
embedded commands for, Data Manipulation
overview, Processing with Cursors
uses of, Sequential Table Processing
using cursors, Introducing the Cursor
serial scan, Query Efficiency
and locking, Introducing the Cursor
session
starting DBE, Starting a DBE Session
SET
compiler directive, FORTRAN Preprocessor Compiler Directives
shared memory
Series 300, Series 300 Shared Memory
SQLCode indicating not enough, SQLWARN(6)
use of, Use of Shared Memory
shared memory input and output, Insert Using Host Variables for LONG Column I/O Strings
shared memory problem
restarting after, SQLWARN(6)
signal ipc
definition, Choosing an Interprocess Communication Option
how to set, Choosing an Interprocess Communication Option
when to use, Choosing an Interprocess Communication Option
signals
setting for debugging, Setting Signal Handling for Debugging
to avoid in applications, Setting Signal Handling for Debugging
used by ALLBASE/SQL, Setting Signal Handling for Debugging
simple data manipulation, Overview of Data Manipulation
commands, Simple Data Manipulation
defined, Simple Data Manipulation
embedded commands for, Data Manipulation
transaction management, Transaction Management for Simple Operations
single-user mode
commands with, Starting a DBE Session
size maximum
LONG columns, General Concepts
SMALLINT
type description, INTEGER Data
source code
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
ModifiedSourceFileName.f, Getting Started with ALLBASE/SQL Programming in FORTRAN
sourcefilename
sample, Preprocessor Source File, Embedding SQL Commands
SourceFileName.sql, DBEnvironment Access, Embedding SQL Commands
-i, Syntax Checking Mode, Full Preprocessing Mode
preprocessor input, Preprocessor Input and Output, Syntax Checking Mode
SourceFileName.sqlm, Installing the Program Module
space allocation for LONG column data, Deciding How Much Space to Allocate and Where
SQL
Communication Area (SQLCA), Declaring the SQLCA
Communications Area (SQLCA), ALLBASE/SQL FORTRAN Programs
EXEC SQL, Program Structure, General Rules for Embedding SQL, Prefix
SQLEXPLAIN, Approaches to Status Checking
SQLIND, Declaring Host Variables
SQL command
length, General Rules for Embedding SQL
location, General Rules for Embedding SQL
prefix, General Rules for Embedding SQL
SQL commands
WHENEVER NOT FOUND, Preprocessor Modified Source File
WHENEVER SQLERROR, Preprocessor Modified Source File
WHENEVER SQLWARNING, Preprocessor Modified Source File
SQL communication area, The SQLCA COMMON Block
SQLCA, ALLBASE/SQL FORTRAN Programs, Declaring the SQLCA, The SQLCA COMMON Block
common block, Program Structure, Preprocessor Modified Source File, Declaring Host Variables Passed from Subprograms
data items you can use, Runtime Status Checking and the SQLCA
embedded commands for, Location of SQL Commands
fields, The SQLCA COMMON Block
INCLUDE, Declaring the SQLCA, Declaring Host Variables Passed from Subprograms
SQLCode, Runtime Status Checking and the SQLCA, Using SQLCode of 100, Using SQLCode of -10002, Introducing the Cursor, The FETCH Command
SQLErrd(3), Runtime Status Checking and the SQLCA, SQLCA.SQLERRD(3), Explicitly Checking for Number of Rows
SQLWarn(0), Runtime Status Checking and the SQLCA, SQLCA.SQLWARN(0)
SQLWarn(1), Runtime Status Checking and the SQLCA
SQLWarn(2), Runtime Status Checking and the SQLCA
SQLWarn(6), Runtime Status Checking and the SQLCA, SQLWARN(6)
sqlca.sqlwarn(1)
usage, SQLWARN(1)
sqlca.sqlwarn(2)
usage, SQLWARN(2)
SQLCode, Declaring the SQLCA, Runtime Status Checking and the SQLCA, Determining Number of Rows Processed, SQLCA.SQLCODE, Using SQLErrd(3) for UPDATE and DELETE Operations
-10002, Explicit Status Checking
-14024, Explicit Status Checking, SQLCA.SQLCODE
-4008, SQLCA.SQLCODE
0, Explicit Status Checking
100, Explicit Status Checking
after last row fetched, Introducing the Cursor
after the last fetch, The FETCH Command
and SQLErrd(3), SQLCA.SQLERRD(3)
in creating a warning for users, Determining Number of Rows Processed
multiple values for, Obtaining ALLBASE/SQL Messages
of -10002, Using SQLCode of -10002
of 100, Using SQLCode of 100
possible values of, SQLCA.SQLCODE
SQLCore
in program development cycle, Getting Started with ALLBASE/SQL Programming in FORTRAN
SQLERRD(3)
error checking with FORTRAN, Comparing Statement Level and Row Level Integrity
SQLErrd(3), Declaring the SQLCA, Runtime Status Checking and the SQLCA
determining number of rows with, Explicitly Checking for Number of Rows
in creating a warning for users, Determining Number of Rows Processed
possible values of, SQLCA.SQLERRD(3)
set to number of rows processed, Determining Number of Rows Processed
SQLERROR
WHENEVER, Implicit Status Checking
SQLERROR condition
with WHENEVER, Implicit Status Checking
SQLEXPLAIN, Obtaining ALLBASE/SQL Messages, Runtime Status Checking and the SQLCA
and approaches to status checking, Approaches to Status Checking
obtaining multiple SQLCodes, SQLCA.SQLCODE
sqlin
preprocessor input, Preprocessor Input and Output, Preprocessor Source File, Syntax Checking Mode
SQLIND, Declaring Host Variables
host variables and, Indicator Variable Declaration
type description, INTEGER Data
sqlmsg
contents of, ALLBASE/SQL Message File
preprocessor output, Preprocessor Input and Output
sample, ALLBASE/SQL Message File
sqlout
preprocessor output, Preprocessor Modified Source File
sqlv file, Variable Declaration Include File
SQLVAR
preprocessor output, Preprocessor Modified Source File
SQLWarn(0), Declaring the SQLCA
and warnings from ALLBASE/SQL, SQLCA.SQLWARN(0)
sqlwarn(1)
usage, SQLWARN(1)
sqlwarn(2)
usage, SQLWARN(2)
SQLWarn(6), Declaring the SQLCA
on rollback by ALLBASE/SQL, SQLWARN(6)
SQLWarn0, Runtime Status Checking and the SQLCA
SQLWarn1, Runtime Status Checking and the SQLCA
SQLWarn2, Runtime Status Checking and the SQLCA
SQLWarn6, Runtime Status Checking and the SQLCA
SQLWarning, SQLCA.SQLWARN(0)
SQLWARNING condition
with WHENEVER, Implicit Status Checking
START DBE
and the preprocessor, Full Preprocessing Mode
start SQL preprocessor, Preprocessor Modified Source File
starting DBE session, Starting a DBE Session
statement
PROGRAM, Preprocessor Source File
PROGRAM statement name, Full Preprocessing Mode
statement level integrity
and integrity constraints, Using Unique and Referential Integrity Constraints
status checking, Terminating a DBE Session, Runtime Status Checking and the SQLCA
code generated by preprocessor, Implicit Status Checking
embedded commands for, Implicit Status Checking
explicit, Runtime Status Checking and the SQLCA, Approaches to Status Checking, Explicit Status Checking, Explicitly Invoking Status-Checking Subprogram Units
implicit, Runtime Status Checking and the SQLCA, SQLCA.SQLCODE, Approaches to Status Checking, Implicit Status Checking
why do it?, The Importance of Status Checking
status checking action
in WHENEVER, Implicit Status Checking
status handling
code generated by preprocessor, Implicit Status Checking
status information, Runtime Status Checking and the SQLCA
STOP action
in WHENEVER, Implicit Status Checking
storage
LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
stored section, Stored Sections
contents of, The Stored Section
invalid, Stored Sections
string
truncation of, Indicator Variables
subprogram units
passing variables, Declaring Host Variables Passed from Subprograms
subroutine name, Preprocessor Source File
summary
preprocess-time events, The ALLBASE/SQL FORTRAN Preprocessor
synatx checking mode, Invoking the Fortran Preprocessor
syntax, Preprocessor Modes
syntax checking mode
preprocessor, The Preprocessor and Program Development, Syntax Checking Mode
syntax for date/time functions
ADD_MONTHS, Using the Date/Time ADD_MONTHS Function
input functions, Using Date/Time Input Functions
output functions, Using Date/Time Output Functions
TO_CHAR, Using Date/Time Output Functions
TO_DATE, Using Date/Time Input Functions
TO_DATETIME, Using Date/Time Input Functions
TO_INTEGER, Using Date/Time Output Functions
TO_INTERVAL, Using Date/Time Input Functions
TO_TIME, Using Date/Time Input Functions
syntax for LONG columns
ALTER TABLE command, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
CREATE TABLE command, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
select list, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
system catalog
information on sections, Stored Sections
locking, Full Preprocessing Mode
pages locked during preprocessing, Full Preprocessing Mode
system linker
used after preprocessing, Getting Started with ALLBASE/SQL Programming in FORTRAN
system view
SYSTEM.SECTION, Stored Sections
SYSTEM.SECTION, Stored Sections

T

table, Selecting Using Views
table processing, Sequential Table Processing
embedded commands for, Data Manipulation
sequential, Overview of Data Manipulation, Processing with Cursors
temporary section, Using PREPARE and EXECUTE
terminal IO
KEEP CURSOR, Writing KEEP CURSOR Applications
terminating
DBE session, Terminating a DBE Session
TO_CHAR function
example with SELECT command, Example TO_CHAR Function
syntax, Using Date/Time Output Functions
TO_DATE function
example with INSERT command, Example Using the INSERT Command
example with UPDATE command, Example Using the UPDATE Command
syntax, Using Date/Time Input Functions
TO_DATETIME function
example with DELETE command, Example Using the DELETE Command
example with INSERT command, Example Using the INSERT Command
example with SELECT command, Example Using the SELECT Command, Example TO_CHAR Function
example with UPDATE command, Example Using the UPDATE Command
syntax, Using Date/Time Input Functions
TO_INTEGER function
example with FETCH command, Example TO_INTEGER Function
syntax, Using Date/Time Output Functions
TO_INTERVAL function
example with INSERT command, Example Using the INSERT Command
example with SELECT command, Example Using the SELECT Command
syntax, Using Date/Time Input Functions
TO_TIME function
example with INSERT command, Example Using the INSERT Command
syntax, Using Date/Time Input Functions
transaction, Defining Transactions
embedded commands for, Defining Transactions
transaction management
cursor processing, Transaction Management for Cursor Operations
simple data manipulation, Transaction Management for Simple Operations
tree
input, Stored Sections
run, Stored Sections
truncated strings
detecting with indicator variable, Indicator Variables
truncation
from data conversion, Data Type Compatibility
of character data, Character Data Truncation
of numeric data, Numeric Data Conversion
type conversion
character data, Character Data Conversion
numeric data, Numeric Data Conversion
type declaration section, Declaring Host Variables, Declaring Variables for Data Types
type declarations
in include files, Effect of Preprocessing on Source Code

U

unique index
on column named in a WHERE clause, The SELECT Command
UPDATE, The UPDATE Command
basic use, Overview of Data Manipulation
UPDATE command
used with LONG columns , Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
used with TO_DATE function, Example Using the UPDATE Command
used with TO_DATETIME function, Example Using the UPDATE Command
UPDATE STATISTICS
before preprocessing, Full Preprocessing Mode
UPDATE WHERE CURRENT, Sequential Table Processing Commands, The UPDATE WHERE CURRENT Command
UPDATE WHERE CURRENT command
used with LONG columns, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
USER
as default data value, Using Default Data Values
userid, Full Preprocessing Mode
using default data values
introduction to, Using Default Data Values

V

valid
section, Stored Sections
sections, Section Validity
validation
access, Purpose of Sections
validation criteria
for access, Section Validity
varbinary data
using the LONG phrase with, Using the LONG Phrase with Binary Data Types
VARCHAR data
host variables and, VARCHAR Data
VARCHAR(n)
type description, INTEGER Data
variable
join, Selecting from Multiple Tables
variable declaration include file, Variable Declaration Include File
variable types
compatibile with ALLBASE/SQL, Declaring Host Variables
variables
host, Effect of Preprocessing on Source Code
view, Selecting Using Views


Transaction Management with TID Access
  		 
Feedback to webmaster