ODBC Server Reference Manual

CORE SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

3-47

Examples

The following statements delete one record from the EMPLOYEE table and one from

the DEPARTMENT table:

delete employee

where last_name = "Hall" and first_name = "Dana"

delete department

where deptnum = 1030

CORE SQL Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statement is DELETE.

DELETE in CORE SQL differs from the NonStop SQL/MP implementation in the

following ways:

DROP INDEX

Use DROP INDEX to remove an index from the database.

The DROP INDEX statement has the following syntax:

index-name

specifies the index to drop.

Example

The following statement drops the index XDEPTNUM from the database:

drop index xdeptnum

CORE SQL Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statement is DROP INDEX, which is the same as

the CORE SQL statement.

Feature In NonStop SQL/MP In CORE SQL

Can you specify the

locking mode?

Yes No, unless you use pass-through mode.

Default locking mode STABLE ACCESS Depends on the setting of the

SQL_TXN_ISOLATION item in the user

profile table, ZNSPROF. The default is

STABLE ACCESS.

DROP INDEX index-name