I have to update a columm in DB2 with temporary table.
My select work but my update give me an error: SQL0104N An unexpected token"." was found following "".
It's a sql with Toad.
Can someone help me please?
Code:
UPDATE TAOSEM_ALM.TSEM_ENTP ENTP SET (ENTP.NOM_ENTR_1 , ENTP.NOM_LEGA_MAJU_ENTR) = ( with TEMP as (SELECT a.ID_PERS_DESJ, a.NUM_PERS_DESJ_ENCO