Re: PowerHouse 4GL question: database locking

Hi Walter,

QTP:

I agree with you on this.

QUIZ:

The only way I have found of preventing anybody from modifying the data
underneath me is to do a SET DBMODE 4 (modify allow concurrent read
(mode 6)), SET DBMODE 7 (exclusive read) or SET DBMODE 8 (read allow
concurrent read).

Mode 7 is extremely unfriendly to other users and should be avoided at
all costs.
Mode 4 gives you the same results as mode 8 but might incur some
additional database overhead.

Doing this can cause problems if everything else uses modes 1 and 5.

BTW: Did you know that version 8.49.E is now available? The main thing
you will get from doing this upgrade is the enhancement to QUIZ's report
line size. They have increased it from 264 to 32,767.

regards,

Robert W.Mills
Business Systems Development Analyst
Group Information Systems & Technology
Pinnacle Arvato
DDI: +44 (0)20 8309 3604


-----Original Message-----
From:
powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@xxxxxxxxxxxxxxxx
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@xxxxxxxxxxxxxxx
com] On Behalf Of Walter J. Murray
Sent: 05 October 2007 05:15
To: HP3000-L@xxxxxxxxxxxxx; powerh-l@xxxxxxxxxxxxxxxx
Subject: PowerHouse 4GL question: database locking

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




--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@xxxxxxxxxxxxxxxx
Subscribe: "subscribe" in message body to
powerh-l-request@xxxxxxxxxxxxxxxx
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@xxxxxxxxxxxxxxxx
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.

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

.

Relevant Pages

  • [Long] It should have been easy...
    ... My application is a Winforms one, connected to a SQL Server 2000 database; ... I created a single dialog form for adding and modifying entries in both ... tables, since the schema is the same; the form operates on a single DataRow, ... FormCompanyData form = new FormCompanyData; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Long] It should have been easy...
    ... > My application is a Winforms one, connected to a SQL Server 2000 database; ... > I created a single dialog form for adding and modifying entries in both ... > FormCompanyData form = new FormCompanyData; ... > MyApp.DataSetCustomers.CustomersRow newrow = ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Parameterization of Object Models
    ... Lock down Access to the system -- ... Attempt to prevent deadlocks see The Concepts of Database Management, ... recovery; that is, you say that you recovered the database. ... database (called a backup or a save). ...
    (comp.lang.misc)
  • Re: Limit FORM mailer submissions to 5 on website, then pause until reviewed by webmaster
    ... have a script that creates a temporary row in a sessions table as soon ... then don't display the input form and instead display the message, ... You wouldn't lock the file from the time they come to the page until ... the database occurs, ...
    (comp.lang.perl.misc)
  • Re: Running Analysis Server 2000 on seperate box
    ... On further investigation regarding the lock up problem. ... the dimension processing running and although the database rows are ... changing the service account sorted things. ... The server has both the database and Analysis Services ...
    (microsoft.public.sqlserver.olap)
Loading