ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
iii
3. CORE SQL Language (continued)
3. CORE SQL Language (continued)
Examples 3-41
File Attributes and Security Considerations 3-41
Creation of Partitioned Tables 3-42
CORE SQL Compared With NonStop SQL/MP 3-42
CREATE VIEW 3-43
Examples 3-44
Shorthand Views and Protection Views 3-44
CORE SQL Compared With NonStop SQL/MP 3-45
DELETE 3-45
Positioned DELETE 3-45
Searched DELETE 3-46
Examples 3-47
CORE SQL Compared With NonStop SQL/MP 3-47
DROP INDEX 3-47
Example 3-47
CORE SQL Compared With NonStop SQL/MP 3-47
DROP TABLE 3-48
Example 3-48
Dropping Dependent Views and Indexes 3-48
Dropping Partitioned Tables 3-49
CORE SQL Compared With NonStop SQL/MP 3-49
DROP VIEW 3-49
Example 3-49
Dropping Dependent Views and Indexes 3-50
CORE SQL Compared With NonStop SQL/MP 3-50
GRANT 3-50
INSERT 3-51
Example 3-52
CORE SQL Compared With NonStop SQL/MP 3-52
POWER 3-53
Example 3-53
REVOKE 3-53
SELECT 3-54
Standard SELECT 3-54
Examples 3-55
SELECT for Update 3-59
CORE SQL Compared With NonStop SQL/MP 3-59
UPDATE 3-61