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 Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
This topic is locked: you cannot edit posts or make replies. Can a alphanumeric data be moved to a... nico_neoz COBOL Programming 10 Mon Oct 30, 2017 8:28 am

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