HPlogo ALLBASE/SQL Pascal Application Programming Guide: HP 9000 Computer Systems

Chapter 4 Host Variables

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Host variables are variables used in SQL commands in the executable section. They are used to pass the following information between an application program and ALLBASE/SQL:

  • Data values.

  • Null value indicators.

  • String truncation indicators.

  • Bulk processing rows to process.

  • Dynamic commands.

  • Savepoint numbers.

  • Messages from the ALLBASE/SQL message catalog.

  • DBEnvironment names.

All host variables used in the executable section of a program or subprogram are declared in the declaration section. The declarations must be compatible with ALLBASE/SQL data types. The type declaration entries must also satisfy certain preprocessor criteria.

NOTE: 300/400 Series 300 and Series 800 systems do not allow subprograms.

This chapter identifies where in the procedure section you can use host variables and then discusses how to write type declarations that complement the way host variables are used.

Feedback to webmaster