How to write native SQL for UPDATE

[Former Member]

Hi All,,

Now I need to write a native sql for updating fields in the database table.

when i write like this

 exec sql.
    UPDATE ZTAB_GLTR_DATA
       SET DOCUMENT_ID  = :w_id
     WHERE COMPANY_CODE = :fs_gltr_data-company_code and
               GLTRANID = :fs_gltr_data-gltranid and
                GLROWID = :fs_gltr_data-glrowid
  endexec.

it is working fine

now i need to update two fields for that i wrote like this

 exec sql.
    UPDATE ZTAB_GLTR_DATA
       SET DOCUMENT_ID  = :w_id, POST_DATE  = :w_date
     WHERE COMPANY_CODE = :fs_gltr_data-company_code and
               GLTRANID = :fs_gltr_data-gltranid and
                GLROWID = :fs_gltr_data-glrowid
  endexec.

which is leading to dump.

can any ony tell me how to write the code for updating two fields......

[Former Member]

Hi,

You check wheater :w_date field is having value while debugging.

Regards,

Joan

[Former Member]

Yes w_date has value