Neoview ODBC Drivers Manual (R2.2 SP1)
Table Of Contents
- HP Neoview ODBC Drivers Manual
- Table of Contents
- About This Document
- 1 HP Neoview ODBC Driver Overview for Windows
- 2 HP Neoview ODBC Drivers Overview for Linux, HP-UX, IBM AIX®, and Sun Solaris
- 3 Installing the HP Neoview ODBC Drivers
- Installing ODBC Client Software
- Avoiding Driver-Platform Version Incompatibility
- Installing the HP Neoview ODBC Driver for Windows
- Reinstalling the HP Neoview ODBC Driver for Windows
- Uninstalling the HP Neoview ODBC Driver for Windows
- Setting Up the Client Environment
- Troubleshooting
- Getting the Version of the Driver
- ODBC API Reference
- Installing or Reinstalling HP Neoview ODBC Drivers for Linux, HP-UX, IBM AIX®, and Sun Solaris
- Setting Up the Client Environment
- Running the Sample Program
- Troubleshooting
- Debugging
- Getting the Version of the Driver
- ODBC API Reference
- 4 Configuring Client Data Sources
- 5 HP Neoview ODBC Drivers Conformance
- 6 HP Neoview ODBC Drivers Messages
- Index

Table 5-12 String Functions (continued)
SQL Equivalent FunctionODBC Function
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.
Table 5-13 Time and Date Functions
SQL Equivalent FunctionODBC Function
CURRENT_DATECURDATE, CURRENT_DATE
CURRENT_TIMECURTIME, CURRENT_TIME
DAYDAY
EXTRACTEXTRACT
Not supportedDAYNAME
Not supportedDAYOFMONTH
DAYOFWEEKDAYOFWEEK
DAYOFYEARDAYOFYEAR
HOURHOUR
MINUTEMINUTE
MONTHMONTH
MONTHNAMEMONTHNAME
Supported, but no equivalent SQL function.NOW
QUARTERQUARTER
SECONDSECOND
Not supportedTIMESTAMPADD
Not supportedTIMESTAMPDIFF
WEEKWEEK
Table 5-14 System Functions
SQL Equivalent FunctionODBC Function
Not supported in this release.DATABASE
Not supported in this release.IFNULL
USERUSER
58 HP Neoview ODBC Drivers Conformance