On Monday, June 7, 2004, at 03:25 PM, Daniel Rail wrote:

> Hello David,
>
> Monday, June 7, 2004, 6:29:08 PM, you wrote:
>
>> judging by what chain seems to mean with other dbs,
>
>> + chain means immediately start a new transaction
>> - chain means start autocommit.
>
>> I could be wrong here...
>
>> I'd also be surprised if sql 2003 has a concept of "retaining"
>
> Here's what is the definition associated with AND CHAIN, in SQL-2003:
>
> [start quote...]
> 9) The current SQL-transaction is terminated. If AND CHAIN was
> specified, then a new SQL-transaction is initiated with the same
> access mode, isolation level, and diagnostics area limit as the
> SQL-transaction just terminated. Any branch transactions of the
> SQL-transaction are initiated with the same access mode, isolation
> level, and diagnostics area limit as the corresponding branch of the
> SQL-transaction just terminated.
> [...end quote]
>
> If AND CHAIN or AND NO CHAIN is specified then AND NO CHAIN is
> implicit.
>
> Don't you think that AND CHAIN is quite similar to RETAINING?

Not at all. I believe the idea is that after COMMIT AND CHAIN, you see
all updates of other transactions committed before your commit. I
think the purpose is to avoid requiring an immediate BEGIN TRANSACTION
call. However, I don't know exactly what they mean by access mode or
diagnostics area limit

david jencks


Best regards,

> Daniel Rail
> Senior Software Developer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>