ODBC Server Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

551

552

553

554

555

556

557

558

559

560

Summary of Support for SQL Server Features

HP NonStop ODBC Server Reference Manual—429151-002

B-7

Functions

LTRIM – –

REPLICATE – –

RIGHT – –

RTRIM – –

SOUNDEX – –

SPACE – –

STR – –

STUFF – –

SUBSTRING – –

UPPER x Fully supported.

+– –

System Functions

COL_LENGTH – –

COL_NAME – –

DATALENGTH – –

DB_ID – –

DB_NAME x All parameters are ignored, and the function

always returns the current database name.

HOST_ID – –

HOST_NAME – –

INDEX_COL – –

ISNULL – –

OBJECT_ID – –

OBJECT_NAME – –

SUSER_ID – –

SUSER_NAME x All parameters are ignored, and the function

always returns the current username.

USER_ID x All parameters are ignored, and the function

always returns an integer used internally to identify

a user.

Text Functions

PATINDEX – –

TEXTPTR – –

Table B-3. SQL Server Functions (page 3 of 4)

Function

NonStop ODBC

Server Support Comments

x Indicates a supported function

– Indicates an unsupported function