Report Decollating Missions: Job
This chapter includes the following topics:
Report Separation Method
Although the manual process of report separation is simple and straightforward, the process is very time-consuming, labor-intensive, and error-prone.
What is Decollation?
Decollating a report, or any SYSOUT, is primarily a process of establishing report ownership. A complete report may belong to one user, or different pages of a report may belong to different users. The decollating mission scans each page of the report for user-defined character strings that are unique to specific users and therefore indicate which user "owns" the page.
Report decollating mission parameters are defined once for each job. Control-D uses these parameters for many executions of the same decollating mission. Of course, you can modify these parameters at any time.
Sample Job Decollating Mission
Begin
-
In the Control-D JCL library, there is a member named REPORT1. Edit member REPORT1 (with either ISPF, ROSCOE, or one of the other online environments supported by Control-D).
This job creates two sample reports, one report produced by each of the two steps in the job.
The reports are produced in class D. If this class is not convenient, change it to a different output class. Be sure to choose a class whose reports are not printed or purged before Control-D gains control. Do not use the same class that was used for the generic decollating mission.
-
Submit the job.
-
View the reports created by the job on spool (using FLASHER, SDSF, and so on).
-
Return to the Control-D Online facility and the IOA Primary Option menu.
-
Select Option R and press Enter. The Control-D Report Decollating Mission Definition entry panel is displayed.
Figure 22 Report Decollating Mission Definition Entry Panel
Copy--------- CONTROL-D REPORT DECOLLATING MISSION DEFINITION ENTRY PANEL ------(R)
COMMAND ===>
SPECIFY LIBRARY, JOB/REPORT NAME, CATEGORY
LIBRARY ===> CTD.PROD.REPORTS
JOB ===> (Blank for job selection list)
CATEGORY ===> (Blank for category selection list)
SHOW SCHEDULING CRITERIA ===> N (Y/N)
USE THE COMMAND "SHPF" TO SEE PFK ASSIGNMENT 18.12.23 -
If the LIBRARY field does not contain the name of your Control-D REPORTS library, correct it.
-
Press Enter. A list of all decollating missions used throughout the Getting Started Guide is displayed.
Figure 23 List of All Decollating Missions in the Getting Started Guide
CopyLIST OF JOBS LIB: CTD.PROD.REPORTS ----------------
COMMAND ===> SCROLL===> CRSR
OPT NAME ------------ VV.MM CREATED CHANGED SIZE INIT MOD ID
PRODJCL 01.02 00/03/03 00/04/04 15:50 14 12 0 M73
jobnamR1 01.05 00/05/05 00/05/05 12:51 31 31 0 M55A
jobnamR2 01.01 00/05/05 00/05/25 14:49 31 31 0 M55A
====== >>>>>>>>>>>>>>>>>> NO MORE JOBS IN LIBRARY <<<<<<<<<<<<<<<<<<<<<< =====
OPTIONS: S SELECT O ORDER F FORCE B BROWSE D DELETE 14.50.25The name of the mission to activate is jobnamR1.
The job name prefix (jobnam) was automatically updated with the user job name prefix defined by your data center.
-
Position the cursor in the OPT field, to the left of the jobnamR1 mission.
-
Type S and press Enter. The Category List screen is displayed.
Figure 24 Decollation Mission Categories
CopyCATEGORIES OF LIB CTD.PROD.REPORTS JOB: jobnamR1
COMMAND ===> SCROLL===> CRSR
OPT NAME ---------------------------------------------------------------------
DAILY INVENTORY AND EMPLOYEE SAMPLE REPORT
====== >>>>>>>>>>>>>> NO MORE CATEGORIES FOR THE JOB <<<<<<<<<<<<<<<<<< =====
ECT D DELETE I INSERT O ORDER F FORCE 18.17.14Each decollating mission consists of one or more categories. In this example, jobnamR1 consists of just one category. For more information about categories, see the Control-D and Control-V User Guide.
-
Position the cursor under the OPT field, to the left of category DAILY.
-
Type S and press Enter. The report decollating mission definition for category DAILY is displayed.
Figure 25 Predefined Report Decollating Mission Definition
Copy----- CONTROL-D/V CATEGORY DAILY JOB jobnamR1 ----------- (R.S)
COMMAND ===> SCROLL===> CRSR
+-----------------------------------------------------------------------------+
CATEGORY DAILY JOBNAME jobnamR1 GENERIC MONITOR
===========================================================================
DEF COPIES 01 LVL USER UNIDENT DEST MAX COPIES
===========================================================================
ON CLASS = D EXTWTR DEST FORM
PRT COPIES LVL USER DEST MAX COPIES
PRINT/CDAM PARMS =
WHEN LINE 00003 - 00003 COL 00034 - 00050 PRINT REF NXT CT AND/OR
STRING = INVENTORY REPORT
DO USER = WAREHOUSE LVL LINE COL - S N T
SYNONYM = CONCAT =
DO USER = PRODUCTION LVL LINE COL - S N T
SYNONYM = CONCAT =
DO NAME = INVENTORY REPORT
DO PRINT = STD COL -
DO BACKUP = BKP0007D
DO
WHEN LINE 00001 - 00001 COL 00014 - 00046 PRINT REF NXT CT AND/OR
STRING = E M P L O Y E E S R E P O R T
DO NAME = EMPLOYEES REPORT
DO USER = * LVL LINE COL 064 - 074 S N T
DO USER = * LVL LINE COL 064 - 074 S N T
SYNONYM = CONCAT =
DO PRINT = STD COL -
DO BACKUP = BKP0007D
DO
WHEN LINE - COL - PRINT REF NXT CT AND/OR
STRING =
FILL IN REPORT DEFINITION. CMDS: EDIT, SCHED, SHPF, PATH 08.57.23 -
Look at a predefined report decollating mission definition. At this stage, you need only a few of the parameter fields. In general, Control-D lets you see all the parameters for each mission in a single screen. However, only a few of the parameters are used for each mission.
Note the following fields:
Table 2 Decollation Parameters
Parameter
Descriptions
JOBNAME jobnamR1
Name of the job that produces the reports to be processed by the decollating mission.
ON CLASS
Job class output to be processed. If you changed the output class in the job that created the reports, make the same change here as well.
WHEN LINE
STRING
WHEN line and column range parameters are used to indicate the report page area in which the identifying character string is located.
DO
After the report page is identified, the DO statement instructs Control-D what to do with the report. Any number of DO statements can be specified:
-
DO USER=recipient name
All output identified by the above WHEN statement is directed to the specified recipient. Notice the second WHEN statement. The DO USER statement under it specifies an asterisk (*). This instructs Control-D to retrieve the recipient name (or synonym) from the report itself. -
DO NAME=report name
All output identified by the above WHEN statement is assigned this name in Control-D. -
DO PRINT=STD
All output identified by the above WHEN statement is printed on your data center's standard (STD) form. -
DO BACKUP=BKP0007D
All output identified by the above WHEN statement is backed up to tape or cartridge and retained for a week.
-
-
Press PF03/PF15 to return to the Category List screen.
-
Press PF03/PF15 again. The Job List screen is displayed.
If you modified in the report decollating mission, the Exit Option window is displayed.
-
Type Y in the SAVE field and press Enter.
Y stands for YES SAVE, so that the modifications you made are saved.
-
Continue with the next exercise to order the mission.
Activating a Decollating Mission Manually
As mentioned earlier, a decollating mission is never activated unless it is ordered. Since this decollating mission was not planned in advance, it must be ordered manually.
Begin
The Job List screen should be displayed on your computer.
Figure 26 Job List Screen
LIST OF JOBS LIB: CTD.PROD.REPORTS ----------------
COMMAND ===> SCROLL===> CRSR
OPT NAME ------------ VV.MM CREATED CHANGED SIZE INIT MOD ID
PRODJCL 01.01 00/03/03 00/04/04 12:11 14 12 0 M73
jobnamR1 01.00 00/05/05 00/05/05 17:50 31 31 0 M55A
jobnamR2 01.00 00/05/05 00/05/05 17:59 31 31 0 M55A
====== >>>>>>>>>>>>>>>>>> NO MORE JOBS IN LIBRARY <<<<<<<<<<<<<<<<<<<<<< =====
OPTIONS: S SELECT O ORDER F FORCE B BROWSE D DELETE 12.30.53-
Position the cursor in the OPT field, to the left of the jobnamR1 mission.
-
Type O and press Enter.
The confirmation window appears.
Figure 27 Confirmation Window
CopyLIST OF JOBS LIB: CTD.PROD.REPORTS ----------------
COMMAND ===> SCROLL===> CRSR
OPT NAME ------------ VV.MM CREATED CHANGED SIZE INIT MOD ID
PRODJCL +-------------------------------+ 12 0 M73
O jobnamR1 <-----------| CONFIRM ODATE 050500 | 31 0 M55A
jobnamR2 +-------------------------------+ 31 0 M55A
====== >>>>>>>>>>>>>>>>>> NO MORE JOBS IN LIBRARY <<<<<<<<<<<<<<<<<<<<<< =====
OPTIONS: S SELECT O ORDER F FORCE B BROWSE D DELETE 18.30.53 -
Type Y in the CONFIRM field and press Enter. The following screen is displayed:
Copy----------------------- CONTROL-D REPORT ORDER MESSAGES ------------------(R.O)
COMMAND ===> SCROLL===> CRSR
-------------------------------------------------------------------------------
19.41.02 CTD049I MISSION PROCESSING STARTED
19.41.02 CTD528I MISSION jobnamR1 ODATE 050500 PLACED ON ACTIVE MISSIONS FILE
19.41.02 CTD696I ALL MISSIONS PROCESSED SUCCESSFULLY
====== >>>>>>>>>>>>>>>>> END OF MESSAGE LIST <<<<<<<<<<<<<<<<< =====The decollating mission has just been ordered.
-
Press PF03/PF15.
-
To return to the IOA Primary Option menu, type =1 in the COMMAND field and press Enter.
Tracking and Control
Tracking and control of the decollating mission that you just ordered is performed in the Active Missions Environment screen. This exercise shows you how to track the decollating mission.
Begin
-
From the IOA Primary Option menu, select Option A and press Enter.
Figure 28 Active Missions Environment Screen
Copy------------------- CONTROL-D ACTIVE MISSIONS ENVIRONMENT ----------------(A)
COMMAND ===> SCROLL===> CRSR
O NAME ODATE TYP OWNER ------------------STATUS ------------------ UP
STD 050500 PRT M22 WAIT PROCESS
BKP0007D 050500 BKP M22 WAIT PROCESS
BKP0031D 050500 BKP M22 WAIT PROCESS
BKP0180D 050500 BKP M22 WAIT PROCESS
BKP0365D 050500 BKP M22 WAIT PROCESS
RSTADHOC 050500 RST M22 WAIT PROCESS
RST0060M 050500 CRS M22 WAIT PROCESS
* 050500 REP M22 GENERIC WAITING FOR JOB
jobnamR1 050500 REP M22 Jnnnnn DECOLLATING
======== >>>>>>>>>>>>>>>>>>> BOTTOM OF ACTIVE MISSIONS LIST <<<<<<<<<<<<<< ===
OPT: ? WHY H HOLD D DELETE F FREE L LOG Z ZOOM R RERUN P PRINT CONTROL 19.42.12The last scrollable line in the screen is where the decollating mission that you just ordered is displayed.
-
The status may change several times during execution. Press Enter periodically to display the current status. When the decollating mission finishes execution, its status becomes ENDED OK.
Viewing and Editing a Report Online
Viewing a Report
Begin
-
Return to the IOA Primary Option menu.
-
Type U and press Enter. The User Reports entry panel is displayed.
Figure 29 User Reports Entry Panel
Copy-------------------- CONTROL-D - USER REPORTS ENTRY PANEL ---------------(U)
COMMAND ===>
OPTIONS ===> 1. PERMANENT 2. ACTIVE 3. HISTORY
REPORT NAME ===>
Report name, prefix or mask
USER ===> PROD Recipient name or prefix
DATE FROM ===> TO Report date or relative day
JOBNAME ===> Job name, prefix or mask
DISPLAY TYPE ===> D BYPASS PANEL ===> N
SELECT AN OPTION FILL IN THE SELECTION CRITERIA AND PRESS ENTER 09.27.08 -
Position the cursor in the USER field.
-
Type PROD.
In the Show Option Window, ensure that Y appears in the CHILD field and that the SELECT BY fields are blank. For information about the Show Option Window, see the Control-D and Control-V User Guide.
-
Position the cursor in the DISPLAY TYPE field.
-
Type D and press Enter.
The Active Report List screen is displayed.
Figure 30 Active Report List Screen
CopyACTIVE LIST <O> JOB REP USR MGT CHILD (U)
COMMAND ===> SCROLL===> CRSR
O USER REPORT NAME JOB COP FORM C DEST/WTR W FROMUSER
DEV EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 1 L- 10 05/05/00
MGT EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 1 L- 18 05/05/00
MKT EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 3 L- 131 05/05/00
PROD INVENTORY REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 9 L- 427 05/05/00
PROD EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 3 L- 169 05/05/00
PROD INVENTORY REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 9 L- 427 05/05/00
====== >>>>>>>>>>>>>>>>>> NO MORE REPORTS IN THE LIST <<<<<<<<<<<<<<<<<< ======
V VIEW E EDIT P PRINT U UPDT I INS D DEL N NOTE A ADD INFO G GIVETO 12.39.17 -
Type DI O in the COMMAND field and press Enter.
Figure 31 Display Type O
CopyACTIVE LIST <O> JOB REP USR MGT CHILD (U)
COMMAND ===> SCROLL===> CRSR
O USER REPORT NAME JOB COP FORM C DEST/WTR W FROMUSER
DEV EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 1 L- 10 05/05/00
MGT EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 1 L- 18 05/05/00
MKT EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 3 L- 131 05/05/00
PROD INVENTORY REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 9 L- 427 05/05/00
PROD EMPLOYEES REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 3 L- 169 05/05/00
PROD INVENTORY REPORT jobnamR1 001 STD D
Wait print JOB 4902 P- 9 L- 427 05/05/00
====== >>>>>>>>>>>>>>>>>> NO MORE REPORTS IN THE LIST <<<<<<<<<<<<<<<<<< ======
V VIEW E EDIT P PRINT U UPDT I INS D DEL N NOTE A ADD INFO G GIVETO 12.39.17 -
Return to display type D by typing DI D in the COMMAND field and pressing Enter.
-
Position the cursor in the OPT field to the left of the EMPLOYEES REPORT of user PROD (Production Department).
-
Type V and press Enter.
The CONTOL-D Report Viewing screen is displayed.
Figure 32 Control-D Report Viewing Screen
Copy----------------- CONTROL-D REPORT VIEWING NOTES 0 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR PROD JB jobnamR1 00465 DT 050500 RUL
REPORT EMPLOYEES REPORT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
E M P L O Y E E S R E P O R T ----- FOR PRODUCTION DEPAR
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
-------- -------------- ------ ------ ------------ ---------- ---------
66474 C. POHLHAMMER 23 39,500 XXX-YY-ZZZZ 2
66475 G. MEREDITH 09 40,000 XXX-YY-ZZZZ 3
66491 P. MILLER 12 31,500 XXX-YY-ZZZZ 1
66498 K. BOYLE 22 39,500 XXX-YY-ZZZZ 2
66501 R. BERLE 14 39,500 XXX-YY-ZZZZ 2
66513 C. KING 12 30,000 XXX-YY-ZZZZ 2
66519 G. BROWNE 02 36,500 XXX-YY-ZZZZ 2
66524 R. SOLOMON 04 35,000 XXX-YY-ZZZZ 3
66526 S. CUNNINGHAM 21 39,500 XXX-YY-ZZZZ 2
66529 M. TABER 22 39,500 XXX-YY-ZZZZ 2
66530 A. WINGER 23 39,500 XXX-YY-ZZZZ 2
66531 B. BOOKSPAN 05 47,000 XXX-YY-ZZZZ 4
66533 R. MULU 29 39,500 XXX-YY-ZZZZ 2
66539 E. SMART 02 29,000 XXX-YY-ZZZZ 4
66540 N. MATTOZZI 11 29,000 XXX-YY-ZZZZ 2
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.57.55 -
Practice with the various scrolling options for a few minutes to get familiar with them.
-
Scroll Forward and Backward: Press PF08/PF20 and PF07/PF19.
-
Shift Left and Right: Press PF10/PF22 and PF11/PF23.
-
Scroll by Print-Page: Type N
2in the COMMAND field and press Enter. Notice the page count on the top right side of the screen. -
Scroll the Maximum Amount to the Bottom: Type M in the COMMAND field and press PF08/PF20.
-
The User Reports entry panel is the main end-user (recipient) interface to access Control-D information. Many facilities are provided under the User Reports screens.
Reports that were decollated and assigned to the user MGT (Management) and the descendants of that user (as defined in the Recipient Tree) are listed on this screen.
When viewing the list of MSGCLASS (JCL) reports, you used display type J. Other display types have been defined for viewing regular reports. You are now using display type D. Let's examine a different display type for regular reports.
Notice that each report is now identified by two lines of information.
There are many different display types you can use. For additional information about display types and the fields displayed in the User Report list, refer to the Control-D and Control-V User Guide or use the HELP key (PF01/PF13).
Displaying an Edited Report
Customizing the report display to your needs can save you time when examining reports for the information that you regularly need. This is done through the use of rulers.
Rulers can be used to:
-
Define headers.
-
Reposition fields in the screen layout.
-
Leave unwanted or unnecessary fields out of display.
-
Select records for inclusion in or exclusion from the display.
Predefined Ruler $EMPLOYE
In this exercise you activate a previously defined ruler called $EMPLOYE. This ruler contains line-editing options, such as Headers for assigning lines as headers, and Delete for deleting lines from the display.
Begin
-
Verify that you are in the EMPLOYEE REPORT of user PROD. Check this by looking at the third line of the screen. The USR field should say PROD, and the REP field should say EMPLOYEE REPORT.
-
From the COMMAND field, type RULER $EMPLOYE and press Enter.
View the edited report. Notice that the header lines are highlighted. Scroll forward and backward (PF08/PF20 – PF07/PF19). The header lines do not scroll, enabling you to identify each column of the page even after scrolling down more lines than the terminal can display on one screen.
Look at the RUL field at the right of the third line of the screen. This field indicates the ruler name activated (if any). It is possible to deactivate the ruler.
-
Type RULER and press Enter.
View the same report without a ruler. Activate and deactivate the ruler as many times as you want. Reactivate the ruler. The ruler you have just activated contains headers for easier viewing.
Predefined Ruler $EMPVAC
In this exercise, you activate a ruler called $EMPVAC that was designed to check each employee’s vacation and sick days. In its original form, this information is hard to find on the report because the employee number and employee name columns are formatted on the left side of the report, while the vacation and sick days columns are on the right side.
Begin
-
From the COMMAND field, type RULER $EMPVAC (or RU $EMPVAC) and press Enter.
Notice that only columns specifically needed at this time are shown. Examining the report is now quite simple. This has been achieved with the help of column-editing within a ruler.
-
Press PF03/PF15 to return to the Active List screen.
View and activate these rulers on other reports to become more familiar with the Online Viewing and Editing. For additional information on advanced ruler techniques, refer to the Control-D and Control-V User Guide.
Report Editing
There are two types of rulers in Control-D:
-
VIEW Rulers: Used for editing reports that are viewed.
-
PRINT Rulers: Used for editing reports to be printed.
In this exercise you specify the type of ruler while defining or modifying it.
Begin
-
From the Active User Report List screen, type V in the OPT field to the left of the EMPLOYEES REPORT-MARKETING and press Enter.
The report is displayed and the cursor is positioned in the COMMAND field of the report.
-
Type EDIT and press Enter. The Report Editing screen is displayed.
Figure 33 Report Editing Screen
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===>
USER MKT REPORT EMPLOYEES REPORT JOB jobnamR1
RULER NAME ===> Name or blank for default ruler
RULER TYPE ===> VIEW View or Print
REPORT NAME ===>
To copy a ruler - full report name
JOB NAME ===> To copy a ruler - full job name
USER NAME ===> To copy a ruler - full user name
1 EDIT report lines and columns
2 INCLUDE lines based on strings
3 EXCLUDE lines based on strings
4 COLOR lines based on strings
PLEASE SELECT OPTION, OR PRESS PF3 TO SAVE/EXIT THE RULER 14.21.41
This screen is used to copy existing rulers from other reports or recipients by selecting one of the four editing options:
-
Edit report lines and columns.
-
Include lines based on strings.
-
Exclude lines based on strings.
-
Color lines based on strings.
Editing Report Lines and Columns
Edit report lines and columns as follows:
Begin
-
Type 1 in the COMMAND field and press Enter. The Edit Report Lines and Columns screen is displayed.
Figure 34 Edit Report Lines and Columns Screen
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR MKT JOB jobnamR1 RULER DEFAULT TYPE VIEW
REPORT EMPLOYEES REPORT
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
-------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
66096 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
66114 S. MCCLURE 02 37,500 XXX-YY-ZZZZ 2
66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 15.08.04 -
The first line of the report is not relevant and can be removed, as follows:
-
Position the cursor to the left of the first line of the report in the OPT field.
-
Type D. The cursor automatically moves to the next line. The following three lines will be used for the headers of our report.
-
-
Type H three times. These lines will be the header lines for the edited report.
-
Press PF04/PF16 to see how these edits affect the appearance of this edited report.
PF04/PF16 is used to alternately display the ruler definition and the report.
You can see that the line you deleted does not appear. Notice that the three header lines are highlighted. Scroll down using PF08/PF20 and notice that the header lines do not scroll. To scroll up press PF07/PF19.
-
Press PF04/PF16 to return to Edit mode.
The original report is displayed in the Edit Report Lines and Columns screen.
Including Lines Based on Strings
Because annual salary is of interest in the report, you should INCLUDE only those employees that have a salary of $36,000 or more.
Begin
-
Press PF03/PF15 to exit the EDIT Option. The Report Editing screen is displayed.
-
Position the cursor in the COMMAND field, type 2 and press Enter. The Include Lines Based on Strings screen is displayed.
-
Position the cursor in the first field on the first STR line.
-
Type .GE.36,000 and press Tab.
.GE. stands for greater than or equal to. You can see all other logical comparison operators by using the HELP facility (press PF01/PF13).
-
In the first COL field, type 036 and press Tab.
-
In the - field, type 041.
Figure 35 Include Lines Based on Strings Screen
Copy---------------- CONTROL-D - INCLUDE LINES BASED ON STRINGS ----------(U.E.2)
COMMAND ===> Apply on header N
STR .GE.36,000 COL 036 - 041 LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
PLEASE FILL IN THE SELECTION STRINGS 15.31.54
---------------- CONTROL-D - INCLUDE LINES BASED ON STRINGS ----------(U.E.2) -
-
Press PF04/PF16 to review the results of the "include" in the report.
-
Press PF04/PF16 to return to the Report Editing screen.
Editing Colored Lines Based on Strings
If you have a color terminal, use Option 4 (COLOR) to color all salaries over 36,000, and try coloring all salaries over 50,000 in a different color.
Exiting and Saving the Ruler
Begin
-
From the Report Editing screen, press PF03/PF15 to exit and save the ruler. The following Exit Option window is displayed.
Figure 36 Report Editing Exit Option Window
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===> +--------------------------------+
USER MKT REPORT EMPLOYEES REP | |
| PLEASE SELECT EXIT OPTION |
| |
RULER NAME ===> DEFAULT | Exit option ===> 3 |
RULER TYPE ===> VIEW | |
REPORT NAME ===> | 1 KEEP ruler active |
| 2 CLEAR (no ruler) |
JOB NAME ===> | 3 SAVE ruler as: |
USER NAME ===> | |
| Ruler name ===> your-name |
| Ruler type ===> VIEW |
1 EDIT report lines and columns | |
+--------------------------------+
2 INCLUDE lines based on strings
3 EXCLUDE lines based on strings
4 COLOR lines based on strings
PLEASE SELECT OPTION,OR PRESS PF3 TO SAVE/EXIT THE RULER 15.35.26Table 3 Exit Option Window Options
Option
Description
1
KEEP the ruler. The ruler is kept throughout this session only. Once you exit the Control-D Online facility, the ruler disappears.
2
CLEAR the ruler. The ruler immediately disappears.
3
SAVE the ruler. The ruler is saved in the Active User Reports file. You can activate this ruler any time, even after exiting and re-entering the Control-D Online facility numerous times.
-
Position the cursor in the Exit Option field and type 3.
-
Position the cursor in the Ruler Name field.
-
Type your name (or initials) and press Enter. A ruler in your name is now saved in the Active User Reports file.
Decollating a Report Directly from CDAM
Control-D uses two report processing techniques:
-
Basic Technique: Does not require JCL changes. It implements immediately on any report. The reports are produced on spool and picked up by Control-D.
-
CDAM Technique: Requires only minor JCL changes. It writes reports produced by a job directly to CDAM datasets, and solves many problems in a typical data center. Several advantages of the CDAM technique are:
-
The reports are written directly to compressed SYSOUT. They do not pass through the spool. Consequently, redundant read/write operations are eliminated and computer resources are conserved.
-
The elapsed time of jobs that create large reports is reduced by 10% or more.
-
The CDAM performs report compression. The compression rate is 30 to 70%, depending on the type of data that is compressed. This results in significant disk space savings.
-
CDAM SYSOUT (datasets) are protected using regular conventional security methods, such as RACF, ACF2, or TOP-SECRET.
-
The risk of 100% spool utilization is greatly reduced, since the spool is minimally utilized.
-
There is no danger of SB37 ABENDs due to insufficient space on disk (for the compressed SYSOUT).
-
This exercise illustrates the CDAM technique.
Begin
-
From the IOA Primary Option menu, select Option R and press Enter. The Report Decollating Mission Definition entry panel is displayed.
-
If the library name in the LIBRARY field is not the same as your Control-D REPORTS Library name, correct it.
-
Press Enter. The Job List screen is displayed.
-
Position the cursor in the OPT field to the left of the jobnamR2 mission.
-
Type S and press Enter. The Category List screen is displayed.
-
Position the cursor in the OPT field to the left of category DAILY.
-
Type S and press Enter. The Report Decollating Mission Definition screen is displayed.
-
A decollating mission uses the CDAM technique, as opposed to the basic technique, when the ON statement in the mission is defined as ON DSN. Examine the ON statement for this decollating definition, as it appears below:
ON DSN JOBNAME=jobnameR2
Parameter DSN indicates to Control-D that the specified output was created directly to a CDAM dataset. Parameter JOBNAME instructs Control-D to handle all output created by this job.
-
Press PF03/PF15 twice to order the decollating mission.
If you made any changes in the decollating mission, an Exit Option window is displayed.
-
Type N in the SAVE field and press Enter. The cursor is positioned to the left of the decollating mission you have just exited.
-
Type O and press Enter.
The following confirmation window appears:
Figure 37 Confirmation Window
CopyLIST OF JOBS LIB: CTD.PROD.REPORTS ----------------
COMMAND ===> SCROLL===> CRSR
OPT NAME ------------ VV.MM CREATED CHANGED SIZE INIT MOD ID
PRODJCL 01.01 00/03/03 00/04/04 12:11 14 12 0 M73
jobnamR1 +-------------------------------+ 31 0 M55A
O jobnamR2 <-----------| CONFIRM ODATE 050500 | 31 0 M55A
====== >>>>>>>>>>>>>>>>>> +-------------------------------+ <<<<<<<<<<< =====
OPTIONS: S SELECT O ORDER F FORCE B BROWSE D DELETE 18.30.53The job name prefix (jobnam) was automatically updated during the installation process with the user job name prefix defined by your data center.
-
Type Y in the CONFIRM field and press Enter. The following screen is displayed:
Copy----------------------- CONTROL-D REPORT ORDER MESSAGES ------------------(R.O)
COMMAND ===> SCROLL===> CRSR
-------------------------------------------------------------------------------
19.52.47 CTD049I MISSION PROCESSING STARTED
19.52.47 CTD528I MISSION jobnamR2 ODATE 050500 PLACED ON ACTIVE MISSIONS FILE
19.52.47 CTD696I ALL MISSIONS PROCESSED SUCCESSFULLY
====== >>>>>>>>>>>>>>>>> END OF MESSAGE LIST <<<<<<<<<<<<<<<<< ===== -
In the Control-D JCL library, there is a member named REPORT2. Edit the member with either ISPF, ROSCOE, or any of the other online environments supported by Control-D.
This job's output (report) is created directly to CDAM compressed datasets, and is not created on spool.
Find the following DD card named SYSUT2 in the job:
Copy//SYSUT2 DD SUBSYS=(CDAM,'SYSOUT=D')This is the only change in the JCL required to create reports directly to CDAM.
For more information about optional CDAM parameters, see the Control-D and Control-V User Guide.
Verify that this job is authorized to create Control-D output datasets by your local security package (RACF, ACF2, TOP SECRET, and so on).
-
Submit the job.
-
Again, you can track the mission on the Active Missions screen. When the mission receives an ENDED OK status, you may proceed.Transfer to the Active Report List screen, and select for viewing the report that was just decollated (in the same way you viewed reports previously).
The decollating mission has just been ordered.
Communities
Support Center
YouTube
Twitter
Facebook
LinkedIn