Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 14:21:46 GMT


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


Subj:   UPSERT ERROR (5565)
 
From:   Desarrollo.ProyectoSinemax

Got error 5565 (The UPDATE specified in the UPSERT statement is a complex update...), the error explanation does not help. I think is not the case.

The UPSERT:

     UPDATE  bd_rdb.EstadoPedido
     SET     EstadoPedidoDesc = 'Pendiente'
     WHERE   EstadoPedidoCD   = 1
     ELSE
     INSERT  bd_rdb.EstadoPedido
        ( EstadoPedidoCD, EstadoPedidoDesc )
     VALUES
        ( 1, 'Pendiente' )
     ;
     *** Failure 5565 The UPDATE specified in the UPSERT statement is a complex update.
                    Statement# 1, Info =0
     *** Total elapsed time was 1 second.

The CREATE:

     CREATE SET TABLE bd_rdb.estadopedido ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           EstadoPedidoCD BYTEINT NOT NULL,
           EstadoPedidoDesc VARCHAR(60) CHARACTER SET LATIN NOT CASESPECIFIC
     NOT NULL)
     UNIQUE PRIMARY INDEX XPKEstadoPedido ( EstadoPedidoCD )
     UNIQUE INDEX (EstadoPedidoDesc);

The Release:

     VERSION 04.01.03.97
     RELEASE V2R.04.01.03.40

The problem dissapears after removing the unique secondary index.

Is this a bug, a problem or a feature ?

Help is very much appreciated,


Cesar



     
  <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