Step 2 - View your Qfile in IDD

How to Save a Set of Commands as a Qfile › Looking at Your Qfile Definition Syntax › Step 2 - View your Qfile in IDD

Step 2 - View your Qfile in IDD

In this step, you look at your qfile definition:

To page forward through the qfile definition, press [PF8].
To page backward, press [PF7].

Note that whenever CA OLQ retrieves data from the database, it creates a Structured Query Language (SQL) SELECT statement. The data retrieval selection criteria that you specified on the Column Select screen are specified in the WHERE clause of the SELECT statement.

For a more detailed explanation of this and other CA OLQ syntax statements, refer to the CA OLQ Reference Guide.

Your qfile syntax includes a SELECT (OLQ access mode) statement. The WHERE clause specifies data retrieval selection criteria.

                      IDD nn.n ONLINE      PAGE 2 LINE 1        END OF COMPILER
*+
*+  SET DICTNAME TSTDICT
*+  SET UNDERLINE '-'
*+  SET ACCESS OLQ
*+  SIGNON SS EMPSS01  SCHEMA EMPSCHM ( 100)
*+  OPTIONS ALL HEADER ECHO NOFILLER FULL WHOLE INTERRUPT OLQHEADER
*+  NOPATHSTAT NOSTAT COMMENT VERBOSE NODBKEY PICTURE CODETAB NOSYN
*+  SELECT EMPLOYEE.EMP-FIRST-NAME-0415 EMPLOYEE.EMP-LAST-NAME-0415 EMPLOYEE.ST
*+  -YEAR-0415 EMPLOYEE.START-MONTH-0415 EMPLOYEE.START-DAY-0415 EMPOSITION.SAL
*+  -GRADE-0420 EMPOSITION.SALARY-AMOUNT-0420 EMPOSITION.BONUS-PERCENT-0420 FRO
*+  MPLOYEE, EMPOSITION WHERE (EMP-EMPOSITION.EMPLOYEE.EMPOSITION)
*+  PAGE HEADER BLANK LINES AFTER 1  -
*+   LINE 1 'EMPLOYEE/EMPOSITION REPORT'  CENTER -
*+   LINE 2 '$DATE'  CENTER
*+  PAGE FOOTER BLANK LINES BEFORE 1  -
*+   LINE 1 '- $PAGE -'  CENTER
*+  EDIT EMP-FIRST-NAME-0415  -
*+        ALIGN LEFT   -
*+        OLQHEADER 'FIRST'-
*+                  'NAME'-
*+        PICTURE 'X(10)'
*+  EDIT EMP-LAST-NAME-0415  -
*+        ALIGN LEFT   -
*+        OLQHEADER 'LAST'-