Exporting a prompted query object

This section illustrates an example of an exported prompted query. Figure 18 shows the Prompted Query base panel echo text of a prompted query to be exported.

Figure 18. Sample prompted query to be exported

  Tables:
    Q.STAFF(A)
    Q.ORG(B)
    Q.STAFF(C)
 
  Join Tables:
    A.DEPT And B.DEPTNUMB
    And A.ID And C.ID
 
  Columns:
    A.ID
    A.DEPT
    A.JOB
    A.SALARY
    DEPTNUMB
    C.SALARY
    C.SALARY+A.COMM
 
  Row Conditions:
    If A.SALARY Is Greater Than 10000
    And A.DEPT Is Equal To 84 or 96
 
  Sort:
    Descending by C.SALARY+A.COMM
 
  Duplicate Rows:
    Keep duplicate rows

Figure 19. The exported file, data set, or CICS data queue

H QMF 11 T 01 E V W E R 01 03 98/11/20 17:12
T 1110 003 002 1112 001 1113 050
R A Q.STAFF
R B Q.ORG
R C Q.STAFF
T 1150 002 002 1152 020 1153 020
R A.DEPT               B.DEPTNUMB
R A.ID                 C.ID
T 1210 007 002 1212 001 1213 255
R C A.ID
R C A.DEPT
R C A.JOB
R C A.SALARY
R C B.DEPTNUMB
R C C.SALARY
R C C.SALARY+A.COMM
T 1310 009 003 1312 001 1313 008 1314 255
R 1 C        A.SALARY
R 2 IS       GT
R 3          10000
R 4 I
R 1 C        A.DEPT
R 2 IS       EQ
R 3          84
R 3          96
R 4 A
T 1410 001 002 1412 001 1413 255
R D C.SALARY+A.COMM
V 1501 001 K
E