Thanks again for your reply. That being the case I think it'd be in order some clarification to the documentation. As it is now it seems to convey some earlier releases don't allow it whyle [non early, current?] releases do. Also elimininating the parts in bold below might help: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable="">...
Thanks again for your reply. That being the case I think it'd be in orther some clarification to the documentation. As it is now it seems to convey some earlier releases don't allow it whyle [current] releases do. Also elimininating the parts in bold below might help: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable=""> ] is...
Many thanks, understood. I must be missing something tho... What's REFERENCING NEW TABLE AS ntable purpose meant to be in this context? I might be confused by the guide stating the following in the triggers chapter: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable=""> ] is used to give a name to the OLD and NEW data row or table....
I'm gettin a -5501 error (ntable not found) when trying to create atriggers like the following: CREATE TRIGGER sometrigger AFTER INSERT ON sometable REFERENCING NEW TABLE AS ntable FOR EACH STATEMENT BEGIN ATOMIC INSERT INTO someothertable (SELECT * FROM ntable); END ; So, how would I go about referencing ntable in a situation like this? Thaks in advance!
Renamed NetRexxC-3.00 tag to NetRexxC-3.00_prot...
Also removed the bootstrapping jars from the Ne...
First release made available by RexxLA at netre...
Initial RexxLA sources commit. ICU notices adde...