HP 3000 Manuals HP 3000 Manuals
Table of Contents
ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX
ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX : COPYRIGHT N
Ch 1. Using New 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
Ch 2. Using Procedures in Application Programs
Using Host Variables to Pass Parameter Values
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?
Ch 3. 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 the SQLDA for Input
Using the Data Buffer for Input
Example in C Using Output and Input Data Buffers
Using a BULK INSERT Statement with Dynamic Parameters
Example in C Using a BULK INSERT
Example in COBOL Using a BULK INSERT
Example in Pascal Using a BULK INSERT
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
Ch 4. Preprocessing in Static Conversion Mode
Static Conversion Mode Syntax Specification
Static Conversion Mode for C Applications
Static Conversion Mode for Pascal Applications
Parameters
Description
Authorization
Example of Static Conversion Processing of a C Application
Example of Static Conversion Processing of a Pascal Application
Comparing Static and Dynamic Statements
Coding Considerations
Coding an Application that can be Either Static or Dynamic
Converting a Static Application to a Dynamic Application
Enhancing Performance
Ch 5. 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
Ch 6. COBOL Preprocessor Enhancements
Record Descriptions For Non-Bulk Queries
Host Variables Initialized With The VALUE Clause
Ch 7. Programming with Indicator Variables in Expressions
Ch 8. Analyzing Queries with GENPLAN
Ch 9. Using the VALIDATE Statement
Ch 10. Using Binary and Varbinary Data in C Applications
INDEX
Index