Re: ACS SQL locking files

Paul,

I seem to remember that in the old iSeries Nav version I had, sometimes, to
clear the diagnostic messages in order to release a lock. Strange, I know,
but it seemed to work.

HTH,

Luis


On Wed, Feb 15, 2017 at 4:49 PM Paul Therrien <
paultherrien@xxxxxxxxxxxxxxxxxx> wrote:

Just tried this now and it seemed to work, then it stopped working.
Closed all results windows and still the file remained locked.
I had to use the reconnect option (ctrl+f11) which unlocked the file.
Being a keyboard user more than a mouse clicker, the ctrl+f11 key combo
will
probably become one of my habitual combos (in the same way that ctrl+s is
in
RDI).

Paul Therrien
Andeco Software, LLC
paultherrien@xxxxxxxxxxxxxxxxxx
225-229-2491 <(225)%20229-2491>


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Timothy P Clark
Sent: Wednesday, February 15, 2017 3:10 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: ACS SQL locking files

Hi Paul,

Have you tried doing a View->Close All Results? The SQL client tends to
keep
an open cursor so that it can retrieve more records as you scroll through
the results pane. Alternately, you can close a specific results pane by
right-clicking on its tab. Or if you show results in a separate window, you
can close the entire window.

Thank you,
Tim Clark


"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 02/15/2017
12:44:57 PM:

From: "Paul Therrien" <paultherrien@xxxxxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>,

Date: 02/15/2017 12:45 PM
Subject: ACS SQL locking files
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

Has anyone else experienced files being locked by the SQL client in ACS?

If so, is there a way around this?



When I run a query, a select statement, against a file the file will
be locked by my job until I query another file or close the sql client.

This caused an issue in production this afternoon.









Paul



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link:

http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD