ODBC Server Reference Manual

Introduction
HP NonStop ODBC Server Reference Manual—429151-002
1-9
Supported and Unsupported SQL Server Features
Supported and Unsupported SQL Server Features
Not all SQL Server features are supported by the NonStop ODBC Server. Table 1-7
summarizes SQL Server 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 B, Summary of Support
for SQL Server Features.
Names The following types of names follow ODBC
naming rules:
column name
correlation name
database name
index name
procedure name
table name
username
view name
All names have special considerations.
Database names
on
page 1-8
Usernames
in this table
Names
on page 3-3
Usernames Usernames are supported as qualifiers to
table/view/index names. A username is a
user-defined name up to 60 characters
long.
Names
on page 3-3
CORE SQL
statements
Data Definition Language (DDL)
statements, such as CREATE TABLE and
DROP INDEX, are supported.
Data Manipulation Language (DML)
statements, such as SELECT and
UPDATE, are supported.
The CALL statement, for execution of
stored procedures, is supported.
GRANT and REVOKE statements are
recognized, but their actions are not
performed.
Section 3, CORE SQL
Language
Stored
procedures
Execution of stored procedures is
supported, but the procedures must be
created in the Pathway environment.
Section 5, Stored
Procedures
Table 1-6. NonStop ODBC Server Support of ODBC Features (page 2 of 2)
Feature
Description of NonStop ODBC Server
Support More Information