SQL Programming Manual for Pascal

Examples of Dynamic NonStop SQL Programs

HP NonStop SQL Programming Manual for Pascal—528614-001

C-2

Simple Dynamic SQL Program

Sample output for the program is as follows:

47> run ezout

PLEASE ENTER:

1 -- To find average salary based on employee number

2 -- To find average salary based on job code

3 -- To find average salary based on department number

Please enter the comparison criteria:

(for example: > 500, = 1000, <= 250)

> 500

THE AVERAGE SALARY IS: 52250

48>