Message Reference

Class Code 38 External Function Exception

Table 23. Class Code 38: External Function Exception

SQLSTATE Value	Meaning
38XXX	Valid error SQLSTATEs returned by a user-defined function, external procedure, or trigger.
38001	The external function is not allowed to execute SQL statements.
38002	The external function attempted to modify data, but the function was not defined as MODIFIES SQL DATA.
38003	The statement is not allowed in a function or procedure.
38004	The external function attempted to read data, but the function was not defined as READS SQL DATA.
38501	Error occurred while calling a user-defined function, external procedure, or trigger (using the SIMPLE CALL or SIMPLE CALL WITH NULLS calling convention).
38502	The external function is not allowed to execute SQL statements.
38503	A user-defined function has abnormally terminated (abend).
38504	A user-defined function has been interrupted by the user to stop a probable looping condition.
38506	Function failed with error from OLE DB provider.
38552	A function in the SYSFUN schema (supplied by IBM) has abnormally terminated. One of the following reason codes can be found in the message text: 01 Numeric value out of range 02 Division by zero 03 Arithmetic overflow or underflow 04 Invalid date format 05 Invalid time format 06 Invalid timestamp format 07 Invalid character representation of a timestamp duration 08 Invalid interval type (must be one of 1, 2, 4, 8, 16, 32, 64, 128, 256) 09 String too long 10 Length or position in string function out of range 11 Invalid character representation of a floating point number