SQL0104N An unexpected token"." was found following "".

[vmiklask]

Hi,
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?

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 
  FROM  TAOSEM_ALM.TSEM_CORR_ID_PDSJ a,
       (SELECT NUM_PERS_DESJ_ENCO,
               MAX (DAT_FIN_EFFE_ENRG) AS DAT_FIN_EFFE_ENRG
          FROM  TAOSEM_ALM.TSEM_CORR_ID_PDSJ
         WHERE ID_PERS_DESJ >= 0
        GROUP BY NUM_PERS_DESJ_ENCO) b
WHERE     a.NUM_PERS_DESJ_ENCO = b.NUM_PERS_DESJ_ENCO
            AND a.DAT_FIN_EFFE_ENRG = b.DAT_FIN_EFFE_ENRG )
SELECT rtrim(T1.NOM_ENTR_1) ||' '|| T2.NUM_PERS_DESJ,  rtrim(T1.NOM_LEGA_MAJU_ENTR) ||' '|| T2.NUM_PERS_DESJ 
FROM   TAOSEM_ALM.TSEM_ENTP T1
LEFT JOIN (SELECT temp.ID_PERS_DESJ, temp.NUM_PERS_DESJ_ENCO , h.NUM_PERS_DESJ from TEMP
            LEFT JOIN  TAOSEM_ALM.TSEM_CORR_ENCO_PDSJ h 
            on  temp.NUM_PERS_DESJ_ENCO = h.NUM_PERS_DESJ_ENCO)  T2
           on T1.ID_PERS_DESJ = T2.ID_PERS_DESJ
)  
WHERE ENTP.ID_PERS_DESJ = T1.ID_PERS_DESJ;

[db2dbahash]

This error signifies that this is syntax error , could you please check your code once to ensure that there is no syntax error. If there is no error then could you paste complete error you are getting