SQL/MX 2.x Reference Manual (H06.04+)

Introduction

HP NonStop SQL/MX Reference Manual—540440-003

1-30

Accessing Views

The FOR PROTECTION clause of the SQL/MP CREATE VIEW statement specifies a

protection view. If you omit this clause, the view is a shorthand view.

NonStop SQL/MX provides support for the access of SQL/MP protection views. A

protection view is derived from a single table and has associated security values that

determine who can read, write to, execute, and purge the view. Security specifically

defined on the view overrides the security on the underlying table.

NonStop SQL/MX also supports the read-only access of SQL/MP shorthand views. A

shorthand view is derived from one or more tables or other views and inherits the

security of the underlying table or tables.

Access Options

If your SQL/MP application uses the BROWSE, STABLE, and REPEATABLE

keywords, NonStop SQL/MX accepts these keywords as synonyms for statement-level

access options READ UNCOMMITTED, STABLE, and SERIALIZABLE (or

REPEATABLE READ), respectively.

SQL/MP Stored Text

You cannot access or manipulate SQL/MP tables or views that have been defined in

specific ways. There are restrictions on specific types of SQL/MP stored text, which is

SQL text that NonStop SQL/MX retrieves from the SQL/MP catalog while processing

SQL/MX text. SQL/MP stored text includes views, constraints, column defaults, first

keys, clustering keys, and partitioning keys.

In NonStop SQL/MX, these types of SQL/MP stored text are disallowed:

•

Views, constraints, column defaults, and first keys cannot contain:

UNITS function

DATETIME string portions with nonstandard formatting

FRACTION-only DATETIME or INTERVAL literals

Interval literals with negative signs inside quotation mark delimiters (for

example, INTERVAL '-5' DAY)

Identifiers named after words that are reserved in SQL/MP stored text (see

Appendix B, Reserved Words.)

Views, however, can contain a select of a FRACTION-only column.

•

Clustering or partitioning keys cannot contain:

FRACTION-only DATETIME or INTERVAL columns

Interval literals with negative signs inside quotation mark delimiters