Chapter 25. Test data and File Export 723
25.2.3 Load data into an IMS database
Example 25-13 presents an IMS sample JCL to load IMS data.
Example 25-13 Sample IMS load job
//R1LOAD EXEC PGM=DFSRRC00,PARM='DLI,PR1A,PR1C,,,,,,,,,,,N,N'
//STEPLIB DD DSN=IMS8ADT.USERRESL,DISP=SHR
// DD DSN=IMS800A.SDFSRESL,DISP=SHR
// DD DSN=DELAHAY.FMN.LOADLIB,DISP=SHR
//DFSRESLB DD DSN=IMS8ADT.USERRESL,DISP=SHR
// DD DSN=IMS800A.SDFSRESL,DISP=SHR
//IMS DD DSN=DELAHAY.FMN.DBDLIB,DISP=SHR
// DD DSN=DELAHAY.FMN.PSBLIB,DISP=SHR
//*
//SYSPRINT DD SYSOUT=*
//DFSURWF1 DD DSN=DELAHAY.FMN.DFSURF1.DR1E,DISP=(,CATLG),
// DCB=(BLKSIZE=1008,LRECL=900,RECFM=VB),
// VOL=SER=ADTW01,SPACE=(CYL,(2,2),RLSE),UNIT=3390
//DFSURCDS DD DSN=DELAHAY.FMN.RLCDS,DISP=(,CATLG),
// UNIT=3390,VOL=SER=ADTW01,DCB=(BLKSIZE=1600),
// SPACE=(CYL,1)
//DFSVSAMP DD *
VSRBF=512,40
VSRBF=1024,40
VSRBF=2048,40
VSRBF=4096,40
VSRBF=8192,40
IOBF=(2048,5)
/*
//DFSCTL DD *
SBPARM ACTIV=COND
/*
//DATAIN DD DISP=SHR,DSNAME=you_data_source
//DR1E DD DSN=DELAHAY.FMN.DB.DR1E,DISP=SHR
//DR1F DD DSN=DELAHAY.FMN.DB.DR1F,DISP=SHR
//*
This process requires that the source data are in a specific IMS format.
File Export allows you to write directly into an IMS database in combination with an IMS
extraction, but the preferred way is to use an IMS intermediate data set (HD UNLOAD
format).
25.3 Merging several sources into one target
You may have different source data that you want to merge into one target. The main process
to merge data using File Export is to merge one source with an external content reference.
Attention: Check that source and target columns are compatible. File Export does not
perform any checking.

Get Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.