Neoview ODBC Drivers Manual (R2.5)

Table 7-11 Numeric Functions (continued)
SQL Equivalent FunctionODBC Function
POWERPOWER
RADIANSRADIANS
RANDRAND
Not supported in this release.ROUND
SIGNSIGN
SINSIN
SINHSINH
SQRTSQRT
TANTAN
TANHTANH
Not supported in this release.TRUNCATE
Table 7-12 String Functions
SQL Equivalent FunctionODBC Function
ASCIIASCII
CHARCHAR
CONCATCONCAT
Not supportedDIFFERENCE
INSERTINSERT
LOWERLCASE
SUBSTRINGLEFT
Supported, but no equivalent SQL function.LENGTH
LOCATE (ODBC LOCATE start parameter is not
supported.)
LOCATE
TRIM...LEADINGLTRIM
REPEATREPEAT
REPLACEREPLACE
RIGHTRIGHT
TRIM...TRAILINGRTRIM
Not supportedSOUNDEX
SPACESPACE
SUBSTRINGSUBSTRING
UPPER | UPSHIFTUCASE
ODBC string functions in queries can return unexpected results for fixed-length (CHAR) column names, because
SQLpads a fixed-length string with blanks up to the length of the definition. Therefore, the results from some ODBC
string functions can include trailing blanks at the end of the string. Use the RTRIM function in queries to cause SQL
to trim the extra blanks from the column names.
SQL Conformance Level 69