Archives of the TeradataForum
Message Posted: Wed, 24 Oct 2012 @ 09:48:31 GMT
I have One requirement.
Ex: I have 4 tables.
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..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|