Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 May 2009 @ 10:03:21 GMT


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


Subj:   SQL error 3802
 
From:   Padarthi, Hanumath

All,

Can any one help me to understand the problem in the below update statement.

     UPDATE dBname.Tp from (select tid from dbname.test where tst_id=420) as b
     SET       DELETE_IND = 'D',
               JOB_IND = null
     WHERE dbname.tp.TID = b.tid;

     3802: Database 'DEV' doesn't exist.

Regards,

Kumar



     
  <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