Show TOC

Background documentationData Type of the Target Column and Data Type of the Value to be Inserted

 

Let C be a target column and v a value that is not equal to the NULL value.

  • v is to be inserted in C by means of an INSERT statement.

  • v is to be used to modify C with an UPDATE statement.

    Data Type of the Target Column and Data Type of the Value to be Inserted

    Target Column C

    Required Value for v

    Numeric column

    Number within the permissible range of C.

    INSERT statement: If v is the result of a QUERY expression, decimal places are rounded off if necessary.

    UPDATE statement: If v is the result of an expression that does not comprise one single numeric literal, decimal places are rounded off if necessary.

    Alphanumeric column with the code attribute ASCII, UNICODE

    Character string whose length is not greater than the length attribute of C. Subsequent blanks are ignored when the length of v is calculated. If the length of v is shorter than the length attribute of C, then v is lengthened by the corresponding number of blanks.

    Alphanumeric column with the code attribute BYTE

    Hexadecimal character string whose length is not greater than the length attribute of C. Subsequent binary zeros are ignored when the length of v is calculated. If the length of v is shorter than the length attribute of C, then v is lengthened by the corresponding number of binary zeros.

    Data type DATE

    Date value in the current date format.

    Data type TIME

    Time value in the current time format.

    Data type TIMESTAMP

    Time stamp value in the current time stamp format.

    Data type BOOLEAN

    One of the values TRUE or FALSE (BOOLEAN)