AS/400 SQL for two file compare and update
Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field.
UPDATE mbmtest01/wbmscur
set spdesc = itdsc
from amflib7/itemasa
where spdesc = ' ' and itnbr = spptno
Keyword FROM not expected. Valid tokens: [end-of-statement][/end-of-statement].
Software/Hardware used:
UPDATE mbmtest01/wbmscur
set spdesc = itdsc
from amflib7/itemasa
where spdesc = ' ' and itnbr = spptno
Keyword FROM not expected. Valid tokens: [end-of-statement][/end-of-statement].
Software/Hardware used:
ASKED:
April 29, 2010 9:15 PM
UPDATED:
April 30, 2010 6:39 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
I assume you found an answer for this because of your My as/400 SQL is getting a ‘ Value for column too long.’ error msg question which shows the general structure you need.
Tom
Yes. I’ve moved on to problem NO.2… Thanks all