Help Required
Edis, Bob
bob.edis@fleetpride.com
Thu, 26 Apr 2001 11:46:53 -0500
Hmmmm, interesting. Just how many people on this list actually HAVE worked
on Accubanc code? (I did too!) :)
Blue
-----Original Message-----
From: Witkopp, Richard [mailto:Richard.Witkopp@idt.com]
Sent: Thursday, April 26, 2001 11:34 AM
To: powerh-l@lists.swau.edu
Subject: RE: Help Required
Powerhouse is still popular in England, so there are quite
a few English on the list. You have to make allowances. :-)
(Keeping head low because he wrote some of that old, nasty
Accubanc code.)
> I thought this was to assist users in clarification of
> understanding and
> assistance with the powerhouse language not to put down the
> person submitting
> the question. Your statement of "Time for you to embark on
> an education
> program, I think." was NOT appropriate, "I think" and you
> must be a very rude
> person.
>
> The statement was that the program was already written and we
> are not ready for
> a complete re-write. You need to completely read the
> questions, before
> answering in the manner that you did.
>
> thank you for your input but not your personal comments
> Margaret Johns
>
>
>
>
>
> Chris Sharman <Chris.Sharman@ccagroup.co.uk> on 04/26/2001 03:10:07 AM
>
> To: Margaret Johns/Contractor/Dallas/AccuBanc@Accubanc
> cc: Chris.Sharman@ccagroup.co.uk, powerh-l@lists.swau.edu
>
> Subject: RE: Help Required
>
>
>
>
>
> >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.
>
> USE ** QUIZ **
>
> >We have found the commands SET LOCK RECORD UPDATE and the
> SET FILE {filename}
> >OPEN UPDATE SHARE or SET FILE {filename} OPEN READ SEMIEXCLUSIVE.
>
> As others have said, READ/UPDATE etc describes your access, and
> SHARE/SEMIEXCLUSIVE etc describes the access you're willing
> for others to have.
> If you say SHARE, you'll pay the RMS record locking overhead.
> If you say
> SEMIEXCLUSIVE, your QTP won't run at all if there's a Quick
> screen with the
> file open for update.
>
> SET LOCK: file locks are Powerhouse specific. There's a
> module (DALOCK.[A]OBJ)
> which allows you to use Powerhouse locks in your own 3GL
> programs, but it's my
> contention that Powerhouse locking doesn't work across
> multiple UIC groups.
> I'd recommend EXCLUSIVE/SEMIEXCLUSIVE/SHARE as alternatives
> which do work
> across all well-behaved VMS applications without messing with DALOCK.
>
> Record locks are normal RMS locks. Whether these are taken
> depends on whether
> the file is shared or not (above), not on what you tell QTP to do.
>
> >Does anyone know the differences or the best command to use
> in the qtp programs
> >that are for read only.
>
> The best command to use for read only is "$ quiz", rather than QTP.
> That said, if you've some reason to use QTP (eg too many
> output files), the
> best options are:
>
> If you have no-one updating the file (Quick, QTP, other):
>
> set file open read [semi]exclusive ; semi to allow other readers.
> This will minimise RMS locking.
> I'll risk disagreeing with Bob: I don't think this gets you
> write access, it
> just denies it to others.
>
> If others are updating:
>
> set file open read share
>
> Quiz would definitely win in the first case though, and win
> hugely in the
> second. Time for you to embark on an education program, I think.
>
> Regards,
> Chris Sharman
> ______________________________________________________________
> _________
> Chris.Sharman@CCAgroup.co.uk http://www.ccagroup.co.uk/
> CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
>
>
> --------------------------------------------------------------
> ---------
>
> Any views expressed in this message are those of the sender and not
> necessarily those of CCA Group. The unauthorized use, disclosure,
> copying or alteration of this message is forbidden. The contents of
> this message may be confidential and/or privileged, copyright
> CCA Group
> and are intended solely for the use of the individual or
> entity to whom
> they are addressed. Whilst this message has been scanned, CCA Group
> cannot guarantee that it is virus free or compatible with your systems
> and accepts no responsibility for any loss or damage arising from its
> use. The recipient is advised to run their own anti-virus software. If
> you receive this message in error please contact
> postmaster@ccagroup.co.uk immediately, destroy any copies and
> delete it
> from your computer systems.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>
>
>
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.