topic Re: how to catch write errors in Application Development and Automation Discussions

how to catch write errors

Former Member — Wed, 02 Apr 2008 07:47:36 GMT

Hello.

I have to write data to database tables.

I write the data like this:

insert (tabname) from TABLE <it>.

<it> is a field symbol with the table contents to write..

How can I catch errors like 'duplicate records' or ...

There will probably be a lot of errors to catch. :d

Thx.

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 08:17:12 GMT

best way is Enque (get the lock) . if you get lock successfully then you can update insert without err. & Deque after successfullt completing that operation.

This is required because otherwise you may get short dump also,

http://help.sap.com/saphelp_47x200/helpdata/en/ce/532b3a6b4f4644e10000000a11402f/frameset.htm

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 08:23:20 GMT

transaction SE11 for creating lock objects

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eea5446011d189700000e8322d00/frameset.htm

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 09:29:19 GMT

hmm.. So there isn't just a simple function like Try.. Catch in VB.net?

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 09:36:09 GMT

Hi,

we have the functionality same as try...catch in abap also.

please refer to this link

http://help.sap.com/saphelp_nw04/helpdata/en/a9/b8eef8fe9411d4b2ee0050dadfb92b/content.htm

rgds,

bharat.

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 09:42:14 GMT

THX!

Re: how to catch write errors

Former Member — Wed, 02 Apr 2008 12:59:28 GMT

it is easy task if you are updating std SAP table, because most of the cases lock will already exist.

So you can

call function enqueu_xxxx

then insert xxx

dequeue_all

**if lock does not exist, then you need to create in Se11.

e.g. for MARA table update/insert you can use existing function module

ENQUEUE_E_PDTC_MARA