SQL$HELP72.HLB  —  INSERT  Arguments  column-name
    Specifies a list of names of columns in the table or view. You
    can list the columns in any order, but the names must correspond
    to those of the table or view.

    If you do not include all the column names in the list, SQL
    assigns a null value to those not specified, unless columns were:

    o  Defined with a default

    o  Based on a domain that has a default

    o  Defined with the NOT NULL clause in the CREATE TABLE statement

    You cannot omit from an INSERT statement the names of columns
    defined with the NOT NULL clause. If you do, the statement fails.

    Omitting the list of column names altogether is the same as
    listing all the columns of the table or view in the same order
    as they were defined.

    You must omit the list of column names when using the INSERT
    statement to assign values to the segments in a column of data
    type LIST OF BYTE VARYING. Column names are not valid in this
    context.
Close Help