Archives of the TeradataForum

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

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

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