KFAA31471-E
The data types of the columns derived from the anchor member and the recursive member are different. (with list number = aa....aa, column list number = bb....bb, anchor member data type = cc....cc, recursive member data type = dd....dd) (M+J+O)
The data type and data length of the column derived from the anchor member are different from those of the column derived from the recursive member. <SQLSTATE: 427N1>
- aa....aa:
-
List number of the WITH list element that caused the error
- bb....bb:
-
List number of the derived column that caused the error
- cc....cc:
-
Data type of the derived column of the anchor member
- dd....dd:
-
Data type of the derived column of the recursive member
The following information is output for cc....cc and dd....dd:
-
INTEGER: INTEGER type
-
SMALLINT: SMALLINT type
-
DECIMAL(m,n): DECIMAL type (m indicates the precision, and n indicates scaling.)
-
DOUBLE PRECISION: DOUBLE PRECISION type
-
CHAR(n): CHAR type (n indicates the length of the character string.)
-
VARCHAR(n): VARCHAR type (n indicates the maximum length of the character string.)
-
DATE: DATE type
-
TIME(p): TIME type (p indicates the fractional seconds precision.)
-
TIMESTAMP(p): TIMESTAMP type (p indicates the fractional seconds precision.)
-
BINARY(n): BINARY type (n indicates the binary data length.)
-
VARBINARY(n): VARBINARY type (n indicates the maximum length of binary data.)
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement.