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

[Deskin, Bob]

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.