![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
CALL ENDMSG(message)
A string specifying the new transaction completion message. Its syntax can be C (fixed-length character string), UN (Unicode), V (variable-length character string), or W (double-byte character).
• The transaction completion message displays only if the transaction completes normally.
• The last message of multiple calls to ENDMSG within the same transaction is printed as the transaction completion message.
• If the value of message is of syntax UN and it cannot be coerced to syntax V, ENDMSG returns a Unicode literal.The CHECK_EMP rule checks the EMPLOYEES table for a particular region to see if an employee exists. If the employee does exist, the name, number, position, and city of the employee appear in the end message. If the employee does not exist, the end message informs the user.
Entering the value midwest for REGION and smith for LASTNAME results in the following end message:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |