NaN and Inf Values

“NaN” and “Inf” are special values that the IEEE754/854 floating point number standards use to represent values that are “not a number” and “infinity,” respectively.

In accordance with the ANSI SQL92 standard, the SAP ASE server does not allow the insertion of these values in the database and do not allow them to be generated. In SAP ASE versions earlier than 12.5, Open Client clients such as native-mode bcp, JDBC, and ODBC could occasionally force these values into tables.

If you encounter a NaN or an Inf value in the database, contact Sybase Customer Support with details of how to reproduce the problem.