Why does SQL UPDATE not unlock record.

[K.Forsythe]

Commitment control can keep the record locked until the changes are committed. Try setting the commitment control to *NONE and see if that fixes the problem.

[JackLongCBK]

Why does SQL UPDATE not unlock record.

The only thing that I'm doing different is that all of the file IO is in a service program that is compiled to CloseSQLCursor(*ENTACTGRP) Would this prevent the record from being unlocked?

[JackLongCBK]

Why does SQL UPDATE not unlock record.

When reading a file with Fetch next on a dynamic scrollable cursor is the record still locked when update current is issued. I want it to be like RPGLE so that when I update the record format it is unlocked and another job has access to it.

[K.Forsythe]

Why does SQL UPDATE not unlock record.

I don't think that is the problem. If you can, email me the code and the compile statements at Kevin.forsythe@dmcconsulting.com, and I'll take a look. Kevin