Example 1: Signal SQLSTATE '75002' with a descriptive message text.
EXEC SQL SIGNAL SQLSTATE '75002' SET MESSAGE_TEXT = 'Customer number is not known';
Example 2: Signal SQLSTATE '75002' with a descriptive message text and associate a specific table with the error.
EXEC SQL SIGNAL SQLSTATE '75002' SET MESSAGE_TEXT = 'Customer number is not known', SCHEMA_NAME = 'CORPDATA', TABLE_NAME = 'CUSTOMER';
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.