DB2 Unload Vs DSNTIUL



IBM's flagship relational database management system

DB2 Unload Vs DSNTIUL

Postby p19689 » Tue Nov 09, 2010 8:55 pm

When I use DB2 unload it creates extra ' à ' char on the out put file. What's the exact purpose of it. All the columns in the table are type CHAR and TIMESTMP. I have tried with DSNTIUL and the out put does not have extra special charcter as DB2 unload. Is there any anvantage using one against the other ? Thanks for the help.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Unload Vs DSNTIUL

Postby p19689 » Tue Nov 09, 2010 10:11 pm

I think I have found the answer for the part of the question. The ' à' is the output record header and use to identify the table it has been unloaded from. Three values can be used for header (OBID,NONE or CONST). If you specify a header that can be used as a selection criteria in the WHEN clause.

My other part of the question is DB2 load Vs DSNTIAUL what are the pros and cons ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post