Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2012 @ 09:48:31 GMT

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

Hi Experts,

I have One requirement.

Ex: I have 4 tables.

Tab1,Tab2,Tab3,Tab4.

I want to load data from joining of tab2,3,4 to tab1.

     insert into tab1 sel tab2.*,tab3.*,tab4.* from tab2,tab3,tab4.

in tab1 I have some are not null columns, but in tab2,tab3,tab4 those are null columns.

If I am trying to insert it showing error as trying to insert null value into not null column because I have null values in one field.

In here I want to know which column exactly moving null value.

for exaple if I have 10 columns in Tab2, 9 columns have values and one column have some nulls , then I am expecting 9 are not null and 1 is null in data structure.

is it any way to find..

Thanks

Vinod

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