|
|
| Author |
Message |
ggopakumar
New User
Joined: 20 Aug 2003
Posts: 2
|
|
|
|
Hi
While unloading data from DB2 tables using the utility DSNTIAUL, the allow null columns unload the Null indicator byte as well into the dataset. How do I avoid unloading the extra byte ?
For eg:- If Col1 (char (1), Allow Null ) has a Value 'A' in the table. While unloading this field the dataset will Have 'A.' My question is how do I skip the 'dot' while unloading ? Is there any function or any Parms available ?
Appreciate your help
Thanks
Regards
Gopakumar |
|
| Back to top |
|
 |
References
|
 Posted: Wed Aug 20, 2003 1:16 pm Post subject: Re: dsntiaul |
|
|
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 257
Location: USA
|
|
|
|
Hello ggopakumar,
Try using UNLOAD utility to download
It is much faster and handy.
You will find the description in any Db2 manual.
Hope this helps you.
Regards
Mayuresh Tendulkar |
|
| Back to top |
|
|
|
|
