Re: Row Change Timestamp

[rob@xxxxxxxxx]

I do stand corrected.  That other thread led me astray, or I read it 
wrong.
This table:
CREATE TABLE ROB/RAULDATE 
(MODDATE TIMESTAMP NOT NULL for each row on update
as row change timestamp, 
 crtuser char (18) with default USER, 
 MYDATA CHAR (5 ) NOT NULL) 
RCDFMT RAULDATER 


with three rows inserted, A, B, C 

with this program (caution, cycle!!);
FRAULDATE  UP   E             DISK
 /free 
  select; 
  when mydata='A'; 
    mydata='D'; 
  when mydata='B'; 
    mydata='E'; 
  when mydata='C'; 
    mydata='F'; 
  when mydata='D'; 
    mydata='A'; 
  when mydata='E'; 
    mydata='B'; 
  when mydata='F'; 
    mydata='C'; 
  endsl; 
  update rauldater; 
 /end-free 

Updated the row change time stamp to the current timestamp.
If I used sql to 
UPDATE RAULDATE SET CRTUSER='PETE'
and rerun the program it does not change CRTUSER from 'PETE' to 'ROB'.
I guess that's a difference between "as row change" vs "with default".


Rob Berendt