DSNH20120I E csect-name LINE line-number COL column number AN SQL TABLE FUNCTION MUST RETURN A TABLE RESULT
Explanation
An SQL function that specifies TABLE in the RETURNS clause must return a result that is a table.
- csect-name
- The name of the control section that issued the message.
- line-number and column number
- The location of the error in the source program.
System action
The statement can not be processed.
User response
Either remove the TABLE keyword from the RETURNS clause to make it a scalar function or specify a fullselect in the RETURN statement of the TABLE function body.
Severity
8 (error)