I got this update
update FILE1 set FLD100 = substring(FLD100, 1 , 42) ||
COALESCE( (SELECT max(DATE) FROM FILE2 WHERE
FLD10=10) , (SELECT max(DATE) FROM FILE3 WHERE
FLD20=10)) , '20240426' ) where FLD30 = 10
I want this intrucion to return the value of the update, the FLD100
I try with the select from final table, i go the error: Keyword UPDATE not expected. Valid tokens: INSERT
Any thoughts?
update FILE1 set FLD100 = substring(FLD100, 1 , 42) ||
COALESCE( (SELECT max(DATE) FROM FILE2 WHERE
FLD10=10) , (SELECT max(DATE) FROM FILE3 WHERE
FLD20=10)) , '20240426' ) where FLD30 = 10
I want this intrucion to return the value of the update, the FLD100
I try with the select from final table, i go the error: Keyword UPDATE not expected. Valid tokens: INSERT
Any thoughts?
Comment