can someone please tell me the difference between cisam and disam.

Tue, 13 Jul 2004 09:57:42 -0400

The lock you get depends on the qualifier. LOCK RECORD locks the record
that you read, so it is less restrictive. LOCK FILE locks the file at
the time the lock is issued and so is more restrictive. Note that we use
read regardless where possible. In other words, you can read through the
lock, but you can't apply another lock. If you lock the file, the record
you're updating gets locked within the PUT verb. For the most
concurrency for control type files, use record level locking where
possible.

Bob Deskin              
Senior 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: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
brian_matthewsbrian matthews
Sent: July 13, 2004 8:35 AM
To: powerh-l@lists.sowder.com
Subject: RE: can someone please tell me the difference between cisam and
disam.

thank you Bob,

does locking before reading a record result in a complete file lock, or
is 
it only the record that is read into the buffer that is locked ?

Also, it seems that the Oracle locking problem is related to Axiant thin

clients rather than PH, or so I am now told.

Bri,

>From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
>To: "brian_matthewsbrian matthews"
><brian_matthews_bmw@hotmail.com>,<powerh-l@lists.sowder.com>
>Subject: RE: can someone please tell me the difference between cisam
and 
>disam.
>Date: Mon, 12 Jul 2004 13:50:53 -0400
>
>If you are incrementing a counter in CISAM or DISAM, you need to apply 
>the lock before the GET (which may apply the lock as you actually
>retrieve) and unlock after the PUT. This ensures that no other user can

>change the record. With a relational equivalent, you would probably 
>want a separate transaction with high isolation that you could start 
>and commit.
>
>The trick is to ensure that you isolate the record/row while you do the

>update, but not to isolate it for any longer than necessary in order 
>not to affect multi-user concurrency.
>
>Bob Deskin
>Senior 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: powerh-l-admin@lists.sowder.com 
>[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of 
>brian_matthewsbrian matthews
>Sent: July 12, 2004 1:15 PM
>To: powerh-l@lists.sowder.com
>Subject: can someone please tell me the difference between cisam and 
>disam.
>
>
>Hi list,
>
>can someone please tell me the difference between cisam and disam. We 
>have been told that we may have to use lock/unlock syntax to cisam ( or

>disam
>)
>as there can be issues with syntax like that below when accessing 
>Oracle,
>
>get recname using "val" via item
>lock recname record
>let counter=counter + 1
>let newreckey = counter
>put recname reset
>
>Has anyone else experience of this issue ?
>
>( I subscribed to this list some months ago but had to sign up again 
>today - is there a time out, as is the case with hotmail's 30 day 
>period ? )
>
>thanks Bri,
>
>
>
> >From: powerh-l-request@lists.sowder.com
> >To: brian_matthews_bmw@hotmail.com
> >Subject: Welcome to the "powerh-l" mailing list
> >Date: Mon, 12 Jul 2004 12:05:02 -0500
> >
> >Welcome to the powerh-l@lists.sowder.com mailing list!
> >
> >To post to this list, send your email to:
> >
> >   powerh-l@lists.sowder.com
> >
> >General information about the mailing list is at:
> >
> >   http://lists.sowder.com/mailman/listinfo/powerh-l
> >
> >If you ever want to unsubscribe or change your options (eg, switch to

> >or from digest mode, change your password, etc.), visit your 
> >subscription page at:
> >
> >
> >http://lists.sowder.com/mailman/options/powerh-l/brian_matthews_bmw%4
> >0h
> >otmail.com
> >
> >
> >You can also make such adjustments via email by sending a message to:
> >
> >   powerh-l-request@lists.sowder.com
> >
> >with the word `help' in the subject or body (don't include the 
> >quotes),
>
> >and you will get back a message with instructions.
> >
> >You must know your password to change your options (including 
> >changing the password, itself) or to unsubscribe.  It is:
> >
> >   oxtufi
> >
> >If you forget your password, don't worry, you will receive a monthly 
> >reminder telling you what all your lists.sowder.com mailing list 
> >passwords are, and how to unsubscribe or change your options.  There 
> >is
>
> >also a button on your options page that will email your current 
> >password to you.
> >
> >You may also have your password mailed to you automatically from the 
> >Web page noted above.
>
>_________________________________________________________________
>It's fast, it's easy and it's free. Get MSN Messenger today! 
>http://www.msn.co.uk/messenger
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: 
>powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>        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.
>

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger

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

       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. 