Netezza Connector > Netezza ODBC SQL ELT optimization > SQL ELT functions
  

SQL ELT functions

The following table summarizes the availability of SQL ELT functions in a Netezza source or target:
Functions
SQL ELT optimization Type
ABS()
Source, Full
AVG()
Source, Full
COS()
Source, Full
COUNT()
Source, Full
DATE_COMPARE()
Source, Full
DECODE()
Source, Full
EXP()
Source, Full
IIF()
Source, Full
IN()
Source, Full
ISNULL()
Source, Full
LOWER()
Source, Full
MAX()
Source, Full
MIN()
Source, Full
POWER()
Source, Full
SIN()
Source, Full
SQRT()
Source, Full
SUM()
Source, Full
TAN()
Source, Full
TO_DECIMAL()
Source, Full
TO_FLOAT()
Source, Full
TO_INTEGER()
Source, Full
UPPER()
Source, Full