NEW SQL Statements

Async Operation Statement

async operation statements ::= { BEGIN | END } ASYNC OPERATION ';'  

Copy Table Statement

copy table statement ::=
    COPY TABLE table spec FROM
    table spec [ WITHOUT INDEXES ] [ORDER BY
    column name
    [ ASC | DESC ] [','
    column name [ ASC | DESC ]]] ';'

Create Materialized View Statement

create materialized view statement ::= CREATE MATERIALIZED VIEW
table spec AS
select spec ';'

Libref Statement

libref statement ::=
    LIBREF libref name [ ENGNAME '='
    identifier ] [ ENGOPT '='
    string ] ';'

Load Table Statement

load table statement ::=
    LOAD TABLE table spec [ WITH
    with index spec [ ','
    with index spec ]* ]
    AS select spec ';'