How To Write A Java Trigger

• Same method as SP

• Example: Fill a string with Java Timestamp

  
  
  CREATE TABLE test
  ( pkey INTEGER NOT NULL
  DEFAULT AUTOINCREMENT,
  dummy_column INTEGER NOT NULL
  DEFAULT 0,
  timestamp_string VARCHAR ( 100 )
  DEFAULT '',
  PRIMARY KEY ( pkey ) );

Previous slide

Next slide

Back to first slide

View graphic version

This table contains only simple Watcom SQL columns. (Note to SQL Server/ASE users: the term "timestamp" has nothing to do with the Transact SQL datatype called timestamp. In this example it is a simple string which will be filled with a date and time value).