HPlogo ALLBASE/SQL COBOL 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

$INCLUDE
compiler directive, Modified Source File
$SQL COPY
COBOL compiler directive, COBOL COPY Statement Support
$SQL NOCOPY
COBOL compiler directive, COBOL COPY Statement Support
[BULK] SELECT command
used with LONG columns, Retrieving LONG Column Data with a SELECT, FETCH, or REFETCH Command

A

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
sample program, Sample Program Using BULK Processing
techniques, Bulk Table Processing

C

C subprogram COBOL calls, C Subprogram Example, How To Preprocess, Compile, Link and Run the Example Programs
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, Sample Program Using PREPARE and EXECUTE
COBEX2, Source File, Embedding SQL Commands
COBEX5, Code the Preprocessor Generates
COBEX7, Sample Program COBEX7 Using Simple DML Commands
COBEX8, Program Using UPDATE WHERE CURRENT
COBEX9, Sample Program Using BULK Processing
COBOL compiler directives
$SQL COPY, COBOL COPY Statement Support
$SQL NOCOPY, COBOL COPY Statement Support
COBOL COPY statement
code expansion, COPY Statement Code Example
compiler directives for, COBOL COPY Statement Support
introduction to, COBOL COPY Statement Support
REPLACING clause, COBOL COPY Statement Support
use of NOLIST reserved word, Using the COPY Statement with ALLBASE/SQL
where used, Using the COPY Statement with ALLBASE/SQL
COBOL SET and IF statement
use of NOMIXED reserved word, Considerations When Using $SET and $IF
COBOL SET and IF statements
where used, Considerations When Using $SET and $IF
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, Effect of Preprocessing on DBEnvironments
defining transactions, Defining Transactions
in transaction management, Transaction Management
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 Linker
separate compilable section, DBEnvironment Access
compiler directive
$INCLUDE, Modified Source File
compiler directives
for COBOL COPY statement, COBOL COPY Statement Support
compiling and linking, Preprocessor Input and Output, COBOL Calling a Pascal Subprogram
C subprogram COBOL calls, How To Preprocess, Compile, Link and Run the Example Programs
concurrency, Transaction Management
CONNECT, Granting Program User Authorization
CONNECT authority, DBEnvironment Access
with START DBE, Starting a DBE Session
constant
as default data value, Using Default Data Values
constraint test matrix for integrity constraints, Using Unique and Referential Integrity Constraints
continuation lines, Continuation Lines
conversion, Declaring Variables for Compatibility
COPY statement in COBOL
code expansion, COPY Statement Code Example
compiler directives for, COBOL COPY Statement Support
introduction to, COBOL COPY Statement Support
REPLACING clause, COBOL COPY Statement Support
use of NOLIST 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 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
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, 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, DBEnvironment Access, Authorization
DBE session
and autostart mode, Starting a DBE Session
terminating, Terminating a DBE Session
DBECon file, 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
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
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
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, Parameters
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 operations, Overview Of Data Manipulation
dynamic commands, Review of Preprocessing Events
overview, Dynamic Operations
queries, using C, Pascal routines, Preprocessing of Dynamic Queries with C or Pascal Routines
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
introduction, Program Structure
prefix, Program Structure
suffix, Program Structure
embedding SQL commands, ALLBASE/SQL COBOL Programs, Embedding SQL Commands
comments, Punctuation
general rules, General Rules for Embedding SQL
punctuation, Punctuation
END DECLARE SECTION, Location of SQL Commands
declaring host variables, Creating Declaration Sections
END-EXEC, Prefix and Suffix
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 COBOL copy file
for error checking, COPY Statement Code Example
example data file
BULK INSERT command with LONG columns, Insert Using Host Variables for LONG Column I/O Strings
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, Sample Program Using PREPARE and EXECUTE
EXECUTE IMMEDIATE, Dynamic Operations
using, Sample Program Using EXECUTE IMMEDIATE
executing programs, Granting Program User Authorization, Running the Program
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

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
Database Environment Configuration, File Referencing
DBECon, File Referencing
file IO
KEEP CURSOR, Writing Keep Cursor Applications
file name
fully qualified, File Referencing
relative, File Referencing
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
fully qualified file name, File Referencing

H

heap space input and output, Insert Using Host Variables for LONG Column I/O Strings
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

I

IF statement in COBOL
use of NOMIXED reserved word, Considerations When Using $SET and $IF
implicit status checking
defined, Runtime Status Checking and the SQLCA
introduction, Implicit Status Checking
usage, Approaches to Status Checking
INCLUDE, Location of SQL Commands
include files
contents of, Modified Source File
creation, Getting Started with ALLBASE/SQL Programming in COBOL
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
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

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

language
current language, Native Language Support
native language support, Native Language Support, ALLBASE/SQL Message File
linker, The Compiler and the Linker
separate linked objects, DBEnvironment Access
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
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, 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, Running the Program, Preprocessor Input and Output
and SQLEXPLAIN, Obtaining ALLBASE/SQL Messages
defaults, ALLBASE/SQL Message File
introduction, Running the Program
message catalog number
related to SQLCODE, SQLCODE
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, Parameters
owner, DBEnvironment Access, Stored Sections, Parameters
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
native language
current language, Native Language Support
defaults, Native Language Support
native language support, Native Language Support
message catalog, ALLBASE/SQL Message File
SQLMSG, ALLBASE/SQL Message File
NATIVE-3000
defined, Native Language Support
NOLIST reserved word
used with COBOL COPY files, Using the COPY Statement with ALLBASE/SQL
NOMIXED reserved word
used with COBOL SET and IF statements , Considerations When Using $SET and $IF
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, Granting Required Owner Authorization
OWNER authority, DBEnvironment Access

P

padding of DECIMAL values, Odd-Byte Columns
Pascal subprogram COBOL calls, Pascal Subprogram Example, COBOL Calling a Pascal Subprogram
passing SQLCA, Using the SQLCA
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, Sample Program Using PREPARE and EXECUTE
preprocessing
directives, ALLBASE/SQL COBOL Programs
preprocessor
access to DBEnvironment, DBEnvironment Access
and authorization, DBEnvironment Access
and DBE sessions, Effect of Preprocessing on DBEnvironments
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
job mode, Running the Preprocessor in Job Mode
logging, Description
modes, Preprocessor Modes
modified source file, Preprocessor Input and Output
modifying output of, Effect of Preprocessing on Source Code
output, Preprocessor Input and Output, Output File Attributes
transactions, Effect of Preprocessing on DBEnvironments
UDC's, Example
vs. COBOL preprocessor, The ALLBASE/SQL COBOL Preprocessor
preprocessor directive
DECLARE CURSOR, DECLARE CURSOR
PROCEDURE DIVISION, Embedding SQL Commands
program
compiling and linking, Getting Started with ALLBASE/SQL Programming in COBOL, The Compiler and the Linker
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, The Compiler and the Linker, ALLBASE/SQL Program Execution, Granting Program User Authorization, Running the Program
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 file name, File Referencing
RELEASE
introduction, Terminating a DBE Session
without ending transaction, SQLWARN0
REPLACING clause
used with COBOL COPY Statement, COBOL 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, DBEnvironment Access
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 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
COBEX10A, Sample Program Using EXECUTE IMMEDIATE
COBEX10B, Sample Program Using PREPARE and EXECUTE
COBEX2, Source File, Embedding SQL Commands
COBEX5, Code the Preprocessor Generates
COBEX7, Sample Program COBEX7 Using Simple DML Commands
COBEX8, Program Using UPDATE WHERE CURRENT
COBEX9, Sample Program Using BULK Processing
simple data manipulation, Sample Program COBEX7 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
segmenter, The Compiler and the Linker
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
SET and statements in COBOL
where used, Considerations When Using $SET and $IF
shared memory problem
status checking, Handling Deadlock and Shared Memory Problems
simple data manipulation
commands, Simple Data Manipulation
DELETE, DELETE
INSERT, INSERT
multiple rows not allowed, SELECT
overview, Simple Data Manipulation
sample program, Sample Program COBEX7 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
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
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
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
SQLCONST, Modified Source File
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
SQLIN, Source File
SQLMOD, Installable Module File
SQLMSG
defaults, ALLBASE/SQL Message File
SQLOUT, Modified Source File
SQLVAR, Modified Source File
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, Starting a DBE Session
StartIndex variable
usage, Variables Used in BULK Processing
statement level integrity
and integrity constraints, Using Unique and Referential Integrity Constraints
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
Pascal subprogram COBOL calls, Pascal Subprogram Example
SQLCA declaration, Using the SQLCA
suffix, Prefix and Suffix
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

T

temporary files, Output File Attributes
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

UDC's
PCOB, Example
PPCOB, Using the Preprocessor UDC's
preprocess, Example
preprocess, compile, link, Using the Preprocessor UDC's
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
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