ODBC Server Reference Manual

Transact-SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

4-100

NonStop ODBC Server Compared With SQL Server

When used through the NonStop ODBC Server, USE differs from the SQL Server

implementation in the following way:

NonStop ODBC Server Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statements are CATALOG and DEFINE.

Specifying a catalog in the NonStop ODBC Server differs from specifying a catalog in

NonStop SQL/MP in the following ways:

Feature In SQL Server

In Programs Used With the

NonStop ODBC Server

When does the new

database take

effect?

When the current batch finishes. Immediately (even before the

batch finishes).

Feature In NonStop SQL/MP

In Programs Used With the

NonStop ODBC Server

Format for a catalog name \node.$volume.subvolume node_volume_subvolume

How the catalog name is

expanded if you omit the node

and volume

Uses the node and volume

where the user is currently

logged on.

Expanded using the current

volume and subvolume