SQL select locking a member?

[CarrieGig]

Does an embedded SQL Select statement lock a member? If so, what resolves the member lock?

[Rocky]

It does lock a member - but it's not an exclusive lock - just as opening a file (F spec in traditional RPG - DCL-F in free format RPG).

[CarrieGig]

So how do I release the lock - with a Commit? the program is setting on LR so I'm trying to figure out why the member remains locked.

[inigo.redin]

You can try defining the cursor as "WITH HOLD".

[CarrieGig]

There is no Cursor definition, its merely a SELECT statement that gets a count of records. I don't understand why the member remains locked if the program sets on LR and there is nothing else in the job stream as this is an interactive screen program call.