Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 22
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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us