Abnormal termination of an external user-defined function

If an external user-defined function abnormally terminates, your program receives SQLCODE -430 for invoking the statement.

DB2® also performs the following actions:

• Places the unit of work that contains the invoking statement in a must-rollback state.
• Stops the user-defined function, and subsequent calls fail, in either of the following situations:
  • The number of abnormal terminations equals the STOP AFTER n FAILURES value for the user-defined function.
  • If the STOP AFTER n FAILURES option is not specified, the number of abnormal terminations equals the default MAX ABEND COUNT value for the subsystem.

You should include code in your program to check for a user-defined function abend and to roll back the unit of work that contains the user-defined function invocation.