SQL$HELP_OLD72.HLB  —  INSERT
    Adds a new row, or a number of rows, to a table or view.You can
    also use the INSERT statement with a cursor to assign values to
    the segments in a column of the LIST OF BYTE VARYING data type.

    Before you assign values to the segments in a column of the
    LIST OF BYTE VARYING data type, you must first assign a value
    to one or more other columns in the same row. To do this, use
    a positioned insert. A positioned insert is an INSERT statement
    that specifies an insert-only table cursor. This type of INSERT
    statement sets up the proper row context for subsequent list
    cursors to assign values to list segments.

    You can specify the name of a static, a dynamic, or an extended
    dynamic cursor in a positioned insert. If you specify a static
    cursor name, that cursor name must also be specified in a DECLARE
    CURSOR statement within the same module. See the DECLARE CURSOR
    statement for more information on static, dynamic, and extended
    dynamic cursors.

    When you use an INSERT statement to assign values to list
    segments:

    o  The current transaction must not be read-only.

    o  You cannot specify a cursor name that refers to an update
       table cursor.

    o  Your cursor must specify an intermediate table.

    o  The value that you assign is appended to the end of the list.
Additional Information: explode extract
Environment Format Arguments Examples
Close Help