View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 06:28 AM
Serge Rielau
 
Posts: n/a
Default Re: Timestamp equivalent in DB2

Correction:
MERGE INTO T USING (VALUES (1, 'hello', '<stamp1>), (2, 'world',
'<stamp2>')) AS S(pk, c1, tstamp)
ON T.pk = S.pk
WHEN MATCHED AND S.tstamp = T.tstamp UPDATE SET c1 = S.c1
WHEN MATCHED THEN SIGNAL SQLSTATE '38000' SET MESSAGE_TEXT = 'Row has
changed!'
ELSE SIGNAL SQLSTATE '38000' SET MESSAGE_TEXT = 'Row has been deleted!'


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Reply With Quote