Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    80

    Unanswered: Update within insert

    Hi ,

    Would it be possible to write an update query within insert???

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by ahmedwaseem2000
    Would it be possible to write an update query within insert?
    No; but maybe you can achieve what you want by creating an "after update" trigger.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What exactly do you try to do? Maybe the MERGE statement is what would suit you best.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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