ODBC Server Reference Manual

Introduction
HP NonStop ODBC Server Reference Manual—429151-002
1-10
Supported and Unsupported SQL Server Features
Table 1-7. NonStop ODBC Server Support of SQL Server Features (page 1 of 4)
Feature
Description of NonStop ODBC
Server Support More Information
Aggregate
functions
All aggregate functions are supported. Aggregates
on page 4-31
Alias usernames Alias usernames are supported. ADD ALIAS
on page 7-42
COMPUTE BY
clause
Not supported SELECT
on page 4-82
Database names Database names are logical 60-
character identifiers. They have a
default format of:
node_volume_subvolume
For example:
test_vol3_persnl
The logical database name maps to a
Guardian node, volume, and
subvolume and must follow Guardian
naming rules.
Names
on page 4-5
Data types The following data types are
supported:
BIT
CHAR
DATETIME
FLOAT
INT
MONEY
SMALLINT
SYSNAME
TEXT
TINYINT
VARCHAR
Data Types
on page 4-12
Dateparts The following dateparts are supported:
year
month
day
hour
minute
second
millisecond
Data Types
on page 4-12