DB2 tables using the utility DSNTIAUL- Null Indicator Handle

contact4me · New User Joined: 02 Jun 2006 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

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

1. If your are using Unload file for further processing in yout job stream, then you can use SYNCSORT utility to remove the dots in your unload file.
2. if the number of columns are less, then in the select statement you can use COALESCE function for nullable columns.
3. if BMC is supported in your installation, then go in for BMC unload which supports replacemt of null value. while unloading you can just say ' IF NULL VALUE( whetever in single quotes)