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

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

261

262

263

264

265

266

267

268

269

270

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-180

SELECT Statement

table [[AS] corr [(col-expr-list)]]

| STREAM (table) [[AS] corr [(col-expr-list)]]

[AFTER LAST ROW]

| view [[AS] corr [(col-expr-list)]]

| STREAM (view) [[AS] corr [(col-expr-list)]]

[AFTER LAST ROW]

| (query-expr) [AS] corr [(col-expr-list)]

| (delete-statement [RETURN select-list])

[AS] corr [(col-expr-list)]

| (update-statement [RETURN select-list])

[AS] corr [(col-expr-list)]

| joined-table

specifies a table-ref as either a single table, view, derived table determined

by the evaluation of a query expression, a joined table, a streaming table or

view, or an embedded update or delete statement.

You can specify this optional clause for a table or view. This clause is required

for a derived table:

[AS] corr [(col-expr-list)]

specifies a correlation name corr for the preceding table reference

table-ref in the FROM clause. See Correlation Names on page 6-10.

col-expr [[AS]name] [,col-expr [[AS]name]]...

specifies the items in col-expr-list, a list of derived columns.

For the specification of a query expression, see the syntax diagram for

query-expr on page 2-174.

STREAM (table) [[AS] corr [(col-expr-list)]]

returns a continuous data stream from a table. A cursor opened on a

continuous data stream never returns an end-of-data condition but blocks

(waits) and resumes execution when new rows become available.

[[AS] corr [(col-expr-list)]]

specifies an optional correlation name corr and an optional column list

for the preceding table reference in the FROM clause.

[AFTER LAST ROW]

causes the stream to skip all existing rows in the table and return only rows

that are published after the stream’s cursor is opened.

STREAM (view) [[AS] corr [(col-expr-list)]]

returns a continuous data stream from a view.

Pub/Sub