Re: File Lock Problem

["Frances Stewart" <francess@xxxxxxxxxx>]

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
+---