[DERBY-1953] Make FOR EACH clause and MODE DB2SQL in CREATE TRIGGER statement optional

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6, 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Documentation, SQL
• Environment: Any
• Assignee: Yip Ng
• Reporter: Yip Ng
• Created: 10/Oct/06 17:22
• Updated: 13/Dec/07 09:05
• Resolved: 12/Nov/06 16:10

Description

According to SQL:2003 standard, section 11.39 <trigger definition>, under Syntax Rules item 8:

If neither FOR EACH ROW nor FOR EACH STATEMENT is specified, then FOR EACH STATEMENT is implicit.

[ FOR EACH

{ ROW | STATEMENT }

]

Issue Links

• incorporates: DERBY-1770 Make "mode db2sql" an optional phrase in the "create trigger" statement