SQL$HELP_OLD72.HLB  —  DECLARE  CURSOR  Arguments  INSERT_ONLY
    Specifies that a new list or a new row is created or opened.

    If you specify a list cursor but do not specify the INSERT ONLY
    clause, SQL declares a read-only list cursor by default.

    If you specify a table cursor but do not specify the INSERT ONLY
    clause, SQL declares an update cursor by default.

    When you specify an insert-only cursor, all the value expressions
    in the select list must be read/write. When you declare an
    insert-only table cursor to insert lists, you must specify both
    table column and list column names in the FROM clause.

    For more information about how to use insert-only cursors, see
    the INSERT statement.
Close Help