Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2012 @ 13:57:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Vinod,

You can see all the NOT NULL columns by doing SHOW TABLE. Then once you identify the not null columns, use ZEROIFNULL(colname) for numeric columns and COALESCE(colname, ' ') for character columns.

You can also use CASE WHEN statements for specific cases but that will be a bit more resource-consuming. This will check the error you are getting.

Thanks,

Debojit.

	<Prev	Next>		<<First	<Prev	Next>	Last>>