ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-45
CORE SQL Compared With NonStop SQL/MP
The view definition text indicates whether a view is a shorthand or a protection view.
You can list this text by querying the NonStop SQL/MP VIEWS table, which resides on
the subvolume of your NonStop SQL/MP catalog. The following SQLCI statement lists
the view definition text for a view:
select viewtext from views where viewname =
"\TEST.$VOL2.PERSNL.EMPLIST";
In this example, both the VIEWS table and the EMPLIST view are in the subvolume
\TEST.$VOL2.PERSNL.
CORE SQL Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is CREATE VIEW.
CREATE VIEW in CORE SQL differs from the NonStop SQL/MP implementation in the
following ways:
DELETE
Use DELETE to remove rows from a table. DELETE has two forms: the positioned
DELETE and the searched DELETE.
The positioned DELETE deletes the row from which the current row of the active set of
a cursor is derived.
The searched DELETE deletes any rows that satisfy a search condition.
Positioned DELETE
The positioned DELETE statement has the following syntax:
table-name
is the table from which rows are to be deleted. The table-name can be qualified
with the database name and owner name. If table-name is a viewed table,
Feature In NonStop SQL/MP In CORE SQL
Where is the view created? In the user’s current
node, volume, and
subvolume
In the same subvolume as the
catalog in which the view is
registered
Can you specify protection
view or shorthand view?
Yes No, unless you use pass-through
mode.
Is WITH CHECK OPTION
available?
Yes No, unless you use pass-through
mode.
DELETE FROM table-name
WHERE CURRENT OF cursor-name