Chapter 4 Building an ALLBASE/SQL\COBOL Application in MPE/iX

Table of Contents

How ALLBASE/SQL Programming Works

Creating an Embedded SQL COBOL Application

Coding the INCLUDE Statement
Coding the Host Variable Declarations
Coding the CONNECT and RELEASE Statements
Coding the SELECT Statement
Coding Statements to Display Data
Using the Preprocessor
Compiling and Linking the Program
Using MPE/iX UDC's for Preprocessing and Compiling
Debugging the Program
Summary of Steps

Adding a Multiple Row SELECT Statement

Adding Additional Host Variable Declarations
Adding the Cursor Declaration
Adding a FETCH and Display Loop
Preprocessing and Compiling the Revised Application

Adding an Explicit Error Checking Routine

Coding the Routine
Creating an Error Condition for the Application
Testing the Error Checking Routine

More Information...

This chapter is a tutorial on building an ALLBASE/SQL application using the DBEnvironment MusicDBE, which you created in the chapter "Setting up a Database with ISQL."




	NOTE: You must complete the tutorial "Setting up a Database with ISQL" at least through page 3-14 before you can complete this tutorial on application programming.

After an introductory section, which explains how programming works in ALLBASE/SQL, a set of tutorial sections steps you through the creation of a simple application using MUSICDBE in COBOL under MPE/iX. The following are the sections in this chapter:

How ALLBASE/SQL Programming Works.
Creating an Embedded SQL COBOL Application.
Adding a Multiple Row SELECT Statement.
Adding an Explicit Error Checking Routine.
More Information...

Chapter 4 Building an ALLBASE/SQL\COBOL Application in MPE/iX

Technical documentation

» Table of Contents

» Index