-344 THE RECURSIVE COMMON TABLE EXPRESSION name HAS MISMATCHED DATA TYPES OR LENGTHS OR CODE PAGE FOR COLUMN column-name

Explanation

The recursive common table expression name name has a column column-name that is referred to in the iterative fullselect of the common table expression. The data type and length are set based on the initialization fullselect for this column. The result of the expression for the column column-name in the iterative fullselect has a different data type or length that may result in failure to assign the value for the column.

System action

The statement cannot be processed.

Programmer response

Correct the column used in the fullselects of the recursive common table expression so that the initialization column matches the iterative columns.

SQLSTATE

42825