United States-English

ALLBASE/SQL Advanced Application Programming Guide: HP 9000 Computer Systems

»

Technical documentation


	Complete book in PDF


»	Feedback

» Table of Contents

» Index

HP Part Number: 36217-90194

First Edition

Printed in: U.S.A. April 1994

Table of Contents

ALLBASE/SQL Manuals

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

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

List of Figures

12-1 Program cex10a: Dynamic Commands of Unknown Format
12-2 Program pasex10a: Dynamic Commands of Unknown Format

List of Tables

2-1 ANSI Compiler Directives for Flagging Non-Standard Syntax
2-2 ALLBASE/SQL Non-Standard Programming Features
2-3 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for C
2-4 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for COBOL
2-5 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for FORTRAN
2-6 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for Pascal
2-7 FIPS 127.1 Compliant Host Variable Name Lengths
4-1 Where to Use Dynamic Parameters
4-2 Dynamic Parameter Functionality by Programming Language
4-3 ALLBASE/SQL Data Type Byte Alignment
4-4 Setting SQLDA Fields for Output and for Input in C
4-5 Setting SQLDA Fields for Output and for Input in Pascal
4-6 Fields in a Format Array Record in C
4-7 Fields in a Format Array Record in Pascal
4-8 ALLBASE/SQL Default Data Formats for Dynamic Parameters
4-9 Actual to Default Data Type Conversion for Dynamic Parameters
5-1 Using Cursors with Procedures within an Application
5-2 When Dynamic Parameters are Passed Between an Application and a Procedure

Printable version


Privacy statement	Using this site means you accept its terms	Feedback to webmaster

© Hewlett-Packard Development Company, L.P.