MaxDB SAP SQL Missing keyword WITH on update

Asked Dec 05 '22 at 17:16

Active Dec 06 '22 at 18:20

Viewed 62 times

Hi there I'm using MaxDB and trying to update a table and I get the error Missing keyword:WITH. Code: -5015.

Here is my SQL:

UPDATE agm
SET agm_confirm_stat = 'C',
    agm_confirm_usr = 'MEDICWARE',
    agm_confirm_obs = 'Wellon: Confirmado',
    agm_obs = NVL(agm_obs, '') || '\/\/Wellon: Confirmar',
    agm_confirm_dthr = TIMESTAMP
WHERE (agm_pac = '319900')
    AND (
        agm_obs NOT LIKE '%Wellon: Confirmar%'
        OR agm_obs IS NULL
    )
    AND (agm_str_cod = 'FBC')
    AND (agm_hini = '2022-12-07 08:00:00')
    AND (agm_confirm_stat != 'C')
    AND (agm_stat = 'A')

edited Dec 06 '22 at 18:20

Sandra Rossi

11,934
5
22
48

asked Dec 05 '22 at 17:16

Nathan

Use better indentation, at least use sql beautifier. – Necati Turan Dec 05 '22 at 17:20
Maybe a missing semicolon before or after the statement? Is NVL a valid function with MaxDB? – Sandra Rossi Dec 06 '22 at 18:37

MaxDB SAP SQL Missing keyword WITH on update

0 Answers0