Hello,
we try to update one line in virtual table:
METHOD update_data_dup_vis_sum
BY DATABASE PROCEDURE
FOR HDB
LANGUAGE SQLSCRIPT.
UPDATE "STG"."CF_TABLE"
SET "Current_Ind" = :iv_current_ind
WHERE x = :iv_x
AND y = :iv_y;
endmethod.In SAP - ABAP we call this method multiple times inside LOOP.
We get dump: CX_AMDP_EXECUTION_FAILED
Is there any why to avoid deadlock on update? maybe with HINT{for sql server}?
Can we lock only one row in the table? or cancel the table lock?
- SAP Managed Tags:
Accepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 79 | |
| 9 | |
| 9 | |
| 7 | |
| 7 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.