Masking

UNLOAD Format

Masking using the UNLOAD format requires a sequential unload for each table, and a PDS for each XML/LOB/BLOB/CLOB column. The following JCL provides an example of the required code:

//LOADLOB JOB KRM,MSGCLASS=A,CLASS=1,NOTIFY=&SYSUID                     JOB07656
//* *******************************************
//* TABLE OWURSVIL.BIG01
//* (PDFBLO BLOB (27994))
//* (TXTCLO CLOB (16094) )
//* (PDFBLO BLOB (16032) )
//* UNIT(SYSDA) SPACE ((20,2) MB)
//* (PDFBLO VARCHAR(54) BLOBF TSYSLOB)
//* ****************************************
//STEP1 EXEC DSNUPROC,UTPROC=,SYSTEM=HADB,LIB=DSNA10.SDSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
  TEMPLATE TSYSPUN
     DSN('URADAR.&SS..&DB..PUNCH.CREDB1')
     DISP(MOD,CATLG,CATLG)
  TEMPLATE TSYSREC
     DSN('URADAR.&SS..&DB..SYSREC.CREDB1')
     DISP(MOD,CATLG,CATLG)
  TEMPLATE TSYSLOB
     DSN('URADAR.&SS..&DB..PDS.CREDB1')
     DISP(MOD,CATLG,CATLG)
     DSNTYPE(PDS)
  UNLOAD DATA FROM TABLE OWURSVIL.CREDB1 HEADER NONE
   (A     , B                  ,C      VARCHAR(54) CLOBF TSYSLOB,
    D)
  UNLDDN(TSYSREC) PUNCHDDN(TSYSPUN)
/*
//

In particular, use must include the HEADER NONE clause, and specify VARCHAR(54) for each XML/LOB/CLOB/BLOB column.

Before creating the method, be sure that you have created an output PDS via the masking routine, and that you have generated a process ID from Data Builder. When you create the method, include the input and output data set names.

DSNTIAUL Format

Masking using the DSNTIAUL format requires a sequential unload for each table. The following JCL provides an example of the required code:

//DB2UNLO  JOB (00001),URADAR,MSGCLASS=1,CLASS=1,NOTIFY=&SYSUID
//STEP0100 EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD *
 DSN SYSTEM(HADB)
 RUN  PROGRAM(DSNTIAUL) PLAN(DSNTIB10)                -
       LIB('DSNA10.DB2HAL.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD DSN=URADAR.SV41.CREDB2.NEW,
//            DISP=(NEW,CATLG,DELETE),
//            SPACE=(TRK,(24,24),RLSE)
//SYSPUNCH DD DSN=URADAR.UTILITY.SYSPUNCH(CREDB2N),DISP=SHR
//SYSIN    DD *
                   OWURSVIL.CREDB2

Before creating the method, be sure that you have generated a process ID from Data Builder. When you create the method, include the input and output data set names.