Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


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..



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020