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

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

Symbols

$INCLUDE
compiler directive, Modified Source File
$SQL COPY
COBOL compiler directive, COPY Statement Support
$SQL NOCOPY
COBOL compiler directive, COPY Statement Support
300/400 differences
debugging, Setting Signal Handling for Debugging
[BULK] SELECT command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command

A

absolute pathname
use in file referencing, File Referencing
access
optimization, Purpose of Sections
validation, Purpose of Sections
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, SELECT
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 development, The Preprocessor and Application Development
arrays, Bulk Processing Arrays, BULK Table Processing
BULK SELECT, Bulk Processing Variables
declarations of, Declaring Variables for Program Elements
atomic operation
defined, Maintaining Data Consistency
authorization, Authorization
and program maintenance, Updating Application Programs
changing, Changing Program-Related Authorization
dynamic preprocessing, Differences between Dynamic and Non-Dynamic Preprocessing
granting, Granting Required Owner Authorization
automatic rollback, SQLWARN6
autostart mode, Starting a DBE Session

B

BEGIN DECLARE SECTION, Location of SQL Commands
declaring host variables, Creating Declaration Sections
BEGIN WORK
defining transactions, Defining Transactions
in transaction management, Transaction Management
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
basic uses of, BULK FETCH
BULK FETCH command
used in example program, Example Program to Convert from CHAR to Default Data Type
BULK INSERT, BULK Table Processing
basic uses of, BULK INSERT
BULK INSERT command
used in example program, Example Program to Convert from CHAR to Default Data Type
used with LONG columns, Putting Data into a LONG Column with a INSERT Command
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
example with LONG columns, Example
with ADD_MONTHS function, Example ADD_MONTHS Function
BULK table processing, Overview Of Data Manipulation
BULK FETCH, BULK FETCH
BULK INSERT, BULK INSERT
BULK SELECT, BULK SELECT
commands, SQL Bulk Commands
overview, BULK Table Processing
techniques, Bulk Table Processing

C

C subprogram COBOL calls, C Subprogram Example, How To Preprocess, Compile, Link, and Run the Example Programs
call numbers for COBOL, The Compiler and the Runtime System
CHAR data, Declaring Variables for Data Types
CLOSE, Introducing The Cursor
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
COBEX10A, Sample Program Using EXECUTE IMMEDIATE
COBEX10B, Using PREPARE and EXECUTE
COBEX2, Source File, Embedding SQL Commands
COBEX5, Code the Preprocessor Generates
COBEX8, Program Using UPDATE WHERE CURRENT
COBEX9, Sample Program Using BULK Processing
COBOL compiler directives
$SQL COPY, COPY Statement Support
$SQL NOCOPY, COPY Statement Support
COBOL COPY statement
code expansion, Using the COPY Statement with ALLBASE/SQL
compiler directives for, COPY Statement Support
file naming rules, Using the COPY Statement with ALLBASE/SQL
introduction to, COPY Statement Support
REPLACING clause, COPY Statement Support
use of SUPPRESS reserved word, Using the COPY Statement with ALLBASE/SQL
where used, Using the COPY Statement with ALLBASE/SQL
COBOL subprograms, The Preprocessor and Application Development
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, Floating Point Data Compatibility
comments, ALLBASE/SQL, ALLBASE/SQL Comments
comments, COBOL, COBOL Comments
COMMIT WORK
defining transactions, Defining Transactions
in transaction management, Transaction Management
preprocessor-generated, 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
compiler, The Compiler and the Runtime System
separate compilable section, DBEnvironment Access
compiler directive
$INCLUDE, Modified Source File
compiler directives
for COBOL COPY statement, COPY Statement Support
compiling and linking
C subprogram COBOL calls, How To Preprocess, Compile, Link, and Run the Example Programs
compiling and running, The Compiler and the Runtime System
dynamic linking, The Compiler and the Runtime System
static linking, The Compiler and the Runtime System
concurrency, Transaction Management
CONNECT, Authorization, Granting Program User Authorization
CONNECT authority, Authorization
with START DBE, Starting a DBE Session
constant
as default data value, Using Default Data Values
constant copy file, Preprocessor Input and Output
constraint test matrix for integrity constraints, Using Unique and Referential Integrity Constraints
continuation lines, Continuation Lines
conversion, Declaring Variables for Compatibility
copy files, Preprocessor Input and Output
contents of, Preprocessor-Generated Copy Files
creation, Getting Started with ALLBASE/SQL Programming in COBOL
summary, Effect of Preprocessing on Source Code
COPY statement in COBOL
code expansion, Using the COPY Statement with ALLBASE/SQL
compiler directives for, COPY Statement Support
file naming rules, Using the COPY Statement with ALLBASE/SQL
introduction to, COPY Statement Support
REPLACING clause, COPY Statement Support
use of SUPPRESS reserved word, Using the COPY Statement with ALLBASE/SQL
where used, Using the COPY Statement with ALLBASE/SQL
CREATE TABLE command
syntax for LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
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
closing, Introducing The Cursor
deleting with, Introducing The Cursor
effect of commands on, Introducing The Cursor
introduction to, Data Manipulation
opening, Introducing The Cursor
positioning, Introducing The Cursor
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 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 description entries, Declaring Host Variables
DATA DIVISION, Embedding SQL Commands
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 type
compatibility, Declaring Variables for Compatibility
data type conversion, Declaring Variables for Compatibility
data types, Declaring Variables for Data Types
binary, BINARY Data
compatibility, Declaring Variables for Compatibility
equivalency, Declaring Variables for Compatibility
floating point, FLOAT Data
used with LONG columns, General Concepts
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 data conversion
example program, Example Program to Convert from CHAR to Default Data Type
example programs, Example Program Converting a Column from CHAR to DATE Data Type
date/time functions, Programming with ALLBASE/SQL Functions
coding considerations, Coding Considerations
data compatibility, Defining and Using Host Variables with Date/Time Functions
example program, Example Program Using Date/Time Functions
example programs, Program Examples for Date/Time Data
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, Authorization, Authorization
DBE session
and autostart mode, Starting a DBE Session
terminating, Terminating a DBE Session
DBECon file
creating, File Referencing
DBEnvironment
access, DBEnvironment Access, The Preprocessor and Application Development
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
debugging, Setting Signal Handling for Debugging
setting flags, Setting Signal Handling for Debugging
signals, Setting Signal Handling for Debugging
DECIMAL data, SMALLINT Data
declaration of data
FLOAT, FLOAT Data
DECLARE CURSOR, Introducing The Cursor
FOR UPDATE OF, DECLARE CURSOR
preprocessor directive, DECLARE CURSOR
SELECT, DECLARE CURSOR
specify location of stored section, DECLARE CURSOR
syntax, DECLARE CURSOR
declare section, Declaring Host Variables
defined, Creating Declaration Sections
DECLAREing for UPDATE
KEEP CURSOR, KEEP CURSOR and Isolation Levels
declaring
host variables, Declaring Host Variables, Declaring Host Variables
indicator variables, Bulk Processing Arrays
SQLCA, Declaring the SQLCA
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
and simple data manipulation, DELETE
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
delimiting SQL commands, Program Structure
designing an application using statement level integrity, Designing an Application Using Statement Level Integrity Checks
directives, ALLBASE/SQL COBOL 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, Obsoleting Programs
updating programs, Updating Application Programs
dynamic command, Using Dynamic Operations
passing to ALLBASE/SQL, Passing Dynamic Commands to ALLBASE/SQL
dynamic commands, Running the Program
and authorization, Authorization
dynamic FETCH command
used with LONG columns, Using LONG Columns with a Dynamic FETCH Command
dynamic linking, The Compiler and the Runtime System
dynamic operations, Overview Of Data Manipulation
dynamic commands, Review of Preprocessing Events
overview, Dynamic Operations
queries using C routine, Preprocessing Dynamic Queries with a C Routine
techniques, Using Dynamic Operations
dynamic preprocessing, Review of Preprocessing Events
authorization for, Differences between Dynamic and Non-Dynamic Preprocessing

E

embedding commands
continuation lines, Continuation Lines
embedding SQL commands, ALLBASE/SQL COBOL Programs, Embedding SQL Commands
comments, Punctuation
general rules, General Rules for Embedding SQL
introduction, Program Structure
prefix, Program Structure
punctuation, Punctuation
suffix, Program Structure
END DECLARE SECTION, Location of SQL Commands
declaring host variables, Creating Declaration Sections
END-EXEC, Prefix and Suffix
environment variables
HPSQLfast_ipc, Setting the HPSQLfast_ipc Environment Variable
error checking
changes for this release, Comparing Statement Level and Row Level Integrity
example COBOL copy file, COPY Statement Code Example
using sqlerrd[2], 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, Obtaining ALLBASE/SQL Messages
example
BULK SELECT command with ADD_MONTHS function, Example ADD_MONTHS Function
BULK SELECT command with LONG columns, 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 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 in COBOL
copy file for error checking, COPY Statement Code Example
example program
date/time data conversion, Example Program to Convert from CHAR to Default Data Type
using date/time functions, Example Program Using Date/Time Functions
example programs
date/time data conversion, Example Program Converting a Column from CHAR to DATE Data Type
date/time functions, Example Program Using Date/Time Functions
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, Dynamic Operations
non-dynamic queries, Using PREPARE and EXECUTE
using, Using PREPARE and EXECUTE
EXECUTE IMMEDIATE, Dynamic Operations
using, Sample Program Using EXECUTE IMMEDIATE
executing programs, Granting Program User Authorization
execution, The Compiler and the Runtime System
explicit status checking
defined, Runtime Status Checking and the SQLCA
introduction, Explicit Status Checking, Approaches to Status Checking
uses of, Explicit Status Checking Techniques
expression, The SELECT Command

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
FETCH, Introducing The Cursor
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
DBECon, File Referencing
file IO
KEEP CURSOR, Writing Keep Cursor Applications
file naming
for COBOL COPY files, Using the COPY Statement with ALLBASE/SQL
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, Floating Point Data Compatibility
compatibility, Floating Point Data Compatibility
REAL keyword, FLOAT Data
FOR UPDATE OF
UPDATE WHERE CURRENT, DECLARE CURSOR, UPDATE WHERE CURRENT
FROM clause, The SELECT Command

H

host variables
and data manipulation, Data Manipulation
and modified source code, Effect of Preprocessing on Source Code
bulk processing, Bulk Processing Variables
declaring, Declaring Host Variables, Declaring Host Variables
declaring for savepoints, Savepoint Numbers
for dynamic commands, Bulk Processing Arrays
for messages, Bulk Processing Arrays
for savepoint numbers, Bulk Processing Arrays
in arrays, Bulk Processing Arrays
in data types, Declaring Variables for Data Types
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
overview, Declaring 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
hpsqlcat, Preprocessor Input and Output
HPSQLfast_ipc environment variable
to set interprocess communication, Setting the HPSQLfast_ipc Environment Variable

I

implicit status checking
defined, Runtime Status Checking and the SQLCA
introduction, Implicit Status Checking
usage, Approaches to Status Checking
INCLUDE, Location of SQL Commands
index scan, Introducing The Cursor
indicator variables, Indicator Variables
declaring, Bulk Processing Arrays
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
and null values in unnamed columns, INSERT
and simple data manipulation, INSERT
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, Installing the Program Module, Updating Application Programs
installable module file, Preprocessor Input and Output, Installable Module File
installed module, Preprocessor Input and Output
INTEGER data, SMALLINT 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

K

KEEP CURSOR
DECLAREing for UPDATE, KEEP CURSOR and Isolation Levels
example code, Examples
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

libcl.a, The Compiler and the Runtime System
libportnls.a, The Compiler and the Runtime System
libsql.a, The Compiler and the Runtime System
linker
separate linked objects, DBEnvironment Access
linking, dynamic, The Compiler and the Runtime System
linking, static, The Compiler and the Runtime System
locking
and cursors, Introducing The Cursor
table level, Introducing The Cursor
logging, Description
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, 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 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 shared memory, File versus Shared Memory
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, 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
program using date/time functions, Example Program Using Date/Time Functions
message catalog
and SQLEXPLAIN, Obtaining ALLBASE/SQL Messages
introduction, Running the Program
message catalog number
related to SQLCODE, SQLCODE
message file, Preprocessor Input and Output
messages from SQLEXPLAIN
when produced, SQLCODE
modified source
creation, Getting Started with ALLBASE/SQL Programming in COBOL
inserted statements, Effect of Preprocessing on Source Code
sample, Code the Preprocessor Generates
modified source file, Preprocessor Input and Output, Modified Source File
module
creation, Effect of Preprocessing on DBEnvironments
DBEfileset, Stored Sections
definition, Getting Started with ALLBASE/SQL Programming in COBOL
installation, Installing the Program Module
name, Effect of Preprocessing on DBEnvironments, Stored Sections
owner, Authorization, Stored Sections
ownership, Granting Required Owner Authorization
storage, Permanently Stored vs. Temporary Sections
updating, Updating Application Programs
multiple rows
not allowed in simple data manipulation, SELECT
multiple rows qualify
runtime error, SELECT
multiple users of LONG columns, Considering Multiple Users
multiple warnings
SQLEXPLAIN, SQLWARN0

N

name qualification, Selecting from Multiple Tables
naming conventions for LONG column files, File Naming Conventions
non-COBOL subprograms, The Compiler and the Runtime System
call number, The Compiler and the Runtime System
libcl.a, The Compiler and the Runtime System
libportnls.a, The Compiler and the Runtime System
libsql.a, The Compiler and the Runtime System
sqlcall.c, The Compiler and the Runtime System
sqlcall.h, The Compiler and the Runtime System
non-dynamic commands, Using Dynamic Operations
NULL
as default data value, Using Default Data Values
null predicate, The SELECT Command
NULL result of a dynamic fetch of a LONG column, Using LONG Columns with a Dynamic FETCH Command
null value
in key column of unique index, SELECT
null values
and unnamed columns in an INSERT, INSERT
in groups, The SELECT Command
in UPDATE, UPDATE
indicator variables mandatory, FETCH
properties of, Indicator Variables
runtime errors, Indicator Variables
using indicator variables with, UPDATE
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

odd-byte columns, Odd-Byte Columns
OPEN, Introducing The Cursor
cursor processing, OPEN
OPEN command
use with KEEP CURSOR WITH NOLOCKS command, OPEN, Using KEEP CURSOR
optimization, Purpose of Sections
ORDER BY clause, The SELECT Command
output device specification
definition, Defining Input and Output with the LONG Column I/O String
output file
attributes, Output File Attributes
preprocessor, Modified Source File
overflow, Declaring Variables for Compatibility
OWNER
authority, Authorization, Granting Required Owner Authorization

P

padding of DECIMAL values, Odd-Byte Columns
passing SQLCA, Using the SQLCA
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
precision, SMALLINT Data
predicates, The SELECT Command
prefix, Prefix and Suffix
PREPARE
non-dynamic queries, Using PREPARE and EXECUTE
using, Using PREPARE and EXECUTE
preprocessing
directives, ALLBASE/SQL COBOL Programs
preprocessor
access to DBEnvironment, DBEnvironment Access
and authorization, Authorization
and DBE sessions, Effect of Preprocessing on DBEnvironments
copy files, Preprocessor Input and Output
effect on source code, Effect of Preprocessing on Source Code
events, Getting Started with ALLBASE/SQL Programming in COBOL, The ALLBASE/SQL COBOL Preprocessor
input, Preprocessor Input and Output
invoking, Invoking the COBOL Preprocessor
logging, Description
messages, ALLBASE/SQL Message File
modes, Preprocessor Modes
modified source file, Preprocessor Input and Output
modifying output of, Effect of Preprocessing on Source Code, Modified Source File
output, Preprocessor Input and Output, Output File Attributes
source file, Preprocessor Input and Output
preprocessor directive
DECLARE CURSOR, DECLARE CURSOR
PROCEDURE DIVISION, Embedding SQL Commands
program
compiling, Getting Started with ALLBASE/SQL Programming in COBOL
creation steps, Getting Started with ALLBASE/SQL Programming in COBOL
date/time data conversion, Example Program to Convert from CHAR to Default Data Type
execution, ALLBASE/SQL Program Execution, Granting Program User Authorization
maintenance, Maintaining ALLBASE/SQL Programs
obsolescence, Obsoleting Programs
starting DBE session, DBEnvironment Access
user authorization, Granting Program User Authorization
program structure, Program Structure
programs
date/time functions, Example Program Using Date/Time Functions
punctuation, Punctuation
PurchDB database
date/time conversion example programs, Example Program Converting a Column from CHAR to DATE Data Type

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 pathname
use in file referencing, File Referencing
RELEASE
introduction, Terminating a DBE Session
without ending transaction, SQLWARN0
REPLACING clause
used with COBOL COPY Statement, COPY Statement Support
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, Defining Transactions
to ensure data consistency, Transaction Management
row level integrity
definition, Comparing Statement Level and Row Level Integrity
RUN authority, Authorization
with START DBE, Starting a DBE Session
run-time
defining SQL commands at, Defining SQL Commands at Run Time
running the preprocessor, Invoking the COBOL Preprocessor
runtime
authorization, Authorization
events, Running the Program
runtime errors, Handling Runtime Errors and Warnings
bulk processing, Bulk Processing Variables
multiple rows qualify, SELECT
null values, Indicator Variables
runtime library routines, The Compiler and the Runtime System
runtime status checking
possible errors, Runtime Status Checking and the SQLCA
status codes, Runtime Status Checking and the SQLCA
Runtime System, The Compiler and the Runtime System
runtime warnings, Handling Runtime Errors and Warnings

S

sample database
data consistency, Maintaining Data Consistency
sample program
COBEX10A, Sample Program Using EXECUTE IMMEDIATE
COBEX10B, Using PREPARE and EXECUTE
COBEX2, Source File, Embedding SQL Commands
COBEX5, Code the Preprocessor Generates
COBEX8, Program Using UPDATE WHERE CURRENT
COBEX9, Sample Program Using BULK Processing
simple data manipulation, Program Using Simple DML Commands
scale, SMALLINT Data
section
commands requiring, The Stored Section
creation, Effect of Preprocessing on DBEnvironments
dynamic vs. non-dynamic, Differences between Dynamic and Non-Dynamic Preprocessing
permanently stored, Permanently Stored vs. Temporary Sections
purpose, Purpose of Sections
temorarily stored, Differences between Dynamic and Non-Dynamic Preprocessing
temporary, Using PREPARE and EXECUTE
validity, Section Validity
SELECT, The Query
and simple data manipulation, SELECT
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 BULK 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
self-joins, Selecting from Multiple Tables
sequential table processing, Overview Of Data Manipulation
overview, Sequential Table Processing
serial scan, Introducing The Cursor
shared memory
use of, Use of Shared Memory
shared memory input and output, Insert Using Host Variables for LONG Column I/O Strings
shared memory problem
status checking, Handling Deadlock and Shared Memory Problems
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
commands, Simple Data Manipulation
DELETE, DELETE
INSERT, INSERT
multiple rows not allowed, SELECT
overview, Simple Data Manipulation
sample program, Program Using Simple DML Commands
SELECT, SELECT
techniques, Simple Data Manipulation
transaction management, Transaction Management
UPDATE, UPDATE
size maximum
LONG columns, General Concepts
slack byte
odd byte columns, Odd-Byte Columns
SMALLINT data, SMALLINT Data
source file, Source File
preprocessor, Preprocessor Input and Output
SourceFileName.sqlc, Preprocessor-Generated Copy Files
SourceFileName.sqlv, Preprocessor-Generated Copy Files
space allocation for LONG column data, Deciding How Much Space to Allocate and Where
SQL commands
and data manipulation, Overview Of Data Manipulation
defining at run time, Defining SQL Commands at Run Time
delimiting, Program Structure
embedding, Embedding SQL Commands
for data definition, Data Definition
for data manipulation, Data Manipulation
length, Location of SQL Commands
length of, General Rules for Embedding SQL
location, Program Structure, Location of SQL Commands
prefix, Prefix and Suffix
suffix, Prefix and Suffix
use of, ALLBASE/SQL COBOL Programs
SQL message file, ALLBASE/SQL Message File
SQLCA
declaring, Declaring the SQLCA
elements of, Using the SQLCA
in subprograms, Using the SQLCA
overview, Declaring the SQLCA
purpose, Using the SQLCA
sqlca
declaring, Declaring Variables for Program Elements
sqlcall.c, The Compiler and the Runtime System
sqlcall.h, The Compiler and the Runtime System
SQLCODE, Detecting End of Scan, Determining When More Than One Row Qualifies
a negative number, SQLCODE
and SQLWARN6, SQLCODE
deadlock detected, Handling Deadlock and Shared Memory Problems
introduction, Using the SQLCA
multiple messages, SQLCODE
multiple SQLCODEs, SQLCODE
of -14024, SQLWARN6, Handling Deadlock and Shared Memory Problems
of 0, SQLCODE
of 100, SQLCODE
related to message catalog number, SQLCODE
SQLEXPLAIN, SQLCODE
usage, SQLCODE
SQLCODE of -10002, SELECT
SQLCODE of -4008, SQLWARN6
SQLERRD(3)
introduction, Using the SQLCA
usage, SQLERRD(3)
uses for, Determining Number of Rows Processed
sqlerrd[2]
error checking, Comparing Statement Level and Row Level Integrity
SQLEXPLAIN
introduction, Running the Program, Runtime Status Checking and the SQLCA
multiple messages, Runtime Status Checking and the SQLCA
multiple warnings, SQLWARN0
no message for SQLCODE=100, SQLCODE
overview, Obtaining ALLBASE/SQL Messages
simultaneous warning and error, SQLWARN0
SQLCODE, SQLCODE
SQLWARN0, SQLWARN0
using, SQLCODE
when messages are available, Approaches to Status Checking
sqlmsg, Preprocessor Input and Output
SQLWARN0
introduction, Using the SQLCA
SQLEXPLAIN, SQLWARN0
usage, SQLWARN0
SQLWARN1
introduction, Using the SQLCA
string data truncation, String Data Truncation
usage, SQLWARN1
SQLWARN2
introduction, Using the SQLCA
usage, SQLWARN2
SQLWARN6, SQLWARN6
introduction, Using the SQLCA
transaction rollback, SQLWARN6
usage, SQLWARN6
START DBE, Authorization, Starting a DBE Session
StartIndex variable
usage, Variables Used in BULK Processing
statement level integrity
and integrity constraints, Using Unique and Referential Integrity Constraints
static linking, The Compiler and the Runtime System
status checking
deadlock, Handling Deadlock and Shared Memory Problems
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
procedures, Implicitly Invoking Status-Checking Procedures, 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
stored sections, Stored Sections
string data truncation
SQLWARN1, String Data Truncation
subprograms
C subprogram COBOL calls, C Subprogram Example
COBOL, The Preprocessor and Application Development
non-COBOL, The Compiler and the Runtime System
SQLCA declaration, Using the SQLCA
suffix, Prefix and Suffix
SUPPRESS reserved word
used with COBOL COPY files, Using the COPY Statement with ALLBASE/SQL
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, Effect of Preprocessing on DBEnvironments
system copy file, Preprocessor Input and Output

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, SQLWARN6
automatic, Defining Transactions
cursor processing, Transaction Management for Cursor Operations
overview, Defining Transactions
simple data manipulation, Transaction Management
truncation, Declaring Variables for Compatibility
detecting in strings, Indicator Variables
type
compatibility, Declaring Variables for Compatibility

U

unique index, SELECT
UPDATE
and simple data manipulation, UPDATE
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, Updating Application Programs
USER
as default data value, Using Default Data Values
using default data values
introduction to, Using Default Data Values
using host variables, Declaring Host Variables Passed Between Subprograms
using indicator variables
assigning null values, UPDATE

V

validation, Purpose of Sections
varbinary data
using the LONG phrase with, Using the LONG Phrase with Binary Data Types
VARCHAR data, VARCHAR Data
variable copy file, Preprocessor Input and Output
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, SQLWARN0
and SQLWARN0, SQLWARN0
and SQLWARN1, SQLWARN0
SQLWARN2, SQLWARN1
warning messages, ALLBASE/SQL Message File, Obtaining ALLBASE/SQL Messages
warnings
runtime handling, Handling Runtime Errors and Warnings
WHENEVER
components of, Implicit Status Checking Techniques
duration of command, SQLCODE
for different conditions, Implicit Status Checking Techniques
introduction to, Implicit Status Checking, Obtaining ALLBASE/SQL Messages
transaction roll back, Implicit Status Checking Techniques
when starting DBE session, Starting a DBE Session


Transaction Management with TID Access
  		 
Feedback to webmaster