Do unload multiple partitions are not consecutive in nature?

[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.

[zprogrammer]

When you say single unload is it one UNLOAD command or one output file?

[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

[Sharath Kumar]

Thank you Anuj.