HPlogo

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

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

HP Part Number: 36216-90099

Edition: First Edition

Published: Printed in U.S.A. 1994


Table of Contents

ALLBASE/SQL Manuals
Preface
1 Using the Preprocessor
Full Preprocessing Mode
Full Preprocessing Mode Syntax Specification
Parameters
Description
Authorization
Example of Full Preprocessing of a C Application
DBEnvironment Access in Full Preprocessing Mode
Static Conversion Mode
Static Conversion Mode Syntax Specification
Parameters
Description
Authorization
Example of Static Conversion Processing of a C Application
Example of Static Conversion Processing of a Pascal Application
Syntax Checking Mode
Syntax Checking Mode Syntax Specification
Parameters
Description
Authorization
Example of Syntax Checking of a C Application
POSIX Preprocessor Invocation
POSIX Full Preprocessing Mode for C Applications
Parameters
POSIX Static Conversion Mode for C Applications
Parameters
POSIX Syntax Checking Mode for C Applications
Parameters
2 Flagging Non-Standard SQL with the FIPS Flagger
Coding Tips
Setting the ANSI Compiler Directive
Identifying Non-Standard Features
Understanding Implicit Updatability
Declaring the SQLCA
Secondary References to Non-Standard SQL
Host Variable Data Type Declarations
Host Variable Name Length Standards
3 Comparing Static and Dynamic SQL
Comparing Static and Dynamic Applications
Coding an Application that can be Either Static or Dynamic
Converting a Static Application to a Dynamic Application
Enhancing Performance
4 Using Parameter Substitution in Dynamic Statements
Understanding Dynamic Parameters
Examples in C of Preparing a Statement with Dynamic Parameters
Examples in COBOL of Preparing a Statement with Dynamic Parameters
Examples in FORTRAN of Preparing a Statement with Dynamic Parameters
Examples in Pascal of Preparing a Statement with Dynamic Parameters
Where to Use Dynamic Parameters
Restrictions
Programming with Dynamic Parameters
Using Host Variables to Process Dynamic Parameters
Using Data Structures and a Data Buffer to Process Dynamic Parameters
Using a BULK INSERT Statement with Dynamic Parameters
Using Default Data Types with Dynamic Parameters
How ALLBASE/SQL Derives a Default Data Type
Dynamic Parameter Formats
Conversion of Actual Data Types to Default Data Types
Data Overflow and Truncation
5 Using Procedures in Application Programs
Using Cursors with Procedures
Procedures with Multiple Row Result Sets of Different Formats
Procedures with no Multiple Row Result Sets
Single Format Multiple Row Result Sets
Using Host Variables to Pass Parameter Values
Using Dynamic Procedure Parameters
Returning a Return Status Code
Testing SQLCODE and SQLWARN0 on Return from a Procedure
Checking for All Errors and Warnings
Returning Output Values
Additional Error and Message Handling
Messages from Failure of the EXECUTE PROCEDURE Statement
Messages from the Last SQL Statement Executed by the Procedure
Messages from Errors Caused by the RAISE ERROR Statement
Messages from the PRINT Statement
Comparing a Procedure and an Embedded SQL Application
Why Use a Procedure?
6 Using Data Integrity Features
Setting the Error Checking Level
Using Table Check Constraints
Defining and Dropping Table Constraints
Adding a Column to the Recreation Database
Adding a Constraint to the Recreation Database
Dropping a Constraint from the Recreation Database
Defining and Dropping View Constraints
Deferring Constraint Error Checking
Locating Constraint Errors
Template for Single Column Unique Constraint Errors
Template for Multiple Column Unique Constraint Errors
Template for Single Column Referential Constraint Errors
Template for Multiple Column Referential Constraint Errors
Coding with Deferred Constraint Error Checking
7 Transaction Management with Multiple DBEnvironment Connections
Preprocessing and Installing Applications
Understanding Timeouts
Using Timeouts to Prevent Undetectable Deadlocks and Infinite Waits
Undetectable Deadlock Prevention
Infinite Wait Prevention
Using Timeouts to Tune Performance
Example Using Single-transaction Mode with Timeouts
8 COBOL Preprocessor Enhancements
Record Descriptions For Non-Bulk Queries
Host Variables Initialized With The VALUE Clause
9 Programming with Indicator Variables in Expressions
10 Analyzing Queries with GENPLAN
11 Using the VALIDATE Statement
12 Corrections to the BCDToString Example Program Routine
Correcting the C Language Program
Correcting the Pascal Language Program
Index
Feedback to webmaster