Help Required

[Chris Sharman]

>We are trying to help the qtp processes that only read and not update the files
>to run faster and not lock the files that are being accessed.

USE ** QUIZ **

>We have found the commands SET LOCK RECORD UPDATE and the SET FILE {filename}
>OPEN UPDATE SHARE or SET FILE {filename} OPEN READ SEMIEXCLUSIVE.

As others have said, READ/UPDATE etc describes your access, and
SHARE/SEMIEXCLUSIVE etc describes the access you're willing for others to have.
If you say SHARE, you'll pay the RMS record locking overhead. If you say
SEMIEXCLUSIVE, your QTP won't run at all if there's a Quick screen with the
file open for update.

SET LOCK: file locks are Powerhouse specific. There's a module (DALOCK.[A]OBJ)
which allows you to use Powerhouse locks in your own 3GL programs, but it's my
contention that Powerhouse locking doesn't work across multiple UIC groups.
I'd recommend EXCLUSIVE/SEMIEXCLUSIVE/SHARE as alternatives which do work
across all well-behaved VMS applications without messing with DALOCK.

Record locks are normal RMS locks. Whether these are taken depends on whether
the file is shared or not (above), not on what you tell QTP to do.

>Does anyone know the differences or the best command to use in the qtp programs
>that are for read only.

The best command to use for read only is "$ quiz", rather than QTP.
That said, if you've some reason to use QTP (eg too many output files), the
best options are:

If you have no-one updating the file (Quick, QTP, other):

set file open read [semi]exclusive ; semi to allow other readers.
This will minimise RMS locking.
I'll risk disagreeing with Bob: I don't think this gets you write access, it
just denies it to others.

If others are updating:

set file open read share

Quiz would definitely win in the first case though, and win hugely in the
second. Time for you to embark on an education program, I think.

Regards,
Chris Sharman
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.