Unload Utility, With No Header.



IBM's flagship relational database management system

Unload Utility, With No Header.

Postby manojlives » Fri Dec 11, 2009 12:08 pm

Actually i am trying to unload multiple tablespace using LISTDEF and UNLOAD utility,
But when i do that i get HEADER(OBID) fields in the First 2 columns,

I know if we use FROM TABLE option we can specify HEADER NONE,
But is there a way because i am using LISTDEF and Unloading a entire Database.

Pls help me in this regard. :?
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility, With No Header.

 

Re: Unload Utility, With No Header.

Postby swd » Fri Dec 11, 2009 7:05 pm

We use the LISTDEF template feature of the DB2 UNLOAD, as it puts the OBID in the first 2 bytes of the unload dataset. I don't know of a way to remove this, but then I don't have a problem with it. I can unload the data and reload the data quite happily.

Is there a reason why you don't want this field there? Is it causing a problem?
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility, With No Header.

Postby manojlives » Tue Dec 15, 2009 3:16 pm

The reason i don't want these headers because,

I am unloading the data from 2 different database , but table has same structure , and compare them for changes,

But since OBID is different for both tables , all data appears to be shown as changes in compare ouptut.

I know that LISTDEF and FROM TABLE option are mutually EXCLUSIVE , and HEADER NONE goes only with FROM TABLE option,
Is it Possible to use LISTDEF and Have NO HEADER in the output?
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility, With No Header.

Postby Anuj Dhawan » Tue Jan 05, 2010 7:08 pm

You may use an intermediate step executing sort to remove what you don't want in "unloads" and then can proceed to what is needed.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post