Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014
    Posts
    3

    Unanswered: How can we handle exception in DB2 9.7 using procedures?

    Hello all,

    I have a table which has columns s_id(int),s_first_name(varchar),s_last_name(varcha r),s_age(int) I need to insert the values into the tables if the table don't have any values, If table have any values then I have to update an existing value.Can any one please help me with this. Please do this by using procedures.
    Last edited by vbommana; 08-20-14 at 07:22.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Use MERGE statement.

Tags for this Thread

Posting Permissions

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