Default integer values comes as '0'
Posted: Tue Jul 01, 2008 3:57 am
Hi,
I like to know how we can pass the default value as NULL if some integer column comes as NULL from source. Currently when we load value to an integer column, it get loaded with '0' if the source value comes as NULL. The only option i could see now is to check for spaces(blank) using trim function and then set the value as Null if it is blank. I want to know if there is any other way of doing it by changing some options in datastage i.e. by changing the enviromental variables...etc
Appreciate any response on this.
regards,
senthil
I like to know how we can pass the default value as NULL if some integer column comes as NULL from source. Currently when we load value to an integer column, it get loaded with '0' if the source value comes as NULL. The only option i could see now is to check for spaces(blank) using trim function and then set the value as Null if it is blank. I want to know if there is any other way of doing it by changing some options in datastage i.e. by changing the enviromental variables...etc
Appreciate any response on this.
regards,
senthil