The LENGTH() function

In Informix®, the LENGTH() function counts the number of bytes of a string expression by ignoring the trailing blanks.

Netezza® supports LENGTH() and CHARACTER_LENGTH() functions, but these count the number of characters (not bytes), and trailing blanks are significant.

Netezza returns NULL if the LENGTH() parameter is NULL. Informix returns zero instead.

Solution

The Netezza database interface cannot simulate the behavior of the Informix LENGTH() SQL function. Review the program logic and make sure you do not pass NULL values to the LENGTH() SQL function.