Recursive column %1: conversion from '%2' to '%3' loses precision

Item Value
SQLCODE -945
Constant SQLE_BAD_RECURSIVE_COLUMN_CONVERSION
SQLSTATE 42WA2
Sybase error code 13543
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Column number of the recursive subquery.
Parameter 2 Type converted from.
Parameter 3 Type converted to.

Probable cause 

Every column in the recursive subquery must be convertible to the type of the corresponding column in the initial subquery without loss of precision. Try casting the column in the initial subquery to an appropriate type.