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

Error constant SQLE_BAD_RECURSIVE_COLUMN_CONVERSION
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.
Severity 16
SQLCODE –945
SQLSTATE 42WA2
Sybase error code 13543
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.