SQL$HELP_OLD72.HLB  —  CREATE  OUTLINE  Format
  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 -+
Close Help