topic dump in delete data to server in Application Development and Automation Discussions

dump in delete data to server

Former Member — Tue, 13 Dec 2005 12:52:38 GMT

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 — Tue, 13 Dec 2005 12:56:39 GMT

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

Former Member — Tue, 13 Dec 2005 12:59:09 GMT

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.