WHERE a.ITEM_CD = b.ITEM_CD
You copy and paste the SQL statement to a Do Select action, but it needs to be modified so that it populates the PSU_ORDERS_AET state record.
What do you need to do?
A. Change line 1 to:
%SELECT a.ORDER_LINE_NBR
B. Add this line before line 1:
INSERT INTO PS_PSU_ORDERS_AET
C. Add this line before line 1:
%SELECT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND)
D. Add this line before line 1:
%UPDATE (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND)
E. Add this line after line 7:
%INSERT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND)
|
Download Printable PDF. VALID exam to help you PASS. |
 |