ODBC Server Reference Manual

Introduction

HP NonStop ODBC Server Reference Manual—429151-002

1-7

UNIX Workstation Requirements

Table 1-5 lists the hardware and software required to run the NonStop ODBC Server

with a UNIX workstation.

SQL Language Support

The NonStop ODBC Server supports the ODBC CORE SQL dialect of the SQL

language or the SQL Server Transact-SQL dialect (or the NonStop SQL/MP syntax

using pass-through commands). Clients can access NonStop SQL/MP databases

using whichever dialect their application implements.

In an environment shared by both CORE SQL applications and Transact-SQL

applications, however, it is suggested that users adhere to the minimum attributes

offered by either dialect (for example, using names not more than 32 characters in

length, the Transact-SQL maximum) to promote the optimum sharing of data access

among all clients in the environment.

Supported and Unsupported ODBC Features

There are three levels of SQL syntax recommended for use with ODBC. They are:

Note. The NonStop ODBC server negotiates to a version 4.6 (or less) driver for clients using

DBLIB. Therefore, a DBLIB that requires a driver version greater than 4.6 is not supported.

Table 1-5. Hardware and Software Requirements for UNIX Workstations

Requirement Description

Computer UNIX workstation

Memory At least 32 MB

Disk space At least 70 MB free

Operating system Sun 4.1.1 or later, HP-UX, or other appropriate UNIX OS

Network hardware Ethernet board

Network software TCP/IP

DB connectivity software Sybase Open Client/C (for the relevant operating system)

Minimum set A set of SQL statements suitable for access to a flat file.

Core set SQL syntax based on the X/OPEN and SQL Access Group SQL CAE

(Common Applications Environment) specification. The core set is a

superset of the minimum set.

Extended set SQL syntax for datetime usage, outer joins, scalar functions, and

stored-procedure calls. The extended set is a superset of the

minimum and core sets.