DB2 Unload Vs DSNTIUL
Posted:
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
Posted:
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 ?