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

[brian_matthewsbrian matthews]

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%40h
> >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