Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2012 @ 12:40:29 GMT


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


Subj:   How to find data type and nullability
 
From:   Parvathareddy, Vinod

Hi Experts,

I have a table with 200 columns , in that some columns are nullable and some are not nullable, when I am trying to inserting a values using select statement its giving an error as source coming as null and target is not nullable column.

Is there any way to find in which column is coming as null.

Ex:

     insert into table
     sel table1.*,table2.*
        from table1 left outer join table2

I want to know select query null and not null columns depending on data.

If data have all values in that time I am expecting all are not null columns in select query .

If data have some null values in that time I am expecting that columns are null .

Is there any show definition ?


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