dump in delete data to server

[Former Member]

hello

i tried to delete data from the server

like the following:

COMMIT

EXEC SQL.

ENDEXEC.

DELETE FROM OrderedSuppliedReport@MobideoGlidot

ENDEXEC.

i have problem if i don't write correct the name of the server the program dump

how can i catch the expression and that the program will not dump

thanks

[Former Member]

COMMIT
EXEC SQL.
ENDEXEC.
DELETE FROM OrderedSuppliedReport@MobideoGlidot
ENDEXEC.
if sy-subrc <> 0.
message..
endif.

[Former Member]

Hi Yossi,

You can modify something like this...

Regards,

Raj

EXEC SQL.

select * FROM OrderedSuppliedReport@MobideoGlidot

ENDEXEC.

if sy-subrc = 0.

EXEC SQL.

DELETE FROM OrderedSuppliedReport@MobideoGlidot

ENDEXEC.

ENDIF.