ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index
ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-9
SQL Scalar Functions
LOCATE
LOCATE (ODBC LOCATE start parameter is not supported.)
LTRIM
TRIM...LEADING
REPEAT
REPEAT
REPLACE
REPLACE
RIGHT
RIGHT
RTRIM
TRIM...TRAILING
SOUNDEX
Not supported
SPACE
SPACE
SUBSTRING
SUBSTRING
UCASE
UPPER | UPSHIFT
Note. ODBC string functions in queries can return unexpected results for fixed-length
(CHAR) column names, because SQL/MX pads 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/MX
to trim the extra blanks from the column names.
Table 5-13. Time and Date Functions (page 1 of 2)
ODBC Function SQL/MX Equivalent Function
CURDATE, CURRENT_DATE CURRENT_DATE
CURTIME, CURRENT_TIME CURRENT_TIME
DAY DAY
EXTRACT EXTRACT
DAYNAME Not supported
DAYOFMONTH Not supported
DAYOFWEEK DAYOFWEEK
DAYOFYEAR DAYOFYEAR
HOUR HOUR
MINUTE MINUTE
MONTH MONTH
MONTHNAME MONTHNAME
NOW
Supported, but no equivalent SQL/MX function.
QUARTER QUARTER
SECOND SECOND
Table 5-12. String Functions (page2of2)
ODBC Function SQL/MX Equivalent Function