Not clear on what 'failure' means in the test manager. Is it just a test of expected value versus returned value, or does coding and throwing an exception also turn the test red? Does it report the SQLCODE for the exception?

There are certainly tests that should cause a proc/func to fail because that is the expected behavior given the inputs.

Some realistic examples might be very helpful. The user guide section is a bit thin on this topic.

A test item will be marked as "failed" if one or more variables do not have the specified output value, or if an exception occurs. In both cases the "Run" page will report the exact condition and message.

See also chapter 21.15 in the User's Guide for a detailed explanation and examples.

thank you