HP SQL/V COBOL Application Programming Guide

HP SQL/V COBOL Application Programming Guide
Table of Contents
HP SQL/V COBOL Application Programming Guide
HP SQL/V COBOL Application Programming Guide : COPYRIGHT NOTICE
Introduction
HP SQL COBOL PROGRAMS
THE HP SQL COBOL PREPROCESSOR
THE STORED SECTION
THE COMPILER AND THE SEGMENTER
THE EXECUTABLE PROGRAM
MAINTAINING HP SQL PROGRAMS
THE REST OF THIS MANUAL
Using the HP SQL COBOL Preprocessor
THE PREPROCESSOR AND PROGRAM DEVELOPMENT
PREPROCESSOR MODES
PREPROCESSOR INPUT AND OUTPUT
INVOKING THE COBOL PREPROCESSOR
Syntax Checking Mode
Full Preprocessing Mode
Using the Preprocessor UDCs
Running Preprocessor in Job Mode
PREPROCESSING ERRORS
Embedding SQL Commands
GENERAL RULES FOR EMBEDDING SQL
DECLARING THE SQLCA
DECLARING HOST VARIABLES
STARTING A DBE SESSION
DEFINING TRANSACTIONS
IMPLICIT STATUS CHECKING
TERMINATING A DBE SESSION
DEFINING AND MANIPULATING DATA
EXPLICIT STATUS CHECKING
OBTAINING HP SQL MESSAGES
Host Variables
USING HOST VARIABLES
DECLARING HOST VARIABLES
Run-Time Status Checking
THE IMPORTANCE OF STATUS CHECKING
THE SQLCA
APPROACHES TO STATUS CHECKING
APPROACHES TO STATUS CHECKING (continued)
Overview of Data Manipulation
THE QUERY
SIMPLE DATA MANIPULATION
INTRODUCING THE CURSOR
SEQUENTIAL TABLE PROCESSING
BULK TABLE PROCESSING
DYNAMIC OPERATIONS
Simple Data Manipulation
Simple Data Manipulation Commands
Transaction Management
Program Using SELECT, UPDATE, DELETE, and INSERT
Sequential Table Processing
Sequential Table Processing Commands
Transaction Management
PROGRAM USING UPDATE WHERE CURRENT
BULK Table Processing
BULK TABLE PROCESSING COMMANDS
TRANSACTION MANAGEMENT
PROGRAM USING BULK INSERT
Dynamic Operations
DYNAMIC PREPROCESSING EVENTS
REASONS FOR DYNAMIC PREPROCESSING
HANDLING DYNAMIC OPERATIONS