Using Working-Storage Items – select1.sqb

Compile and run the select1 program to find the range of customer numbers in the customer table, prompt the user for a customer number, and then retrieve that record. Remember to compile and run the create program before running select1.

This program demonstrates the following SQL concepts:

• SELECT statements for returning a single row of data.
• host variables.
• MIN and MAX functions. These are group functions that operate on a field, or column, of data.