The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL.
You used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record.
You added a SQL action to update PS_PSU_STOCK_TBL using the values in the state record.
Which code would you use in the SQL action?
A. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %1 – %2
WHERE ITEM_CD = %3
(QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
B. %UPDATE (QTY_ON_HAND)
SELECT QTY_ON_HAND – QTY_ORDERED
FROM PS_PSU_STOCK_TBL
WHERE ITEM_CD = %Bind(ITEM_CD)
C. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %Bind(QTY_ON_HAND) – %Bind(QTY_ORDERED)
WHERE ITEM_CD = %Bind(ITEM_CD)
D. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = Bind(QTY_ON_HAND) – Bind(QTY_ORDERED)
WHERE ITEM_CD = Bind(ITEM_CD)
E. %UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %QTY_ON_HAND – %QTY_ORDERED)
WHERE ITEM_CD = %ITEM_CD
|
Download Printable PDF. VALID exam to help you PASS. |
 |