>>-+--------------------------------------------------+---------> | .-,-----------------------. | | V | | '-WITH--+-----------+----common-table-expression-+-' '-RECURSIVE-' >--fullselect--+-----------------+--+--------------------+------> '-order-by-clause-' '-fetch-first-clause-' .----------------------. V | (1) (2) >----+------------------+-+------------------------------------>< +-update-clause----+ +-read-only-clause-+ +-optimize-clause--+ '-isolation-clause-'
The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can also be issued interactively causing a result table to be displayed at your work station. In any case, the table specified by a select-statement is the result of the fullselect.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.