HPlogo ALLBASE/SQL Pascal Application Programming Guide: HP 9000 Computer Systems > Chapter 3 Embedding SQL Commands

Explicit Status Checking

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

In explicit status checking, shown at 9 in Figure 3-1, you explicitly examine an SQLCA field for a particular value, then perform an operation if the value exists. In this, example, the SQLCA field named SQLCODE is examined to determine whether it contains one of the following values:

  • 0, indicating no error occurred.

  • 100, indicating no rows qualified for the SELECT operation.

  • -10002, indicating more than one row qualified for the SELECT operation.

If SQLCODE contains any other value, procedure SQLStatusCheck is executed. Values less than -14024 indicate errors serious enough to warrant terminating the program.

Feedback to webmaster