How to return message from DB2?   

I am running UPDATE queries and I am trying to display a message after it is successful. In DB2 command line editor a successful message shows the query that was ran and then a message below it saying: "DB20000I The SQL command completed successfully."

I would like to know how to get WPF to display a message like this if possible on a separate page. The only problem I see right now why I can't get this message is because I am using SQL Call builders and Service Operation for the all my queries. The Service Operation for the UPDATE query under the Operation Results section doesn't allow me to return results.

bosox makes a good suggestion; you can wrap your SQL Call builder with a Method that returns a status message or boolean value. Another technique that I've used in the past is to wrap your SQL statement with a SELECT clause like this:

SELECT
  COUNT(*) AS ROW_COUNT
FROM NEW TABLE (
  UPDATE
    tablename
  SET
    field=?
  WHERE
    key=?
)

This makes your UPDATE statement actually return a row count of the number of rows that were updated in the table. The "NEW TABLE" is a SQL keyword that provides a representation of subset of rows updated by the UPDATE.

Thanks for the replies. Except I have some questions about your suggestions.
1. If I were to wrap my SQL Call with a SELECT clause, where does NEW TABLE come from? Do I use it exactly like you have it typed?

2. DGawron, I have looked at the getUpdatedCount.Model before. The question I have is with the Method Builder. In the method builder you have several arguments listed. Where do they come from? And as you know, I am using three update statement on three different tables. For the update count variable and text pointing to the variable, does that mean I need to create two more variables and text builders? And then wouldn't that mean I would need to create two more methods as well?

And for both of you, I am asking all this cause on my first page I have two input fields (newHostName and oldHostName) then a submit button. I am replacing the oldHostName with the newHostName and assigning the variables from the inputs and connecting them through the DataServices(If that makes sense). I also have a page2 that I created with a span tag for the updated count. So for my main(Action List) I have page1 listed. For my button builder I have another Action List that has all the Variables assigned to the inputs and listed below that are the all the Dataservices and then page2. Thats what I have so far except I can't get the updated count to display.