HP3000-L Archives

October 2007, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Walter J. Murray" <[log in to unmask]>
Reply To:
Walter J. Murray
Date:
Thu, 4 Oct 2007 21:14:55 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (34 lines)
Greetings,

I'm in the process of learning PowerHouse 4GL, and I'm trying to
understand how it manages database locking.

The environment is PowerHouse 8.39.C1 on MPE/iX 7.5, TurboIMAGE access
modes 1 and 5.

As I understand it, the default for QTP, whether in mode 1 or mode 5, is
to lock the whole database for the duration of the run.  The SET LOCK
statement can be used to change the locking level, or even to eliminate
locking completely (assuming the database is not being modified).
Unless locking is suppressed, interactive QTP attempts a conditional
lock every few seconds until it is satisfied or the user interrupts it;
batch mode QTP does an unconditional lock.  This is all documented in
the QTP Reference.

Please correct me if I don't have that completely right.

The question is about QUIZ.  As I understand it, the default access mode
is 5, but QUIZ doesn't do database locking.  Can this be right?  Is
there no way to make QUIZ lock the database while accessing it, as a
protection against other users modifying the same data that QUIZ is
accessing?

Thanks for bearing with my beginner's questions.

Walter  

Walter J. Murray

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2