Page 1 of 1

Do unload multiple partitions are not consecutive in nature?

Posted: Mon Oct 27, 2014 8:46 am
by Sharath Kumar
Hello,

Can we do an unload of multiple partitions in consecutive order? As of now I have to make two separate unload for each partition. What I know is that if the partitions are consecutive then we can do it but if I need to do the unload of partition 10 and 12, can I do it with a single unload? Help please.

Re: Do unload multiple partitions are not consecutive in nat

Posted: Mon Oct 27, 2014 8:43 pm
by zprogrammer
When you say single unload is it one UNLOAD command or one output file?

Re: Do unload multiple partitions are not consecutive in nat

Posted: Tue Oct 28, 2014 9:50 am
by Anuj Dhawan
Hello,

Make use of LISTDEF with partitions, like this:

Code: Select all

LISTDEF UNLDLIST 
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(10) 
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(12)
This link shows some examples on LISTDEF, have a look: http://www-01.ibm.com/support/knowledge ... mples.dita

Re: Do unload multiple partitions are not consecutive in nature?

Posted: Fri Nov 20, 2020 11:09 am
by Sharath Kumar
Thank you Anuj.