04-07-2015 01:13 PM
my criteria is to update the existing record if it exists in the cumulative dataset else if it is new record then it needs to be added to the cumulative dataset. The cumulative data contains history data .
I tried the below but it didnt work. Any other suggestions-
update adhoc.dly_cumulative adhoc.dly_&day0
04-07-2015 01:18 PM
ERROR 411-185: The UPDATE statement requires two data sets, too many data sets have been specified.
This is the error i am getting when trying to execute the above.
04-07-2015 01:21 PM
Post your full log then. My *guess* is that your macro variable is resolving with spaces so the update statement see's 3 datasets?
04-07-2015 02:05 PM
It looks like you need to add a semicolon at the end of the UPDATE statement. The software thinks BY and COLUMN are names of additional data sets.