ODBC Server Reference Manual

Introduction
HP NonStop ODBC Server Reference Manual—429151-002
1-8
Supported and Unsupported ODBC Features
The NonStop ODBC Server supports all of the core-level statements (CORE SQL) and
most of the extended syntax. Tabl e 1-6 summarizes the ODBC SQL features and
indicates whether the NonStop ODBC Server supports the feature and where to find
further information on the feature. For a complete list of NonStop ODBC Server
support, see Appendix A, Summary of Support for ODBC Features.
Table 1-6. NonStop ODBC Server Support of ODBC Features (page 1 of 2)
Feature
Description of NonStop ODBC Server
Support More Information
Aggregate
functions
All aggregate functions are supported. Aggregates
on page 3-27
Database names Database names are not defined in ODBC
CORE SQL, but the NonStop ODBC
Server supports object references of the
format database.owner.object. A database
name is a user-defined name, up to 60
characters long; the NonStop ODBC
Server maps it internally to a NonStop
SQL/MP Catalog (disk subvolume).
Names
on page 3-3
Data types All CORE SQL data types, at both Core
level and Extended level, are supported.
Data Types
on page 3-8
Expressions and
operators
All CORE SQL operators are supported in
expressions.
Expressions and
Operators on page 3-25
Functions The following functions are supported:
UCASE (Text function)
EXP
MOD (Numeric functions)
PI
CURDATE
CURTIME
DAYOFMONTH
DAYOFWEEK
HOUR (Datetime functions)
MINUTE
MONTH
NOW
SECOND
YEAR
DATABASE (System functions)
USER
CONVERT (Explicit data conversion)
Functions
on page 3-14