Re: [V4R5][SQL] Lock and Unlock Tables

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Patrik,
With newer versions of SQL you could use either the QCMDEXC stored
procedure or the QCMDEXC function.  Before IBM came out with them some of
us rolled our own.
For a little history on them, check out
https://www.ibm.com/support/pages/ibm-i-services-sql

On Mon, Mar 23, 2026 at 4:38 PM Patrik Schindler via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hello,
>
> I have found that you can place an exclusive lock tables in V4R5 like this:
>
> LOCK TABLE [tablename] IN EXCLUSIVE MODE
>
> However, I was unable to find out how to remove this lock from within SQL.
> There is no UNLOCK TABLE SQL command.
>
> Any hints?
>
> :wq! PoC
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.