farhad_evan
New User
Joined: 30 Aug 2014 Posts: 24 Location: UK
|
|
|
|
hi
I'm trying to write a job to unload data from a table with lob columns on a tape.
Code: |
//UNLD1 EXEC DSNUPROC,SYSTEM=****,
// UID='UNLDLOBT'
//SYSPUNCH DD DSN=UNLDTAP.CNTL.D170422.TSLOB1,
// SPACE=(CYL,(1,1),RLSE),
// DISP=(,CATLG,DELETE)
//SYSREC DD DSN=UNLDTAP.UNLD.D170422.TSLOB1,
// VOL=(,RETAIN,,,SER=BKPDLY),
// LABEL=(1,SL),DCB=(BLKSIZE=32K),
// DISP=(,KEEP),UNIT=TAPE
//SYSIN DD *
TEMPLATE LOBF1 DSN 'UNLDTAP.UNLD.D170422.&UQ.'
UNIT TAPE DISP (NEW,CATLG,DELETE) STACK YES TRTCH COMP UNCNT 1 VOLCNT 1
UNLOAD TABLESPACE DB1.TS1
FROM TABLE
SCH1.TB1
(
COL1 VARCHAR(40) ,
COL2 VARCHAR(255) BLOBF LOBF1 ,
COL3 TIMESTAMP EXTERNAL ,
COL4 VARCHAR(255) BLOBF LOBF1 ,
) SHRLEVEL CHANGE
|
My problem is for each data set of templates the job requests a new tape.
how can I handle all of data sets on one tape in one single step?
and how can I control labels for template's data sets ?
is there another way other than unload on DASD and then dump to tape?
thanks |
|