Neoview SQL Reference Manual (R2.2)

---------- -------------- --------------- ---------- ------------------
100210 4 19020.00 2006-04-10 HUGHES
100250 4 22625.00 2006-01-23 HUGHES
101220 4 45525.00 2006-07-21 SCHNABL
200300 3 52000.00 2006-02-06 SCHAEFFER
200320 4 9195.00 2006-02-17 KARAJAN
200490 2 1065.00 2006-03-19 WEIGL
.
.
.
--- 13 row(s) selected.
Order/Num Part/Num Unit/Price Qty/Ord Part Description
---------- -------- ------------ ---------- ------------------
100210 2001 1100.00 3 GRAPHIC PRINTER,M1
100210 2403 620.00 6 DAISY PRINTER,T2
100210 244 3500.00 3 PC GOLD, 30 MB
100210 5100 150.00 10 MONITOR BW, TYPE 1
100250 6500 95.00 10 DISK CONTROLLER
100250 6301 245.00 15 GRAPHIC CARD, HR
.
.
.
--- 70 row(s) selected.
--- SQL operation complete.
For more information about using SPJ result sets, see the Neoview Guide to Stored Procedures
in Java.
• This trigger contains a CALL statement, which executes an SPJ named LOWERPRICE. An
SPJ in a trigger must not have any OUT or INOUT parameters.
CREATE TRIGGER sales.setsalesprice
AFTER UPDATE OF qty_on_hand
ON invent.partloc
FOR EACH STATEMENT
REFERENCING NEW as newqty
WHEN ( SUM(newqty.qty_on_hand) > 500 )
CALL sales.lowerprice();
For more examples, see the Neoview Guide to Stored Procedures in Java.
CALL Statement 55