I have a very weird problem with one of my programs.
When I execute
delete in_rec_10000 where
/BIC/ektrip = total_pymts-/BIC/ektrip and
/BIC/EKPVERSON = total_pymts-/BIC/EKPVERSON and
/BIC/EKDOCUMNT = total_pymts-/BIC/EKDOCUMNT and
EMPLOYEE = total_pymts-EMPLOYEE.
the program gets stuck( I mean the work process is not released but it doesnt work on any tables or execute anything) in production but runs fine in Development and QA.
I then changed the code to
loop at in_rec_10000 where
/BIC/ektrip = total_pymts-/BIC/ektrip and
/BIC/EKPVERSON = total_pymts-/BIC/EKPVERSON and
/BIC/EKDOCUMNT = total_pymts-/BIC/EKDOCUMNT and
EMPLOYEE = total_pymts-EMPLOYEE.
move 'X' TO IN_REC_10000-DEL_FLAG.
MODIFY IN_REC_10000.
ENDLOOP.
endloop.
this still runs in development but dont know if it will work in production.
Help needed..
Thanks