Help on DB2 UNLOAD



IBM's flagship relational database management system

Help on DB2 UNLOAD

Postby rajas.abcdefg » Sun Aug 16, 2009 12:39 pm

Hi,

Will it be possible to unload more than one table using jCL and the output to separate files respectively.

Thanks
Raj
rajas.abcdefg
 
Posts: 38
Joined: Thu Jul 09, 2009 8:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help on DB2 UNLOAD

 

Re: Help on DB2 UNLOAD

Postby momi sabag » Mon Sep 21, 2009 11:17 am

sure it is possible
you have 2 options:
using the sample program dsntiaul which you can provide with either table names or sql statements seperated by ;
these statements will be executed and data will be unloaded to ddnames SYSREC00, SYSREC01 etc...

you can also use the unload utility with the template statement
momi sabag
 
Posts: 4
Joined: Mon Sep 21, 2009 11:11 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post