Start of change

-20148   A RETURN STATEMENT DOES NOT EXIST OR WAS NOT INVOKED DURING THE EXECUTION OF ROUTINE routine-name WITH SPECIFIC NAME specific-name.

Explanation

The SQL function must contain at least one RETURN statement and a RETURN statement must be processed when the function is invoked.

routine-name
The name of the routine
specific-name
The specific function name, which is unique within the schema

System action

The statement cannot be processed.

User response

Ensure that a RETURN statement is executed when the function is invoked.

SQLSTATE

429BD

End of change