Options msglevel =i sastrace =',,,d' sastraceloc =saslog nostsuffix; will tell you what's gets passed to Netezza and how any function call will be translated. If you aren't gonna use it for calculation consider cast it to a char variable, either in a permanent view in Netezza or in a explicit SQL pass through.
... View more
