HPlogo ALLBASE/SQL Pascal Application Programming Guide: HP 3000 MPE/iX Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

Symbols

[BULK] SELECT command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command

A

active set, Introducing the Cursor
ADD_MONTHS function
example with BULK SELECT, Example ADD_MONTHS Function
syntax, Using the Date/Time ADD_MONTHS Function
aggregate function, The SELECT Command
simple data manipulation, The SELECT Command
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
ANSI standards
SQLCODE, Using the SQLCA
arrays, Bulk Table Processing, Variables Used in BULK Processing
BULK SELECT, Bulk Processing Variables
declarations of, Declaring Variables for Program Elements
in sqlda declaration, Setting up a Buffer for Query Results of Unknown Format
referencing, Bulk Table Processing
arrays, char data, CHAR Data
arrays, declaring, Dynamic Commands
atomic operation
defined, Maintaining Data Consistency
authority option
program maintenance, Changing Program-Related Authorization
authorization
and program maintenance, Updating Application Programs
changing, Updating Application Programs
dynamic preprocessing, Differences between Dynamic and Non-Dynamic Preprocessing
granting, Installing the Program Module, Granting Required Owner Authorization
program development, Granting Required Owner Authorization
runtime, Authorization
automatic rollback, SQLCA.SQLWARN[6]
autostart mode, Starting a DBE Session

B

basic SQL statements, Program Structure
BEGIN DECLARE SECTION, Location of SQL Commands, Creating Declaration Sections
as delimiter, Source File
BEGIN WORK, Transaction Management for Simple Operations
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
BULK FETCH, Bulk Table Processing
BULK FETCH command
used in example Pascal program, Program Example for Date/Time Data
BULK INSERT, Bulk Table Processing
basic uses of, BULK INSERT
BULK INSERT command
used in example Pascal program, Program Example for Date/Time Data
used with LONG columns, Putting Data into a LONG Column with a INSERT Command
BULK option
not used for dynamic FETCH, Preprocessing of Dynamic Queries
bulk processing
INTO clause, Bulk Processing Variables
bulk processing variables, Bulk Processing Variables
BULK SELECT, The SELECT Command
basic uses, BULK SELECT
BULK SELECT command
with ADD_MONTHS function, Example ADD_MONTHS Function
BULK table processing, Overview Of Data Manipulation
BULK INSERT, BULK INSERT
BULK SELECT, BULK SELECT
commands, SQL Bulk Commands
overview, Bulk Table Processing
sample program, Program Using BULK INSERT
techniques, Bulk Table Processing

C

CHAR data declaration, CHAR Data
CLOSE, Introducing the Cursor, Dynamic Operations
before ending a transaction, CLOSE, Transaction Management for Cursor Operations
freeing buffer space with, CLOSE
with COMMIT WORK, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
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
column specifications for floating point data, FLOAT Data
comments
Pascal, Pascal Comments
SQL, Pascal Comments
COMMIT WORK, Effect of Preprocessing on DBEnvironments, Defining Transactions, Transaction Management for Simple Operations
and termination, Effect of Preprocessing on DBEnvironments
with CLOSE, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
comparison predicate, The SELECT Command
compatibility, Declaring Variables for Compatibility
compiler, Section Validity
separate compilable section, DBEnvironment Access
compiler directive for SQLCODE, Using the SQLCA
concurrency, Defining Transactions, Transaction Management for Simple Operations
CONNECT, Starting a DBE Session
authority, DBEnvironment Access
granting authority, Granting Program User Authorization
to start DBE session, Authorization
consistency, Defining Transactions
constant
as default data value, Using Default Data Values
constraint test matrix for integrity constraints, Using Unique and Referential Integrity Constraints
conversion, Numeric Data Conversion
copy of module, Granting Required Owner Authorization
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, Introducing the Cursor
DELETE WHERE CURRENT, DELETE WHERE CURRENT
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
and BULK FETCH, BULK FETCH
and dynamic queries, Using the Dynamic Query Data Structures
and sections, Stored Sections
closing, Introducing the Cursor
definition, Processing with Cursors
deleting with, Introducing the Cursor
effect of commands on, Introducing the Cursor
opening, Introducing the Cursor
positioning, Introducing the Cursor
sample program, Program Using UPDATE WHERE CURRENT
techniques, Processing with Cursors
UPDATE and FETCH, UPDATE WHERE CURRENT
updating with, Introducing the Cursor
use of, Introducing the Cursor
cursor processing
CLOSE, CLOSE
commands, Processing with Cursors, SQL Cursor Commands
DECLARE CURSOR, DECLARE CURSOR
definition, SQL Cursor Commands
DELETE WHERE CURRENT, DELETE WHERE CURRENT
FETCH, FETCH
OPEN, OPEN
techniques, Processing with Cursors
transaction management, Transaction Management for Cursor Operations
UPDATE and FETCH, UPDATE WHERE CURRENT
UPDATE WHERE CURRENT, UPDATE WHERE CURRENT

D

data buffer
declaration, Dynamic Processing Arrays
layout, Setting up the Data Buffer
null indicator suffix, Setting up a Buffer for Query Results of Unknown Format
parsing, Parsing the Data Buffer
rows to retrieve, Setting up a Buffer for Query Results of Unknown Format
use of, Dynamic Operations
varchar prefix, Setting up a Buffer for Query Results of Unknown Format
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, Maintaining Data Consistency
in sample database, Maintaining Data Consistency
data definition
overview, Data Definition
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[2], Comparing Statement Level and Row Level Integrity
data manipulation
commands, Data Manipulation, Overview Of Data Manipulation
overview, Data Manipulation, Overview Of Data Manipulation
techniques, Overview Of Data Manipulation
data retrieval using date/time functions, Using Date/Time Output Functions
data storage
binary data, BINARY Data
data structures
for dynamic query, Preprocessing of Dynamic Queries
data type
and declarations, Declaring Variables for Data Types
compatibility, Declaring Variables for Compatibility
conversion, String Data Conversion, Numeric Data Conversion
equivalency, Declaring Variables for Compatibility
data types
binary, BINARY Data
floating point, FLOAT Data
used with LONG columns, General Concepts
Database Environment Configuration File, 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 data conversion
example program in Pascal, Program Example for Date/Time Data
example programs, Program Example for Date/Time Data
date/time functions, Programming with ALLBASE/SQL 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 authority, DBEnvironment Access
DBE session, Starting a DBE Session, Terminating a DBE Session
DBECon file, File Referencing
DBEnvironment
access, DBEnvironment Access
DDL operations
used with integrity constraints, Using Unique and Referential Integrity Constraints
used with LONG columns, Programming with LONG Columns
deadlock
and error recovery, Handling Runtime Errors and Warnings
status checking, Handling Deadlock and Shared Memory Problems
DECIMAL data declaration, DECIMAL Data
declaration of data
char, CHAR Data
FLOAT, FLOAT Data
integer, INTEGER Data
smallint, SMALLINT Data
varchar, VARCHAR Data
declaration part, Embedding SQL Commands, Creating Declaration Sections
DECLARE CURSOR, Introducing the Cursor, Dynamic Operations
FOR UPDATE OF, DECLARE CURSOR
preprocessor directive, DECLARE CURSOR
SELECT, DECLARE CURSOR
specify location of stored section, DECLARE CURSOR
syntax, DECLARE CURSOR
declare section, Creating Declaration Sections
and delimiters, Source File
DECLAREing for UPDATE
KEEP CURSOR, KEEP CURSOR and Isolation Levels
declaring, arrays, Dynamic Commands
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
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
DELETE, The DELETE Command
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, Introducing the Cursor
current row, DELETE WHERE CURRENT
restrictions, DELETE WHERE CURRENT
syntax, DELETE WHERE CURRENT
DELETE WHERE CURRENT command
used with LONG columns, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
DESCRIBE, Dynamic Operations
dynamic non-query, Preprocessing Dynamic Commands That May or May Not Be Queries
dynamic query, Preprocessing Dynamic Commands That May or May Not Be Queries
designing an application using statement level integrity, Designing an Application Using Statement Level Integrity Checks
directives, ALLBASE/SQL Pascal Programs
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
DROP MODULE, Obsoleting Programs
and RUN authorities, Updating Application Programs
dynamic command, Using Dynamic Operations
passing to ALLBASE/SQL, Passing Dynamic Commands to ALLBASE/SQL
queries, Dynamic Operations
query with known query result format, Sample Program Using Dynamic Queries of Known Format
query with unknown query result format, Sample Program Using Dynamic Commands of Unknown Format
dynamic commands
and authorization, Native Language Support
dynamic FETCH
BULK option not used, Preprocessing of Dynamic Queries
dynamic FETCH command
used with LONG columns, Using LONG Columns with a Dynamic FETCH Command
dynamic operations, Overview Of Data Manipulation
dynamic commands, Review of Preprocessing Events
handling non-queries, Using EXECUTE IMMEDIATE
overview, Dynamic Operations
queries vs. non-queries, Preprocessing Dynamic Commands That May or May Not Be Queries
sample program, Sample Program Using Dynamic Commands of Unknown Format, Sample Program Using Dynamic Queries of Known Format
techniques, Using Dynamic Operations
dynamic preprocessing, Dynamic Operations, Review of Preprocessing Events
authorization for, Differences between Dynamic and Non-Dynamic Preprocessing
dynamic query data structures, Preprocessing of Dynamic Queries
dynamically deleting data
DELETE WHERE CURRENT command cannot be prepared, Dynamically Updating and Deleting Data
error checking strategy, Dynamically Updating and Deleting Data
dynamically updating data
error checking strategy, Dynamically Updating and Deleting Data
UPDATE WHERE CURRENT command cannot be prepared, Dynamically Updating and Deleting Data
using SELECT command with FOR UPDATE OF clause, Dynamically Updating and Deleting Data

E

embedding SQL commands, ALLBASE/SQL Pascal Programs, Embedding SQL Commands
END DECLARE SECTION, Location of SQL Commands, Creating Declaration Sections
as delimiter, Source File
error checking
changes for this release, Comparing Statement Level and Row Level Integrity
using sqlerrd[2], Comparing Statement Level and Row Level Integrity
when dynamically deleting data, Dynamically Updating and Deleting Data
when dynamically updating data, Dynamically Updating and Deleting Data
with row level integrity, Comparing Statement Level and Row Level Integrity
with statement level integrity, Comparing Statement Level and Row Level Integrity
error messages, Obtaining ALLBASE/SQL Messages
example
BULK SELECT command with ADD_MONTHS function, Example ADD_MONTHS Function
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, Parsing LONG Column Descriptors
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
BULK INSERT command with LONG columns, Insert Using Host Variables for LONG Column I/O Strings
example program in Pascal
date/time data conversion, Program Example for Date/Time Data
example programs
date/time data conversion, Program Example for Date/Time Data
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 and Suffix
EXECUTE
non-dynamic queries, Using PREPARE and EXECUTE
executing programs, Granting Program User Authorization
explicit status checking, Explicit Status Checking Techniques
defined, Runtime Status Checking and the SQLCA
introduction, Approaches to Status Checking
expression, The SELECT Command

F

FETCH, Introducing the Cursor, Dynamic Operations
and null values, FETCH
cursor processing, FETCH
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
file
Database Environment Configuration, File Referencing
DBECon, File Referencing
include, The Preprocessor and Program Development
user include, The Preprocessor and Program Development
file IO
KEEP CURSOR, Writing Keep Cursor Applications
file name
fully qualified, File Referencing
relative, File Referencing
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 OF
UPDATE WHERE CURRENT, DECLARE CURSOR, UPDATE WHERE CURRENT
format array
declaration, Dynamic Processing Arrays
fields, Setting Up the Format Array
manditory declaration for dynamic query, Using the Dynamic Query Data Structures
FROM clause, The SELECT Command
fully qualified file name, File Referencing

H

heap space input and output, Insert Using Host Variables for LONG Column I/O Strings
host variable
and data manipulation, Data Manipulation
and modified source, Effect of Preprocessing on Source Code
declaration, Declaring Host Variables
declaration summary, INTEGER Data
declaring, Declaring Host Variables
declaring for ALLBASE/SQL messages, Messages from the Message Catalog
declaring for data, Numeric Data Conversion
declaring for DBEnvironment names, DBEnvironment Name
declaring for null values, Numeric Data Conversion
declaring for savepoints, Savepoint Numbers
overview, Declaring Host Variables
scope, Creating Declaration Sections
host variables
bulk processing, Bulk Processing Variables
indicator, Indicator Variables
initialization, Input and Output Host Variables
input, Input and Output Host Variables
names, Host Variable Names
output, Input and Output Host Variables
purpose, Using Host Variables
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
uses, Host Variables

I

implicit status checking
defined, Runtime Status Checking and the SQLCA
usage, Approaches to Status Checking
INCLUDE, Location of SQL Commands
include file, The Preprocessor and Program Development
include file, user, The Preprocessor and Program Development
include files
creation, Getting Started with ALLBASE/SQL Pascal Programming
index scan, Introducing the Cursor
indicator variables, Indicator Variables, Indicator Variables
location of, Indicator Variables
null, Indicator Variables
null values, FETCH
truncation, Indicator Variables
input device specification
definition, Defining Input and Output with the LONG Column I/O String
INSERT, The INSERT Command
INSERT command
used with LONG columns, Putting Data into a LONG Column with a 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, Insert Using Host Variables for LONG Column I/O Strings
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
INTEGER data declaration, 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

K

KEEP CURSOR
DECLAREing for UPDATE, KEEP CURSOR and Isolation Levels
file IO, Writing Keep Cursor Applications
terminal IO, Writing Keep Cursor Applications
KEEP CURSOR WITH NOLOCKS command
use with OPEN command , OPEN, Using KEEP CURSOR

L

LANG variable
setting and resetting, Native Language Support
language
current language, Native Language Support
native language support, ALLBASE/SQL Message File
setting and resetting, Native Language Support
length of commands, General Rules for Embedding SQL
linker, Section Validity
separate linked objects, DBEnvironment Access
locking
and cursors, Introducing the Cursor
table level, Introducing the Cursor
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 declaration, Parsing LONG Column Descriptors
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
heap space input and output, Insert Using Host Variables for LONG Column I/O Strings
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
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 a 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 [BULK] INSERT command, Putting Data into a LONG Column with a INSERT Command
used with [BULK] SELECT command, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command
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 UPDATE [WHERE CURRENT] command, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
using file naming conventions, File Naming Conventions
using file versus heap space, File versus Random Heap Space
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

M

maintaining ALLBASE/SQL programs, Running the Program
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
memory problem
status checking, Handling Out of Space Conditions
message catalog, Running the Program, Obtaining ALLBASE/SQL Messages
defaults, ALLBASE/SQL Message File
message catalog number
related to sqlcode, SQLCODE
modified source
creation, Getting Started with ALLBASE/SQL Pascal Programming
inserted constructs, Effect of Preprocessing on Source Code
module
copy, Granting Required Owner Authorization
creation, Effect of Preprocessing on DBEnvironments
definition, Getting Started with ALLBASE/SQL Pascal Programming
installation, Installing the Program Module
name, Effect of Preprocessing on DBEnvironments, Source File
owner, DBEnvironment Access
ownership, Installing the Program Module, Granting Required Owner Authorization
storage, Permanently Stored vs. Temporary Sections
updating, Updating Application Programs
multiple rows qualify
runtime error, The SELECT Command
multiple SQLCODEs, SQLCODE
multiple users of LONG columns, Considering Multiple Users

N

name qualification, Selecting from Multiple Tables
naming conventions for LONG column files, File Naming Conventions
native language
current language, Native Language Support
setting and resetting, Native Language Support
native language support
message catalog, ALLBASE/SQL Message File
SQLMSG, ALLBASE/SQL Message File
non-dynamic commands, Using Dynamic Operations
NULL
as default data value, Using Default Data Values
null indicator suffix
data buffer, Setting up a Buffer for Query Results of Unknown Format
null indicator variable
in dynamic command, Setting up a Buffer for Query Results of Known Format
null predicate, The SELECT Command
NULL result of a dynamic fetch of a LONG column, Using LONG Columns with a Dynamic FETCH Command
null values, Setting up a Buffer for Query Results of Known Format
and groups, The SELECT Command
and unique indexes, The SELECT Command
in a structure declaration, Setting up a Buffer for Query Results of Known Format
in INSERT, The INSERT Command
in UPDATE, The UPDATE Command
indicator variables mandatory, FETCH
properties of, Indicator Variables
runtime errors, Indicator Variables
with FETCH, Indicator Variables, FETCH
with SELECT, Indicator Variables
number of rows processed
data integrity, Comparing Statement Level and Row Level Integrity
NumberOfRows variable
usage, Variables Used in BULK Processing

O

OPEN, Introducing the Cursor, Dynamic Operations
cursor processing, OPEN
OPEN command
use with KEEP CURSOR WITH NOLOCKS command, OPEN, Using KEEP CURSOR
optimization
and section creation, Purpose of Sections
ORDER BY clause, The SELECT Command
output device specification
definition, Defining Input and Output with the LONG Column I/O String
overflow
of numeric values, Numeric Data Conversion
OWNER
authority for, Granting Program User Authorization
OWNER authority
and program development, Granting Required Owner Authorization
granting, Granting Program User Authorization
OWNER authorization, Installing the Program Module
and CONNECT, DBEnvironment Access
granting of, Granting Required Owner Authorization

P

Pascal comments, Pascal Comments
Pascal program
date/time data conversion, Program Example for Date/Time Data
pasex10a, Sample Program Using Dynamic Commands of Unknown Format
pasex10b, Sample Program Using Dynamic Queries of Known Format
pasex2, Embedding SQL Commands
pasex5, Program Illustrating Implicit and Explicit Status Checking
pasex7, Procedure Insert
pasex8, Procedure DisplayUpdate
pasex9, Program Using BULK INSERT
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
predicates, The SELECT Command
PREPARE, Dynamic Operations
non-dynamic queries, Using PREPARE and EXECUTE
preprocessor
access to DBEnvironment, DBEnvironment Access
and authorization, DBEnvironment Access
and DBE sessions, Effect of Preprocessing on Source Code
directives, ALLBASE/SQL Pascal Programs
effect on source code, Effect of Preprocessing on Source Code
errors, Preprocessing Errors
events, Getting Started with ALLBASE/SQL Pascal Programming, The ALLBASE/SQL Pascal Preprocessor
input, Preprocessor Input and Output
invocation, Invoking the Pascal Preprocessor
modes, Preprocessor Modes
modes and invocation, Syntax Checking Mode
modifying output of, Effect of Preprocessing on Source Code
options, Syntax Checking Mode
output, Preprocessor Input and Output
parsing, Source File
syntax checking mode, Syntax
transactions, Effect of Preprocessing on DBEnvironments
UDCs, Using the Preprocessor UDCs
using, Using the ALLBASE/SQL Pascal Preprocessor
preprocessor directive
DECLARE CURSOR, DECLARE CURSOR
procedure part, Embedding SQL Commands
program
compiling and linking, Getting Started with ALLBASE/SQL Pascal Programming
creation steps, Getting Started with ALLBASE/SQL Pascal Programming
development, The Preprocessor and Program Development
execution, Compiling and Linking the Program, Granting Program User Authorization
maintenance, Running the Program
name, Source File
obsolescence, Changing Program-Related Authorization
user authorization, Granting Required Owner Authorization
program structure, Program Structure
punctuation, Punctuation
PurchDB database
date/time conversion example programs, Program Example for Date/Time Data

Q

query
dynamic data structures, Preprocessing of Dynamic Queries
result, The SELECT Command
query result, Introducing the Cursor

R

REAL keyword
floating point data, FLOAT 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 file name, File Referencing
RELEASE, Terminating a DBE Session
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
robust program
defined, Handling Runtime Errors and Warnings
ROLLBACK WORK, Defining Transactions, Transaction Management for Simple Operations
row level integrity
definition, Comparing Statement Level and Row Level Integrity
rows to retrieve
data buffer, Setting up a Buffer for Query Results of Unknown Format
RUN authority, DBEnvironment Access
runtime authorization, Authorization
runtime errors, Handling Runtime Errors and Warnings
bulk processing, Bulk Processing Variables
multiple rows qualify, Runtime Status Checking and the SQLCA, The SELECT Command
null values, Indicator Variables
runtime events, Running the Program
runtime status checking
possible errors, Runtime Status Checking and the SQLCA
status codes, Runtime Status Checking and the SQLCA
runtime warnings, Handling Runtime Errors and Warnings

S

sample database
data consistency, Maintaining Data Consistency
sample program
cursor processing, Procedure DisplayUpdate
simple data manipulation, Program Using Simple DML Operations
status checking, Program Illustrating Implicit and Explicit Status Checking
sample programs
pasex10a, Sample Program Using Dynamic Commands of Unknown Format
pasex10b, Sample Program Using Dynamic Queries of Known Format
pasex2, Embedding SQL Commands
pasex5, Program Illustrating Implicit and Explicit Status Checking
pasex7, Procedure Insert
pasex8, Procedure DisplayUpdate
pasex9, Program Using BULK INSERT
section
and system catalog, Stored Sections
commands requiring, The Stored Section
creation, Effect of Preprocessing on DBEnvironments
definition, Stored Sections
dynamic vs. non-dynamic, Differences between Dynamic and Non-Dynamic Preprocessing
permanently stored, Permanently Stored vs. Temporary Sections
purpose, The Stored Section
temorarily stored, Differences between Dynamic and Non-Dynamic Preprocessing
temporary, Using PREPARE and EXECUTE
types, Stored Sections
validity, Purpose of Sections, Stored Sections
SELECT, The Query
and DECLARE CURSOR, DECLARE CURSOR
and simple data manipulation, The SELECT Command
DECLARE CURSOR, DECLARE CURSOR
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 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, The SELECT Command
SELECT with CURSOR
input host variables only, DECLARE CURSOR
SELECT with cursor
input host variables only, DECLARE CURSOR
self-joins, Selecting from Multiple Tables
semi-colon, Prefix and Suffix
sequential table processing, Overview Of Data Manipulation
overview, Sequential Table Processing
sample programs, Program Using UPDATE WHERE CURRENT
serial scan, Introducing the Cursor
shared memory problem
status checking, Handling Deadlock and Shared Memory Problems
simple data manipulation
commands, Simple Data Manipulation
DELETE, The DELETE Command
INSERT, The INSERT Command
overview, Simple Data Manipulation
sample program, Program Using Simple DML Operations
SELECT, The SELECT Command
techniques, Simple Data Manipulation
transaction management, Transaction Management for Simple Operations
UPDATE, The UPDATE Command
size maximum
LONG columns, General Concepts
SMALLINT data declaration, SMALLINT Data
source file
and preprocessor, Source File
definition of, Preprocessor Input and Output
space allocation for LONG column data, Deciding How Much Space to Allocate and Where
SQL commands
and data manipulation, Overview Of Data Manipulation
delimiting, Program Structure
embedding, Embedding SQL Commands
for data definition, Data Definition
for data manipulation, Data Manipulation
length, Location of SQL Commands
location, Program Structure, Location of SQL Commands
prefix, Prefix and Suffix
suffix, Prefix and Suffix
use of, ALLBASE/SQL Pascal Programs
SQL comments, Pascal Comments
SQLCA
declaring, Declaring the SQLCA
elements of, Using the SQLCA
overview, Declaring the SQLCA
SQLCA.SQLCODE, SQLCODE
sqlca.sqlcode
introduction, Using the SQLCA
SQLCA.SQLCODE vs. SQLCODE, Using the SQLCA
sqlca.sqlerrd[2]
introduction, Using the SQLCA
SQLCA.SQLERRD[3], SQLERRD[3]
SQLCA.SQLWARN[0], SQLCA.SQLWARN[0]
sqlca.sqlwarn[0]
introduction, Using the SQLCA
SQLCA.SQLWARN[1]
usage, SQLCA.SQLWARN[1]
sqlca.sqlwarn[1]
introduction, Using the SQLCA
SQLCA.SQLWARN[2]
usage, SQLCA.SQLWARN[2]
sqlca.sqlwarn[2]
introduction, Using the SQLCA
SQLCA.SQLWARN[3]
usage, SQLCA.SQLWARN[3]
sqlca.sqlwarn[3]
introduction, Using the SQLCA
sqlca.sqlwarn[6]
introduction, Using the SQLCA
usage, SQLCA.SQLWARN[6]
SQLCODE, SQLCODE
a negative number, SQLCODE
and sqlerrd[3], SQLCODE
and sqlwarn[1], SQLCA.SQLWARN[1]
and sqlwarn[2], SQLCA.SQLWARN[2]
and sqlwarn[3], SQLCA.SQLWARN[3]
multiple messages, SQLCODE
multiple SQLCODEs, SQLCODE
of -10002, Determining When More Than One Row Qualfies
of 100, SQLCODE, Detecting End of Scan
related to message catalog number, SQLCODE
sqlwarn[0], SQLCA.SQLWARN[0]
sqlcode
and sqlerrd[3], SQLERRD[3]
deadlock detected, Handling Deadlock and Shared Memory Problems
of -14024, SQLCA.SQLWARN[6], Handling Deadlock and Shared Memory Problems
of -4008, SQLCA.SQLWARN[6]
of 100, BULK FETCH
SQLCODE of -10002, Determining When More Than One Row Qualfies, The SELECT Command
SQLCODE of 100, SQLCODE, Detecting End of Scan
SQLCODE vs. SQLCA.SQLCODE, Using the SQLCA
sqlda
declaring, Declaring Variables for Program Elements
fields, Setting Up the SQLDA
when fields are set, Dynamically Updating and Deleting Data, Setting Up the SQLDA
sqlerrd[2]
error checking, Comparing Statement Level and Row Level Integrity
SQLERRD[3], SQLERRD[3], Determining Number of Rows Processed
sqlerrd[3]
as counter, BULK SELECT
in display counter, BULK SELECT
ussage, SQLCODE
sqlerre[3]
uses for, BULK Operations
SQLEXPLAIN, Running the Program, Obtaining ALLBASE/SQL Messages
introduction, Runtime Status Checking and the SQLCA
multiple messages, Runtime Status Checking and the SQLCA
no message for SQLCODE=100, SQLCODE
simultaneous warning and error, SQLCA.SQLWARN[0]
SQLCODE, SQLCODE
sqlwarn[0], SQLCA.SQLWARN[0]
using, SQLCODE
when messages are available, Approaches to Status Checking
SQLMSG
defaults, ALLBASE/SQL Message File
SQLSECNUM
in preprocessor-generated calls, The Stored Section
SQLWARN[0], SQLCA.SQLWARN[0]
sqlwarn[0]
SQLEXPLAIN, SQLCA.SQLWARN[0]
usage, SQLCA.SQLWARN[0]
SQLWARN[1]
usage, SQLCA.SQLWARN[1]
sqlwarn[1]
string truncation, SQLCA.SQLWARN[1]
usage, SQLCA.SQLWARN[1]
SQLWARN[2]
usage, SQLCA.SQLWARN[2]
SQLWARN[3]
usage, SQLCA.SQLWARN[3]
sqlwarn[6], SQLCA.SQLWARN[6]
transaction rollback, SQLCA.SQLWARN[6]
usage, SQLCA.SQLWARN[6]
START DBE, Starting a DBE Session
authorization, Authorization
StartIndex variable
usage, Variables Used in BULK Processing
statement level integrity
and integrity constraints, Using Unique and Referential Integrity Constraints
status checking
deadlock, Explicitly Invoking Status-Checking Procedure, Handling Deadlock and Shared Memory Problems
elements available, Using the SQLCA
explicit, Explicit Status Checking, Explicit Status Checking Techniques
explicit defined, Runtime Status Checking and the SQLCA
implicit, Implicit Status Checking, Implicit Status Checking Techniques
implicit defined, Runtime Status Checking and the SQLCA
information available, Runtime Status Checking and the SQLCA
introduction to explicit, Approaches to Status Checking
kinds of, Approaches to Status Checking
memory problem, Handling Out of Space Conditions
procedures, Program Illustrating Implicit and Explicit Status Checking, Explicit Status Checking Techniques
purposes of, Purposes of Status Checking
runtime techniques, Handling Runtime Errors and Warnings
shared memory problem, Handling Deadlock and Shared Memory Problems
status codes
runtime status checking, Runtime Status Checking and the SQLCA
storage
LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
syntax checking mode, 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
storing a section, Effect of Preprocessing on DBEnvironments

T

temporary section, Using PREPARE and EXECUTE
terminal IO
KEEP CURSOR, Writing Keep Cursor Applications
TID function, Programming with ALLBASE/SQL Functions, Programming with TID Data Access
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 management, SQLCA.SQLWARN[6]
automatic, Defining Transactions
cursor processing, Transaction Management for Cursor Operations
overview, Defining Transactions
simple data manipulation, Transaction Management for Simple Operations
truncation, String Data Truncation
detecting in strings, Indicator Variables, String Data Truncation
of numeric values, Numeric Data Conversion
of UPDATE or DELETE strings, String Data Truncation
type compatibility, Declaring Variables for Compatibility
decimal, DECIMAL Data
type conversion, Declaring Variables for Compatibility
type precedence
in numeric conversion, Numeric Data Conversion
type precision, Numeric Data Conversion

U

UDC's
PPPAS, Using the Preprocessor UDCs
preprocess, Using the Preprocessor UDCs
UDCs
PPPAS, Using the Preprocessor UDCs
preprocess, compile, link, Using the Preprocessor UDCs
unique index, The SELECT Command
null values, The SELECT Command
WHERE clause, The SELECT Command
UPDATE, The UPDATE Command
UPDATE and FETCH
cursor processing, UPDATE WHERE CURRENT
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 WHERE CURRENT, Introducing the Cursor
FOR UPDATE OF, DECLARE CURSOR, UPDATE WHERE CURRENT
restrictions, UPDATE WHERE CURRENT
syntax, UPDATE WHERE CURRENT
UPDATE WHERE CURRENT command
used with LONG columns, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
updating application programs, Maintaining ALLBASE/SQL Programs
USER
as default data value, Using Default Data Values
using default data values
introduction to, Using Default Data Values
using indicator variables
assigning null values, Simple Data Manipulation

V

validation, Purpose of Sections
varbinary data
using the LONG phrase with, Using the LONG Phrase with Binary Data Types
VARCHAR
dynamic command declaration, Setting up a Buffer for Query Results of Known Format
VARCHAR data declaration, VARCHAR Data
varchar prefix in the data buffer, Setting up a Buffer for Query Results of Unknown Format
views
and DELETE, Selecting Using Views
and SELECT, Selecting Using Views
and UPDATE, Selecting Using Views
restrictions, Selecting Using Views, Introducing the Cursor

W

warning message
and sqlcode, SQLCODE
and sqlwarn[0], SQLCA.SQLWARN[0]
warning messages, Obtaining ALLBASE/SQL Messages
warnings
runtime handling, Handling Runtime Errors and Warnings
WHENEVER, Starting a DBE Session, Implicit Status Checking, Obtaining ALLBASE/SQL Messages
components of, Implicit Status Checking Techniques
duration of command, SQLCODE
for different conditions, Implicit Status Checking Techniques
transaction roll back, Implicit Status Checking Techniques


Transaction Management with TID Access
  		 
Feedback to webmaster