Culprit Report that lists all employee names, ID, job title and start date.

Document ID : KB000049401
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Is there an example of how to code a CULPRIT report that lists all employee name, ID, start date, and job title?

Environment: 

z/OS

Answer: 

This report lists all employee name, ID, start date, and job title.

<...+....1....+....2....+....3....+....4....+....5....+....6....+....7.//SYSIN   DD * 
 DATABASE DICTNAME=SYSDICT                               
 IN DB SS=EMPSS01                                        
 PATHAA EMPLOYEE EMPOSITION JOB                          
 01OUT 80 D                                              
 013 EMPLOYEE LISTING                                    
 0151*010 EMP-NAME-0415         HH ' ' 'EMPLOYEE' 'NAME' 
 0151*020 EMP-ID-0415           HH 'EMPLOYEE' 'ID'       
 0151*030 START-DATE-0420       HH 'START' 'DATE'        
 0151*040 TITLE-0440            HH 'JOB' 'TITLE'

Report

Figure 1

Additional Information:

CA Culprit Reference Guide, CA Culprit in the CA IDMS/DB Environment

https://support.ca.com/cadocs/0/CA%20IDMS%2018%205%20User%20Bookshelf-ENU/Bookshelf_Files/PDF/IDMS_Culprit_Ref_ENU.pdf?