Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Sep 2012 @ 21:16:28 GMT


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


Subj:   Update fails but select works with same
 
From:   sivaram nelluri

Hello Gurus,

I have weird problem with one of the derived columns in a where clause criteria.

If i use the derived column in the where clause criteria, update statement fails saying that " A character String Failed coversion to a numeric Value"

But the same where caluse in select query works fine.

     UPDATE 
     SET = 
     WHERE colum1=vt_del_dup_veh_revs.column1
     AND column2=vt_del_dup_veh_revs.column2
     AND vt_del_dup_veh_revs.del_ind='Y';

The above update?query Fails:

     select
     a.*, b.* from , vt_del_dup_veh_revs WHERE
     column1=vt_del_dup_veh_revs.column1
     AND column2=vt_del_dup_veh_revs.column2
     AND vt_del_dup_veh_revs.del_ind='Y'

The above select query runs fine and getting the data back.

Volatile table was created as follows:

     CREATE
     SET VOLATILE TABLE EDW_DEV_BATCH.vt_del_dup_veh_revs ,NO FALLBACK , CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO, LOG (
     column1 INTEGER,
     column2?TIMESTAMP(0),
     del_ind VARCHAR(1) CHARACTER SET UNICODE NOT CASESPECIFIC
     )
     PRIMARY
     INDEX ( column1)
     ON
     COMMIT PRESERVE ROWS;

I have the workaround for this, but my intention is to know why select is working fine but update is failing?

any information on this would be greatly appreciated.


Thanks

Siva Nelluri



     
  <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: 15 Jun 2023