File locking

[Maclary, David]

*** MPE/iX only ***

Hi Everyone...

I've run into a strange situation.  I tried to access a subfile in Quiz, and
got the following error message...

> ACC *EJVINPUT.EJVDAILY
*W* PowerHouse name for EJVINPUT.EJVDAILY is EJVINPUT.
*E* File error on dictionary portion of subfile.
*E* NONEXISTENT PERMANENT FILE  (FSERR 52)

The problem here, is that the file DOES exist.  Here's what I believe is
going on...(I have duplicated
this many times, just to be sure)...

1. Another process had the file open (:COPY
EJVINPUT.EJVDAILY,SAVENAME.ARCHIVE) when
I issued the > ACCESS statement.

2. The initial FOPEN used the MPE default, which is NOLOCK.

3. The ACCESS statement tried to open the file with locking enabled
(PowerHouse default), which is why
the file access failed.  The error messages are a bit misleading,
but...whatever...

I can make things "better" by doing a file equation on the copy command to
specify ;LOCK, or on the
file in the access statement, specifying ;NOLOCK.  However, this is a
quick-n-dirty solution to a much
bigger issue, and, it's not practical.  There are way too many files out
there (imagine trying to implement
this?).

I've also tried the > SET NOLOCK command in Quiz. It had no affect ;-(

Ideas? Anyone?

Thanks,
David Maclary
PowerHouse Consultant
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.