Help Required

[Deskin, Bob]

I would agree with Jeff where you only want to Read. SET LOCK FILE UPDATE
tells QTP to lock around each individual update. Since you're not updating,
no locking takes place. This saves a little time. Be careful using this if
you're updating, however, because instead of locking once at the beginning
of the run, you'll lock around every update. As for the OPEN, use READ SHARE
if the file is input only. SEMIEXCLUSIVE means that any process can open for
read but only the semiexclusive process can write. This is rarely used
because another process attempting to open for write gets an error.

I don't know how much time changing these will save you. Since QTP locks
around the run by default, there's only a single lock per file anyway. They
only way to find out is to try it. Of course not locking will help you share
files.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com
(613) 738-1338 ext 4205  FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Jeff Hoffman [mailto:WoniCon@bigpond.net.au]
Sent: April 25, 2001 5:40 PM
To: powerh-l@lists.swau.edu
Subject: RE: Help Required


Margaret 

Use both, the set lock tells what & when to lock, the set file tells the
type of open required.

I personnally recommend

set lock file update
set file xxxx open read share

for HP MPE bods

set file lock update
set file xxxx open dbmode 5

Any file to be updated, I leave as default.

Jeff




At 04:23 PM 25-04-01 -0500, you wrote:
>
>
>I am running Dec Alpha powerhouse 7.10g and needing to share files.
>
>Currently previous programmers have written programs in qtp, allowing the
>default locking to stay in place.
>
>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.
>
>We have found the commands SET LOCK RECORD UPDATE and the SET FILE
{filename}
>OPEN UPDATE SHARE or SET FILE {filename} OPEN READ SEMIEXCLUSIVE.
>
>Does anyone know the differences or the best command to use in the qtp
programs
>that are for read only.
>
>
>                  _\\///_
>                 (' o-o ')
>_______________ooOo_( )_oOoo_____________________________________
>
>Margaret Johns                    Tel   : 972-982-7236
>National City Mortgage/Accubanc   Fax   : 972-982-7290
>12377 Merit Drive Suite 600       e-mail: mjohns@accubanc.com
>Dallas, TX 75251-3229
>______________oooO____Oooo______________________________________
>             (   )    (   )
>              \ (      ) /
>               \_)    (_/
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
+ Jeff Hoffman                          + e-mail: wonicon@bigpond.net.au
+
+ Director                              +
+
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\
+
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \
+
+ Woronora    NSW     2232              +   fax: +61 2 9521 3979  \_,-._*
+
+ AUSTRALIA                             +                              v
+
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.