View previous topic :: View next topic
|
Author |
Message |
contact4me Warnings : 1 New User
Joined: 02 Jun 2006 Posts: 2
|
|
|
|
Hi
Anyone explain how to Exclude the Null Columns while unload db2 table using DSNTIAUL utility?
Is there any way code in SELECT statement to exclude null values to unload data set?? |
|
Back to top |
|
|
Gurmeet
New User
Joined: 22 Feb 2006 Posts: 46 Location: Pune
|
|
|
|
You can do so by creating a view and exclude the null columns from the view.
~Gurmeet |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
Since DSNTIAUL supports normal select statements, you can code select statement which would exclude the nullable columns(provided you know which are the nullable columns) or else if you just want to supress the null indicators you can just use COALESCE function in SELECT. |
|
Back to top |
|
|
|