title: How do I set a column value before inserting a row in Derby?
body: <p>I'm trying to create a rough emulation of Oracle's ORA_ROWSCN in my Derby database.  I'm using Derby for unit testing so that a tester doesn't have to install Oracle Express or something like that.  So I have a statement that looks like this:</p>
  
  <pre><code>CREATE TRIGGER 
  my_table_bi NO CASCADE BEFORE 
  INSERT ON my_table
  REFERENCING NEW AS NEW
  FOR EACH STATEMENT MODE DB2SQL
  NEW.ORA_ROWSCN = 1
  </code></pre>
  
  <p>I eventually want to make this more complex, but I'd like to start with making it even possible.  I get an error saying </p>
  
  <blockquote>
    <p>Syntax error: Encountered "NEW" at line 6, column 5</p>
  </blockquote>
  
  <p>What am I missing?  Is this even possible?</p>