Generate the Create/Read/Update/Delete Report

System Generation and Installation › Other Construction Options › Generate the Create/Read/Update/Delete Report

Generate the Create/Read/Update/Delete Report

This report allows you to view which actions for a business system—create, read, update, or delete—are being conducted against the data model entity types. The report lists the actions by three groupings:

By load module, action block, and entity action view
By load module
By load module and action block.

The Create/Read/Update/Delete Report (First Grouping) screen lists the names of the load modules, business system, source members, and action blocks. This grouping also lists the procedure step to which the action blocks belong. For example, the procedure step DIVISION_MAINT contains the action blocks BSD_ADD_DIVISION, BSD_MODIFY_DIVISION, and BSD_DELETE_DIVISION.

The abbreviations CRE, UPD, and DEL indicates the create, update, and delete actions, respectively. The READ action is implied because a read must occur before any other action. For example, the procedure step MAINTAIN_DIVISION reads REQUIRED DIVISION and EMPLOYEE DIVISION.

CREATE/READ/UPDATE/DELETE REPORT BY LOAD MODULE, ACTION BLOCK AND VIEW LOAD MOD BUSINESS SYSTEM MEMBER ACTION BLOCK CRE UPD DEL VIEW ENTITY --------------------------------------------------------------------------- MENU CORPORATE_MANAGEMENT MAINMENU MENU MAINTDIV MAINTAIN_DIVISION REQUIRED DIVISION REQUIRED EMPLOYEE ADDDIV ADD_DIVISION UPD REQUIRED EMPLOYEE CRE UPD NEW DIVISION MODDIV MODIFY_DIVISION UPD REQUIRED EMPLOYEE UPD NEW EMPLOYEE UPD REQUIRED DIVISION DELDIV DELETE_DIVISION EXISTING DEPARTMENT DEL EXISTING DIVISION

The Create/Read/Update/Delete Report (Second Grouping) screen lists more information for each load module. EXT indicates an external action block with DB2 code. A Y indicates that the procedure step includes that action or external action block. Conversely, an N indicates that the procedure does not contain the action or external action block. At least one Y listed for CRE, UPD, DEL, or EXT indicates a repeatable read isolation level (RR) if target DBMS is DB2. If all of the entries are Ns, this indicates a cursor stability isolation level (CS) if target DBMS is DB2.

CREATE/READ/UPDATE/DELETE REPORT BY LOAD MODULE BUSINESS SYSTEM: CORPORATE_MANAGEMENT LOAD MOD CRE UPD DEL EXT CS TRAN DLG TRAN PROCEDURE STEP NAME MENU Y Y Y N MENU MENU MENU MDIV MDIV MAINTAIN_DIVISION MDEP MDEP MAINTAIN_DEPARTMENT MEMP MEMP EMPLOYEE_LIST MEMP EMPLOYEE_DETAIL

This grouping also lists the clear screen transaction code (CS TRAN), the dialog flow transaction code (DLG TRAN), and the name of the procedure step to which the transaction codes are associated.

The Create/Delete/Update/Delete Report (Third Grouping) screen is similar to the second grouping. In the third grouping, however, you can see the action block that conducts the actions.

CREATE/READ/UPDATE/DELETE REPORT BY LOAD MODULE AND ACTION BLOCK BUSINESS SYSTEM: CORPORATE_MANAGEMENT MODULE ACTION BLOCK NAME CRE UPD DEL EXT CS TRAN DLG TRAN

MENU * Y Y Y N MAINMENU MENU N N N N MENU MENU MAINTDIV MAINTAIN_DIVISION N N N N MDIV MDIV ADDDIV ADD_DIVISION Y Y N N MODDIV MODIFY_DIVISION N Y N N DELDIV DELETE_DIVISION N N Y N MAINTDEP MAINTAIN_DEPARTMENT N N N N MDEP MDEP ADDDEPT ADD_DEPARTMENT Y Y N N MODDEPT MODIFY_DEPARTMENT N Y N N DELDEPT DELETE_DEPARTMENT N N Y N EMPLIST EMPLOYEE_LIST N N N N MEMP MEMP DELEMP DELETE_EMPLOYEE N N Y N EMPDET EMPLOYEE_DETAIL N N N N MEMP ADDEMP ADD_EMPLOYEE Y Y N N MODEMP MODIFY_EMPLOYEE N Y N N

To generate the Create/Read/Update/Delete report

On the Application System Construction Menu, type 6 for the Create/Read/Update/Delete report and press Enter.
CA Gen displays the report in ISPF Browse mode. You can scroll up and down in the report with the ISPF scroll keys. The default keys are PF7 to scroll up and PF8 to scroll down.
Press the End key to leave ISPF Browse when you finish viewing the report. CA Gen displays a panel to print the report.
CA Gen automatically creates a sequentially named data set for the report. The data set is named prefix.IEF.RPTn, where prefix is a value set during host installation in the TIUPREF variable and n is a number from one to ten. The CA Gen numbers the data sets from one through ten, and then restarts at one.
Type on of the following print options on the COMMAND line and press Enter:

PK

Print the data set and keep it.

PD

Print the data set, then delete it.

K

Keep the data set but do not print it.

D

Delete the data set without printing it.

When you print the data set, specify to print on a local printer or as a batch job on a system printer.

For a local printer, specify the print mode as local and the printer ID. To submit the print job as a batch job, specify the print mode as batch, the sysout class, and the JCL Job card information.

CA Gen displays the Application System Construction menu when the print completes.