复制CREATE TRIGGER REORDER AFTER UPDATE OF ON_HAND,数据 MAX_STOCKED ON PARTS REFERENCING NEW AS N_ROW FOR EACH ROW MODE DB2SQL WHEN (N_ROW.ON_HAND <0.10 * N_ROW.MAX_STOCKED AND N_ROW.ORDER_PENDING = N) BEGIN ATOMIC VALUES(ISSUE_SHIP_REQUEST(N_ROW.MAX_STOCKED - N_ROW.ON_HAND, N_ROW.PARTNO)); UPDATE PARTS SET PARTS.ORDER_PENDING = Y WHERE PARTS.PARTNO = N_ROW.PARTNO; END 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25. |
喜欢
讨厌