sponsored links

Collapse

Announcement

Collapse
No announcement yet.

SQL select locking a member?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL select locking a member?

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

  • #2
    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).

    Comment


    • #3
      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.

      Comment


      • #4
        You can try defining the cursor as "WITH HOLD".

        Comment


        • #5
          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.

          Comment

          Working...
          X