Database load - JCL specification
The Data Base Load - JCL Specification screen is used to specify the load job JCL information. This screen is displayed after the Data Base Dataset Specification screen for DLI load job types. For BMP load job types, this screen is displayed after the Processing Options screen.
You also have the option to save records that are rejected during the load process to a discard data set.
Data Base Load - JCL Specification Screen
COMMAND ===>
Discarded records . . Y (Y=Save to a dataset
N=Do not save)
Specify batch JCL information:
Sysout class . . *
JOB statement information:
===> //TSOID01 JOB (XXXXXXX),'FILE-AID LOAD',
===> // MSGCLASS=A,NOTIFY=TSOID01
===> //
===> //
Press Enter to submit batch job Enter JCL command to edit generated JCL
Discarded records
Enter a Y in the Discarded Records field to save the discarded records out of the load processing. A discard data set (userid.IXPREJ.Dnnnnnn.Tnnnnnn) will be allocated in the JCL to save the discarded records.
If the load produced discarded records, review the rejection reasons in the job output. Then you can make the required changes to the records in the discard data set and repeat the load using the discard data set as the FROM dataset (see also FROM Dataset and FROM Dataset).
Enter N if you don’t want to save rejected records in a discard data set.
Sysout class
Enter the output class for the load reports in the Sysout class field.
JOB statement information
Enter the JOB statement and other related JCL statements (for example, /*JOBPARM and /*ROUTE statements).
Terminating the Screen
Do one of the following to terminate the Data Base Load - JCL Specification screen:
- Press Enter to generate the JCL, submit the load job for execution, and return to the Data Base Load - Dataset Specification screen.
- Enter the JCL command to advance to an ISPF/PDF Edit screen, where you can edit the generated JCL before submitting it. See Editing the Generated JCL.
- Enter the END command to return to the Data Base Load - Dataset Specification screen without submitting the load job.
- Enter the RETURN command to return to the Primary Option Menu without submitting the load job.
Editing the Generated JCL
If you entered the JCL command on the Data Base Load - JCL Specification screen, an ISPF/PDF Edit screen similar to the one shown in the following figure is displayed.
ISPF/PDF Edit Screen
COMMAND ===> SCROLL ===>
****** ******************************** TOP OF DATA ****************************
000001 //LOADJOB JOB (XYZ,CWX),’ACCT1’,CLASS=E,PRTY=8
000002 /*ROUTE XEQ LOCAL
000003 /*ROUTE OUTPUT LOCAL
000004 //*
=NOTE= YOU ARE NOW EDITING THE JCL THAT FILE-AID HAS GENERATED TO PERFORM
=NOTE= THE REQUIRED FUNCTION. YOU CAN CHANGE THIS JCL IF DESIRED, AND USE
=NOTE= THE SUBMIT PRIMARY COMMAND TO SUBMIT THE JOB. TO KEEP THIS JCL FOR
=NOTE= FUTURE USE, USE THE CREATE OR REPLACE PRIMARY COMMAND. ENTER THE
=NOTE= END COMMAND TO EXIT THE FUNCTION WITHOUT SUBMITTING THE JOB.
000005 //*----------------------------------------------------------------*
000006 //* SORT LOAD FILE: *
000007 //* THIS STEP SORTS THE INPUT FILE FOR THE DATA BASE LOAD *
000008 //* STEP. *
000009 //*----------------------------------------------------------------*
000010 //SORTSTEP EXEC PGM=SORT
000011 //STEPLIB DD DSN=SYS1.SORTLIB,
000012 // DISP=SHR
000013 //SYSOUT DD SYSOUT=(*)
000014 //SORTIN DD DSN=CW.FISAMP.EXTRACT,
000015 // DISP=SHR
000016 //SORTOUT DD DSN=&&SORTPREF,
Use END command to terminate Load Data Base Specification
At this point in the conversation, the ISPF/PDF editor has been invoked on the temporary data set that contains the JCL generated to do the load. All ISPF edit commands are available for use. For example, to insert additional JCL statements, use the I (Insert) line command. To change the JCL, simply type over the existing data. To delete a line, use the D (Delete) line command. You can use the CREATE and REPLACE primary commands to save the generated JCL into a partitioned (PDS) or sequential dataset, which allows you to submit the JCL in the future without using the online conversation screens.
Do the following after you view or edit the JCL:
- Enter the SUBMIT command to submit the load job for execution. The Database Load Reports are generated.
- Enter the END or CANCEL command to return to the Data Base Load - Dataset Specification screen.
Related topics