View previous topic :: View next topic
|
Author |
Message |
Jeyanthi M
New User
Joined: 21 Mar 2008 Posts: 5 Location: India
|
|
|
|
When I try to unload from DB2 table using DSNTIAUL, I am seeing junk values before every field present in my output file.
Please let me know how it can be corrected. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Have you viewed the output file with proper copy book? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
please review Your understanding on how DSNTIAUL works,
DSNTIAUL it' s an unload/reload utility,
the garbage/junk You see is binary info embedded in the unloaded records for a subsequent ( maybe ) reload
... DSNTIAUL will, for an unload, generate also the proper control statements for reload |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi Jeyanthi M !
No junk, but internal DSNTIAUL-Informations as Enrico told.
Also:
In this format, any nullable column is followed by a 1-byte binary field containing the null indicator. If the "From" column has a null value, the null indicator field for the corresponding "To" field contains "?", otherwise it contains 0.
Any decimal field occupies the minimum number of bytes needed to represent the data as a packed decimal field.
More informations:
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.inz.doc.ug/inzurselectexp.htm
Regards, UmeySan |
|
Back to top |
|
|
Jeyanthi M
New User
Joined: 21 Mar 2008 Posts: 5 Location: India
|
|
|
|
Please let me know how can it be corrected. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
why do You want to correct something that has been properly working in this way since the origins of DB2
if the DSNTIAUL format is not suitable for Your requirements use a different tool/utility |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
Is it so hard to ignore fields you do not want? We (programmers) do this all the time. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Please let me know how can it be corrected. |
As nothing is wrong, nothing will be corrected.
What is needed is for you to come to a better understanding of what you have and dealing with this accoringly. As suggested, you might simply ignore the bits you are not interested in. I'd suggest that you do learn what these are, even though you will not use them for this requirement. |
|
Back to top |
|
|
|