ODBC Server Reference Manual

Transact-SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

4-99

NonStop ODBC Server Compared With SQL Server

When used through the NonStop ODBC Server, UPDATE STATISTICS differs from the

SQL Server implementation in the following way:

NonStop ODBC Server Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statement is UPDATE STATISTICS.

USE

Use the USE statement to set the default NonStop SQL/MP catalog. The new catalog

takes effect as soon as the statement is executed.

When you start a NonStop ODBC Server session, the default database in a user profile

is used as the default database. MASTER is used if a default database does not exist.

You can define the default database in a user profile; see the description of the ADD

USER statement under ADD USER on page 7-115.

The USE statement has the following syntax:

database-name

identifies the customized NonStop SQL/MP catalog to use.

If you specify MASTER, as shown in the following example, the NonStop ODBC

Server points to the system catalog, which is a NonStop SQL/MP catalog that

corresponds to the SQL Server MASTER database:

use master

If you specify a database name, as shown in the following example, the NonStop

ODBC Server points to the NonStop SQL/MP catalog \TEST.$DISK01.PERSNL:

use test_disk01_persnl

Examples

The following statement defines the catalog to be used as the catalog PERSNL on the

disk volume DISK01 on the node called TEST:

use test_disk01_persnl

Feature In SQL Server

In Programs Used With the

NonStop ODBC Server

Can you specify the index for which to

update statistics?

Yes No

USE database-name