Archives of the TeradataForum

Message Posted: Sun, 20 Aug 2006 @ 10:12:31 GMT

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

          > Merge into dummy_table as dt
          > Using (select 1 as col1, 'FALS' as col2 from s1_test) a1
          > On (a1.col1 = column1)
          > When matched then
          > Update set column2 = a1.col1
          > When nont matched then
          > Insert (column1, column2)
          > Values (a1.col1, a1.col2)

Anomy, you seem to be missing the mandatory WHERE clause.

     select 1 as col1, 'FALS' as col2 from s1_test

should be rewritten to something like this:

     select 1 as col1, 'FALS' as col2 from s1_test
     WHERE COL_A = valA and COL_B = valB and ... COL_N = valN,

where (COL_A, COL_B, ..., COL_N) either comprise the UPI or a USI on s1_test.

Quite a restriction. You might need to rethink the logic of your query if, for example, you did not have UPI/USI on that table.

Regards,

Victor

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