You're writing a DB2 application program and the program needs to handle a piece of data without knowing if a record exist in the table for this piece of data. Enter into the picture DB2 9 for z/OS and the introduction of the SQL MERGE statement. The major database players all have some form of the MERGE statement.
