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.
Do unload multiple partitions are not consecutive in nature?
-
- New Member
- Posts: 4
- Joined: Wed Aug 20, 2014 2:57 pm
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Do unload multiple partitions are not consecutive in nat
When you say single unload is it one UNLOAD command or one output file?
zprogrammer
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Do unload multiple partitions are not consecutive in nat
Hello,
Make use of LISTDEF with partitions, like this:
This link shows some examples on LISTDEF, have a look: http://www-01.ibm.com/support/knowledge ... mples.dita
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)
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
-
- New Member
- Posts: 4
- Joined: Wed Aug 20, 2014 2:57 pm
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute