QTP file/record locking

[Deskin, Bob]

SET LOCK RECORD UPDATE will lock around the specific update. It will not
lock the files during read. Because of the multiple locks, processing will
be slower. If you're accessing and updating the same file, you do not need
an ALIAS unless you're using the ADD option of OUTPUT. In fact, if you want
to read and update the same record, you're best not to use an ALIAS.

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

-----Original Message-----
From: Kesterson, Roger [mailto:Roger.Kesterson@mtdsw.com]
Sent: Thursday, May 17, 2001 12:31 PM
To: PowerHouse List Server (E-mail)
Subject: QTP file/record locking


PH 7.10.G2, OpenVMS 7.1

I need to run QTP to update what could be thousands of records in a
particular file during the day while other users are in the system in QUICK
and QUIZ, and I don't want to prevent them from accessing the same file for
read and write.  They will not be going after any of the records that QTP
will be updating.  If I am understanding the manual, I should be able to
accomplish this by using "SET LOCK RECORD UPDATE", and using an ALIAS on the
OUTPUT.  Is this correct?

Thanks in advance for your advice.

Roger Kesterson
Senior Programming Analyst
MTD Southwest, Inc.
550 N. 54th Street
Chandler, AZ  85226

Phone: 480-961-1002 x4357
Fax:   480-940-5035

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.