IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

unload data from table with lob columns


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Sat Apr 22, 2017 1:32 pm
Reply with quote

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
Back to top
View user's profile Send private message
manoj_bhaskaran

New User


Joined: 05 Dec 2016
Posts: 4
Location: India

PostPosted: Wed Jun 07, 2017 3:01 am
Reply with quote

You could use spanned unloads and everything would come in a single dataset (provided you are on DB2 10 or higher).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Remote Unload of CLOB Columns DB2 6
Search our Forums:

Back to Top