SQL Programming Manual for TAL

Examples of Dynamic NonStop SQL Programs
HP NonStop SQL Programming Manual for TAL—527887-001
C-2
Dynamic SQL Program
Figure C-1. Output for the Dynamic SQL Program
10> RUN TALDEZO
PLEASE ENTER:
Please enter selection: 1
Please specify the comparison criteria:
(for example: > 500, = 1000, <= 250)
Enter the comparison criteria now: > 500
THE AVERAGE SALARY IS: 52250
11>
1 - - To find average salary based on employee #
2 - - To find average salary based on job code
3 - - To find average salary based on department #
VSTC01.vsd