Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Jan 2005 @ 18:09:43 GMT

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

Subj:   Re: Syntax error in trigger code
From:   Victor Sokovin

  This is the first trigger that we have tried so we may have overlooked the obvious but we get this message on the following code  

  Syntax error: expected something between the ')' and the 'WHEN' keyword.  

  If we remove the second WHEN and code following it the trigger will execute. Is there any idea as to what I have coded wrong?  

The way I read the CREATE TRIGGER syntax diagram is that only one search_condition (and, therefore, the WHERE clause) is allowed in the trigger definition. You can put all kinds of boolean logic in the condition, though, and you can have multiple DML statements (the syntax diagram shows them as a ;-separated list). If this does not work, consider defining another trigger.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023