Default integer values comes as '0'

tsktsk123 · Post by **tsktsk123** » 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

ArndW · Post by **ArndW** » Tue Jul 01, 2008 4:00 am

If your integer column is set to be NULLable then it will pass on null values correctly.

tsktsk123 · Post by **tsktsk123** » Wed Jul 02, 2008 4:55 am

ArndW wrote:If your integer column is set to be NULLable then it will pass on null values correctly. ...

thanks for your input, the issue is resolved.