Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   How to find column is nullable or not nullable
 
From:   Parvathareddy, Vinod

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016