Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: Developer queston about DB2 transactions

    A developer recently asked me ...

    Some transacted database systems have the ability to take a handful of SQL statements, excersise them in order without checking constraints until all of the statements have been evaluated. Thus if you update a row to a row that already exists (key fields) and then delete the row that previously existed it results in an update that is not invalid. Confusing, I know. Can DB2 facilitate this kind of behavior? What is the technical term for this process?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Developer queston about DB2 transactions

    Originally posted by srp
    What is the technical term for this process?
    A lie...

    all transactions within their scope must conform to all constraints...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2002
    Posts
    134

    Re: Developer queston about DB2 transactions

    I think it can be called deffered constraint checking. And no, it's not supported by DB2. I mean after set integrity off, no inserts is allowed

    As far as I remember, you can do someting like this in Oracle

    -dmitri

  4. #4
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Yep, ORACLE allows this by validating at commit time instead of transaction time.
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blom0344
    Yep, ORACLE allows this by validating at commit time instead of transaction time.
    Really? It's not a server setting?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Brett, you were absolutely right in saying 'all transactions within their scope must conform to all constraints...' ...

    But the original question, seems to say that all SQL Statements are within the same UOW ...

    Cheers
    Sathyaram


    Originally posted by Brett Kaiser
    Really? It's not a server setting?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •