Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
unload data from table with lob columns

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: unload data from table with lob columns
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Merge data from record pairs ashokakash DFSORT/ICETOOL 5 Wed Oct 17, 2018 11:38 am
No new posts Calling and updating SAS Macro variab... Yogesh Jaiswal All Other Mainframe Topics 2 Thu Oct 11, 2018 12:37 pm
No new posts how to use RDZ for converting cobol c... balajiChid CICS 1 Tue Oct 09, 2018 8:40 pm
No new posts Extra data in overlay field speermb DFSORT/ICETOOL 2 Thu Sep 13, 2018 6:04 pm
No new posts How to summarize data by grouping on ... santhosh5983 DFSORT/ICETOOL 6 Tue Sep 04, 2018 9:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us