QUIZ is intended as a read-regardless type report writer. Most
generalized report writers don't lock. As well, the locking approach
PowerHouse uses allows reads through a lock. So if QTP has something
locked, QUIZ can read through it, because it doesn't lock. If you need
exclusive access, change the locking mechanism or extract to a subfile
as Ken suggests.
Bob
Bob Deskin
Senior Product Manager
Application Development Tools
Cognos Incorporated
+1 613-738-1338 ext 7268
[log in to unmask]
http://powerhouse.cognos.com
-----Original Message-----
From: [log in to unmask]
[mailto:[log in to unmask]] On
Behalf Of Ken Langendock
Sent: October 5, 2007 7:41 am
To: 'Walter J. Murray'; [log in to unmask];
[log in to unmask]
Subject: RE: PowerHouse 4GL question: database locking
Walter, If locking is an issue for you, use the method I have been
promoting
all along.
Use QTP to extract everything. You can control individual files with
locking/output phase reading, etc.
Use QUIZ to only report the contents of the subfile. IMHO, QUIZ is dumb,
this is all it is good for.
I can't stand it when I have one simple error in QUIZ and every single
line
from that point on shows up as an error. DUMB!
If you structure your extracts properly you can produce very fast
extracts.
Ken
-----Original Message-----
From: [log in to unmask]
[mailto:[log in to unmask]] On
Behalf Of Robert Mills
Sent: October 5, 2007 4:48 AM
To: Walter J. Murray; [log in to unmask]; [log in to unmask]
Subject: 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:
[log in to unmask]
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@lists.sowder..
com] On Behalf Of Walter J. Murray
Sent: 05 October 2007 05:15
To: [log in to unmask]; [log in to unmask]
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:
[log in to unmask]
Subscribe: "subscribe" in message body to
[log in to unmask]
Unsubscribe: "unsubscribe <password>" in message body to
[log in to unmask]
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
[log in to unmask]
Subscribe: "subscribe" in message body to
[log in to unmask]
Unsubscribe: "unsubscribe <password>" in message body to
[log in to unmask]
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: [log in to unmask]
Subscribe: "subscribe" in message body to
[log in to unmask]
Unsubscribe: "unsubscribe <password>" in message body to
[log in to unmask]
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.
This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
