Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS)

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.