I believe you have your results pane open in the lower half of the SQL window. ACS RSS never clears that pane unless you run your query again, you choose to clear that view or restart your session. When you have the results open, it will put a read lock on the data.
I have all my results produce in separate windows and I can quickly dismiss them using ESC key, especially if I notice it retaining the lock. If this does not help or I have many result windows open, a quick action to close the result windows and remove lock is to press Ctrl+F11, which restarts your connection with the same JDBC config settings you last had. If you added libraries during the closed session, you will need to add those at that time.
There are times when running a SQL statement will cause the lock to remain and when I find these I usually just use CTRL+F11 to clear and get back to where I was.
Additionally, you should consider creating multiple JDBC config setting files for the different library lists you might need. Its relatively simple to switch between them and the environment persists across restarting your environment if the RSS main window remains open. You can edit these JDBC settings files in your ACS user storage location ./IBM/iAccessClient/ folder. JDBC config files are under the RunSQLScripts folder.
-Matt
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of K Crawford
Sent: Tuesday, August 3, 2021 9:59 AM
To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
Subject: SQL NoLock
I am using ACS Run SQL Scripts to research data when errors happen, for that matter other reasons also.
I will use a simple SQL statement like
SELECT *
FROM myLib/myTable
WHERE Client = 'ABC'
This creates a lock on the object and members of the object myLib/myTable.
If I forget to disconnect or run another statement over something else.
This can create issues.
I found the WITH UR clause. I get the same results.
What can I do to run my simple SELECT without Object/Member locks?
TIA
--
KCrawford
--
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://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!rFQHNH27RrqV-0jkG4BAgpAM6pjLfkQYCfB5nSvngP8icIwaOXdL-ApGTRUV2rjBAIvZ$
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!rFQHNH27RrqV-0jkG4BAgpAM6pjLfkQYCfB5nSvngP8icIwaOXdL-ApGTRUV2mMpjVhz$ .
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!rFQHNH27RrqV-0jkG4BAgpAM6pjLfkQYCfB5nSvngP8icIwaOXdL-ApGTRUV2nU6mtQM$
midrange.com
