• Subject: Re: File Lock Problem
  • From: "Frances Stewart" <francess@xxxxxxxxxx>
  • Date: Wed, 20 Dec 2000 09:47:41 -0600
  • Importance: Normal


That works as well. Depends on what you are used to regarding ease I
suppose. ALCOBJ OBJ(library/file *FILE *EXCL *FIRST)  should do the trick.
You need to follow up with a DLCOBJ also (whereas with interactive SQL, I
just exit the SQL session).

Actually I couldn't remember the command and so I was being lazy :-)

Frances Stewart
WebSphere Application Server for iSeries 400


"James H. H. Lampert" <jamesl@hb.quik.com>@midrange.com on 12/20/2000
08:42:00 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  Re: File Lock Problem



Frances Stewart wrote:
> . . .  One easy way to determine if a lock is a pseudo lock
> or a real lock is to attempt to get an exclusive lock on
> the object using interactive SQL specifying SQL statement
> LOCK TABLE lib/file IN EXCLUSIVE MODE.
. . .

Wouldn't an ALCOBJ be even easier?

--
James H. H. Lampert
Professional Dilettante
http://www.hb.quik.com/jamesl
Have you visited http://www.thehungersite.com today?
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.