HP SQL/V PASCAL Application Programming Guide

Table of Contents

 HP SQL/V PASCAL Application Programming Guide
   HP SQL/V PASCAL Application Programming Guide : COPYRIGHT NOTICE
   Introduction
   HP SQL PASCAL PROGRAMS
   THE HP SQL PASCAL 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 Pascal Preprocessor
   The Preprocessor and Program Development
   Preprocessor Modes
   Preprocessor Input and Output
   Invoking the Pascal Preprocessor
   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
   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 Versus Nondynamic Commands
   SQL Commands For Dynamic Operations
   How To Handle Dynamic Non-Queries
   How To Handle Dynamic Queries
   How To Handle Dynamic Queries (continued)