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 ?
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)