Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Post SQL Help on "Update/Fetch" needed

    I am trying to formulate a DB2 SQL query:
    Requirement. Need to pick a 100 records for a particular Column value & change the value.
    Query I need:
    "update s_contact_xm set x_suppress_reason='CM' where row_id in (Select row_id from s_contact_xm where x_suppress_reason='DD' fetch first 100 rows only)

    Suggestions/workarounds appreciated

  2. #2
    Join Date
    Feb 2004

    Re: SQL Help on "Update/Fetch" needed

    This will be entirely unhelpful to you, and I should probably send you a PM, but I have to ask where you got your nick.

    Not that I feel that I have any sort of ownership of it, but I've been using "AMUSIX" for about 15 years, and am just surprised to see someone else with the same nick. Also wondering if I should reregister my now-defunct audio production company "AMUSIX Inc."

Posting Permissions

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