title: db2 query to select the first row fetched
body: <p>I have a query like </p>
  
  <pre><code>UPDATE PRD_PRODUCT_L10N ppl
   SET ( CATCHING_PHRASE
      , GENERIC_NAME
      , INGREDIENTS
      , QUANTITY
      , DOSE
      , NUTRITION_FACTS
      , PRODUCT_DESCRIPTION
      , PROMOTION_MESSAGE
      , MESSAGE
     ) = (
     SELECT distinct CATCHING_PHRASE
          , GENERIC_NAME
          , INGREDIENTS
          , QUANTITY
          , DOSE
          , NUTRITION_FACTS
          , PRODUCT_DESCRIPTION
          , PROMOTION_MESSAGE
          , MESSAGE
      FROM  TEMP_UPLOAD_PRODUCT_ATTRIBUTES tupa
      INNER JOIN
            PRD_PRODUCT                    pp
        ON  pp .EISIDENTIFIER = tupa.EISIDENTIFIER
      WHERE ppl.PRODUCTGUID   = pp.GUID
        AND ppl.LOCALEGUID     = tupa.LOCALEGUID
     )
   WHERE EXISTS (
     SELECT 0
      FROM  TEMP_UPLOAD_PRODUCT_ATTRIBUTES tupa
      INNER JOIN
            PRD_PRODUCT                    pp
        ON  pp .EISIDENTIFIER = tupa.EISIDENTIFIER
      WHERE ppl.PRODUCTGUID   = pp  .GUID
        AND ppl.LOCALEGUID     = tupa.LOCALEGUID
     )     
  </code></pre>
  
  <p>the subquery returns more than 1 row and I would like to insert the first selected. How do I do that in DB2 database?</p>
  
  <p>Please advice.</p>
  
  <p>Thanks</p>