HELPLIB.HLB  —  SQLMOD72  Arguments  declare-statement
    Any of the following statements:

    o  DECLARE ALIAS

    o  DECLARE CURSOR

    o  DECLARE STATEMENT

    o  DECLARE TABLE

    o  DECLARE TRANSACTION

    You must place all DECLARE statements in an SQL module together
    after the LANGUAGE clause of the module. All such DECLARE
    statements are optional.

    All the DECLARE statements except DECLARE TRANSACTION can be
    repeated. For each DECLARE CURSOR statement, however, there must
    be only one procedure in the SQL module that contains an OPEN
    statement that corresponds to the DECLARE CURSOR statement.

    Do not use any punctuation to separate DECLARE statements or
    to separate the declare-statement section from the procedure
    section.
Close Help