Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
SQLCode -344
Causa
THE RECURSIVE COMMON TABLE EXPRESSION name HAS MISMATCHED DATA TYPES OR LENGTHS OR CODE PAGE FOR COLUMN column-name.
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.
Ação do sistema
The statement cannot be processed.
Resposta ao Desenvolvedor
Correct the column used in the fullselects of the recursive common table expression so that the initialization column matches the iterative columns.
