Update in table.

[ronaldo_aparecido]

Hi masters.

I am a ABAP programmer and in ecc6.0  we use the oracle in SAP.

I have a question:

I have a program works in Job .

This program has update of datafield of table , i use the command modify.

But in some cases dont´t work and the data is not updated to table.

I think :its the time of response of database?

I use one :

   CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

         EXPORTING

           wait = 'X'.

In this command it does even work.

But the performance is bad.

What i can do?

Thanks

[jimguo · Accepted solution]

Hi,

I recommend you generate SQL trace via ST05 to see which SQL takes long time and do performance tunning accordingly.

Thanks.

Jim

[Reagan]

Hello

Unfortunately the amount of information you have provided is not sufficient.

I suggest you to perform a runtime analysis of the program using Tx SE30 and also an SQL trace using the Tx ST05 to identify where exactly the problem is.

Regards

RB