dsntiaul

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

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 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