HPlogo ALLBASE/SQL COBOL Application Programming Guide: HP 3000 MPE/iX 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 Title not available, 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 a value less than -14024. SQLCODE values with greater negative values than -14024 indicate errors serious enough to warrant terminating the program. If SQLCODE is less than -14024 in this case, the ABORT-FLAG is set and the program is terminated after paragraph S200-SQL-EXPLAIN is executed.

Feedback to webmaster