 |
» |
|
|
|
This ALLBASE/SQL Advanced Application Programming Guide for
MPE/iX is the first edition of a new manual targeted for experienced ALLBASE/SQL application programmers using ALLBASE/SQL on HP 3000 systems.
It describes product enhancements for ALLBASE/SQL Release F through
the present release. This guide replaces the release specific ALLBASE/SQL application programming bulletins. MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest in a series of forward-compatible operating systems for the HP 3000 line of computers. In HP documentation and in talking with HP 3000 users, you will encounter references to MPE XL, the direct predecessor of MPE/iX. MPE/iX is a superset of MPE XL. All programs written for MPE XL
will run without change under MPE/iX. You can continue to use MPE XL
system documentation, although it may not refer to features added to
the operating system to support POSIX (for example, hierarchical
directories). This guide does not replace the four ALLBASE/SQL application
programming guides written for C, COBOL, FORTRAN, and Pascal programmers.
Indeed, if you are a new user of ALLBASE/SQL who will be assuming programmer's responsibilities, you should put this book down immediately and pick up the application programming guide for the language you use. Until you have read and absorbed your guide, much of the information included in this advanced guide will be of little use to you. This manual is intended as a source of concepts and examples for programmers using the newer and often more complex ALLBASE/SQL coding techniques. Notable features of this new document relative to the existing ALLBASE/SQL manual set include the following: It is language generic. This guide provides information for ALLBASE/SQL programmers as a group; whereas, each of the language specific application programming guides is directed to programmers of a given language, C, COBOL, FORTRAN, or Pascal. This advanced guide contains code segments and programs in C, COBOL, FORTRAN, and Pascal.
Some examples are duplicated in more than one language. Other examples
are presented in only one language. Language generic examples are also included. This advanced guide contains examples based on the sample database environment,
often including message numbers that might be returned to your application.
It frequently refers you to the lanuguage specific application
programming guides and
other manuals in the ALLBASE/SQL manual set for additional information.
Both additions and changes to functionality
are presented. In the case of changes, some information
regarding previous releases can be invalidated.
This is specifically referenced in the advanced guide.
To facilitate information lookup, one chapter is devoted to each type of functionality. The index is task as well as reference oriented.
The following topics are included in this manual: Chapter 1, "Using the Preprocessor," presents complete syntax for Full Preprocessing Mode, Static Conversion Mode, Syntax Checking Mode, and POSIX invocation for the C preprocessor. Chapter 2, "Flagging Non-Standard SQL with the FIPS Flagger,"
discusses ALLBASE/SQL flagging for the FIPS 127.1 standard. Chapter 3, "Comparing Static and Dynamic SQL," contrasts static and
dynamic SQL statements and applications. Chapter 4, "Using Parameter Substitution in Dynamic Statements," introduces and gives examples for using dynamic parameters. Chapter 5, "Using Procedures in Application Programs," presents
application specific features for coding with procedures. Chapter 6, "Using Data Integrity Features," compares the use of statement level integrity (the default) and row level integrity and discusses how to defer constraint error checking, how to use check constraints in tables and views, and how to use features of the ALTER TABLE statement. Chapter 7, "Transaction Management with Multiple DBEnvironment Connections," describes functionality that allows multiple, simultaneous connections to one or more DBEnvironments and use of the SET TIMEOUT statement. Chapter 8, "COBOL Preprocessor Enhancements," outlines two enhancements for the COBOL preprocessor: record descriptions for non-bulk queries and host variable initialization with the VALUE clause. Chapter 9, "Programming with Indicator Variables in Expressions,"
discusses the use of input indicator variables. Chapter 10, "Analyzing Queries with GENPLAN," describes how to use the ISQL GENPLAN statement. Chapter 11, "Using the VALIDATE Statement," introduces the VALIDATE
statement for validating sections prior to runtime. Chapter 12, "Corrections to the BCDToString Example Program Routine," provides replacement pages for the BCDToString routine found in the ALLBASE/SQL C Application Programming Guide and in the ALLBASE/SQL Pascal Application Programming Guide.
Example code is based, for the most part, on the sample
database environment, PartsDBE, which is a part of the ALLBASE/SQL product. (Refer to appendix C in the ALLBASE/SQL Reference Manual for information about the structure of PartsDBE and for listings of the sample database.) We hope you enjoy using the document and that you will send your comments and suggestions to our attention so that the ALLBASE/SQL Advanced Application Programming Guide can become even more effective. |
