logo  
Google
 

DB2 SQL-Error: -344

SQLState: 42825

Short Description: THE RECURSIVE COMMON TABLE EXPRESSION HAS MISMATCHED DATA TYPES OR LENGTHS FOR COLUMN

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 executed. Programmer response: Correct the column used in the fullselects of the recursive common table expression so that the initialization column matches the iterative columns.

 <-  BACK TO INDEX