Page 1 of 1

DB2 Unload Vs DSNTIUL

PostPosted: Tue Nov 09, 2010 8:55 pm
by p19689
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.

Re: DB2 Unload Vs DSNTIUL

PostPosted: Tue Nov 09, 2010 10:11 pm
by p19689
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 ?