CREATE OUTLINE <outline-name> -+--------------------------------++ +> STORED NAME IS <stored-name> -+| +------------------------- <-------------------------------------+ ++-> FROM --> ( --> <sql-query> --> ) ----------+---------+ +-> on-clause ---------------------------------+ | +-> ID 'id-number' ----------------------------+ | +------------------------------ <-----------------------+ +-----+------------++--------------------------------+--+ +> MODE mode ++> AS ---+>( -> query-list -> )--+ | +> USING + | +--------------------------- <----------------------------+ ++-----------------------------+--------------------------+ +> COMPLIANCE -+-> MANDATORY -+ | +-> OPTIONAL --+ | +--------------------------- <----------------------------+ ++-------------------------------------------------------++ +> EXECUTION OPTIONS --> ( --> execution-options --> ) -+| +--------------------------- <----------------------------+ ++--------------------------------+-----------------------------> +> COMMENT IS --+-> 'string' ---++ +----- / <------+ on-clause = ---> ON --+-> PROCEDURE -+-+-> ID proc-id ----+-+-> +-> FUNCTION --+ +-> NAME <name> ---+ | +-> COLUMN ------+-----> <name> ------+ +-> CONSTRAINT --+ +-> TRIGGER -----+ +-> VIEW --------+ query-list = ---+-> QUERY (source) ----------+----------> +-------------<--------------+ source = -+-+-------------+--+-> table-access --------------+--+--------> | +-> FLOATING -+ +-> ORDERED ---+--> (source) --+ | | +-> UNORDERED -+ | | | +-> subquery-list -------------+ | | +--------------------------------------------------+ | +-> JOIN BY -+--> CROSS ------+--- TO -----+--+ | | +--> MATCH ------+ | | | | +--> ANY METHOD -+ | | | +-> UNION WITH ----------------------------+ | +------------------------<----------------------+ table-access = ---> <table-name> -+-------------------------+-> context --+ +-> MODULE <module-name> -+ | +----------------------------------------------------------+ +-> ACCESS --> PATH ---+------------------------------+---> +--> ANY ----------------------+ +--> SEQUENTIAL ---------------+ +--> DBKEY --------------------+ +--> ROWID --------------------+ +--> NO INDEX -----------------+ +--> INDEX -+> <index-name> --++ +------ , <-------+ subquery-list = ---+-> SUBQUERY (source) -------+----------> +-------------<--------------+ execution-options = -+-> ANY --------+------> +-> NONE -------+ +-> FAST FIRST -+ +-> TOTAL TIME -+