Archives of the TeradataForum

Message Posted: Mon, 12 Sep 2005 @ 10:06:11 GMT

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

Hi,

example of 7547:

Create two tables

     CREATE SET VOLATILE TABLE TCRM6_DM3305_AUG24.VT_Visu ,NO FALLBACK ,
          CHECKSUM = DEFAULT,
          LOG
          (
           No1 DECIMAL(3,0))
     PRIMARY INDEX ( No1 )
     ON COMMIT PRESERVE ROWS;


     CREATE SET VOLATILE TABLE TCRM6_DM3305_AUG24.VT_Visu_1 ,NO FALLBACK
,
          CHECKSUM = DEFAULT,
          LOG
          (
           no1 DECIMAL(3,0),
           no2 DECIMAL(3,0))
     UNIQUE PRIMARY INDEX ( no1 ,no2 )
     ON COMMIT PRESERVE ROWS;


     select * from VT_Visu

          No1
          1
          2
          3

     select * from VT_Visu_1

          no1     no2
          3     1
          3     3
          3     2


     update vt_visu from vt_visu_1
     set no1 = vt_visu_1.no1
     where vt_visu.no1= vt_visu_1.no1

The update statement gives the error code 7547 as there are three rows in the table VT_Visu_1 for updation of single row in VT_Visu.

Vinod

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