Edit JCL for Summary File
The following screen is displayed when you select to have File-AID create or update the summary file on the Extract File Specification screen.
ISPF/PDF EDIT Screen
Command ===> SCROLL ===> CSR
You are now viewing the JCL that has been generated to perform the
required function. Change this JCL as desired before submitting.
000012 //SUMMARY EXEC PGM=F2RMAIN,REGION=4096K,
000013 // PARM=(A,B,N,',','.',',',132,3278,.)
000014 //F2RPRINT DD DUMMY
000015 //STEPLIB DD DSN=h1q.SXVJLOAD,
000016 // DISP=SHR
000017 //RDXMLIB DD DSN=h1q.SXVMENU,DISP=SHR
000018 //EXTRACT DD DSN=TSOID01.FDSAMP.EXTRPDS5(EMP3),
000019 // DISP=SHR
000020 /*
000021 //CONTROL DD DSN=TSOID01.FDSAMP.EXTSUMM,
000022 // DISP=OLD
000023 /*
000024 //F2RPRINT DD SYSOUT=*
000025 //SYSOUT DD SYSOUT=*
000026 //SYSTEM DD SYSOUT=*
000027 //SYSPRINT DD SYSOUT=*
****** ****************************** Bottom of Data ******************************
Use this screen to edit and submit the extract summary JCL generated by File-AID.
If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit this screen. Otherwise, File-AID deletes this file.
Submit this JCL to create or update the summary file with the extract header and trailer information. After successful completion, File-AID will continue with either the Load-SQL-Insert, or the Load-DB2-Load panels.
SQL Insert and DB2 Load Utility Load Options
File-AID for Db2 enables you to specify whether the load is performed using SQL INSERT statements or the DB2 Load utility. You can use either method to load data to empty tables or tables that contain data. Either method allows you to delete all existing rows or add rows to tables that contain data.
Use SQL Insert when any of the following are true:
- You want to be able to update existing rows.
- You have limited Db2 authorities. SQL Insert requires only INSERT, UPDATE, and possibly DELETE privileges.
- You want to insert data into single table views.
- You want to insert data into tables at remote locations.
- Tables must be available for other applications to access when File-AID for Db2 is loading data.
- You want to insert data into tables or views for lowercase creator IDs enclosed with quotes.
Use DB2 LOAD when any of the following are true:
- You have a large quantity of data to load and require a faster method for loading the data.
- You want to load to tables in a cyclical relationship.
Related topics