SqlDbx
You are not logged in.
Pages: 1
Lets type and highlight the following code
MERGE INTO SLS_DTL MSTR
USING PROD_COST_HIST COST
ON( COST.DIV_NBR = MSTR.DIV_NBR
AND COST.PROD_NBR = MSTR.PROD_NBR
)
WHEN MATCHED THEN UPDATE
SET MSTR.UNIT_COST = COST.UNIT_PRICE
;
Now do the foollowing:
1. Press Ctrl+H, check "Match whole word", pick "Selection only", Find=MSTR, Replace with=TGT and click 'Replace All"
2. Click OK. You are back to the replace window.
3. Now change Find=COST,Replace with=SRC (note that "Match whole word", pick "Selection only" remains unchanged) and click 'Replace All"
3. Click OK and close window
Wow! Look what we got!
MERGE INTO SLS_DTL TGT
USING PROD_COST_HISTSRCT <==== what is this?
ON( SRC.DIV_NBR = TGT.DIV_NBR
AND SRC.PROD_NBR = TGT.PROD_NBR
)
WHEN MATCHED THEN UPDATE
SET TGT.UNIT_COST =SRCT.UNIT_PRICE <========= and this?
;
I tried it several times with the same result
Offline
Thank you very much. This is definitely a bug.
It will be fixed in a next release
Offline
Pages: 1