Problems in user-defined table functions

An SQL code and a few characters of an SQL error message are returned in response to either the ADMIN_TASK_LIST function or the ADMIN_TASK_STATUS function.

Symptoms

An SQL code is returned. When SQLCODE is -443, the error message cannot be read directly, because only a few characters are available.

Diagnosing the problem

Problem diagnosis and resolution depends on the SQLCODE returned.

-443: The SQLCODE of -443 indicates that an error occurred in the function. Use the message number, which is at the beginning of the truncated return string, to diagnose the problem.
Any other value: Any other SQLCODE indicates that the error is not in the function or in the administrative task scheduler. Troubleshoot the task itself.