Contents Index Recursion is not allowed without the RECURSIVE keyword Referential integrity actions other than RESTRICT not allowed for temporary tables

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

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.

Contents Index Recursion is not allowed without the RECURSIVE keyword Referential integrity actions other than RESTRICT not allowed for temporary tables