Skip to Content
0
Former Member
Oct 18, 2005 at 04:09 PM

Problem with DELETE....WHERE

20 Views

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