Results 1 to 2 of 2

Thread: Error -1214

  1. #1
    Join Date
    Apr 2009

    Unanswered: Error -1214

    Hi All,

    Can any help me out that how to solve this error in Informix.

    OS Error Number: -1214
    Message : E9004: Erro em SQL INSERT

    Error -1214 is Value too large to fit in a SMALLINT

    Pls suggest,

  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil

    # finderr -1214
    -1214 Value too large to fit in a SMALLINT.

    The SMALLINT data type can accept numbers with absolute values from 0
    through 32,767 (plus or minus (2 to the 15th power) - 1). To store
    numbers that are outside this range, redefine the column or variable to
    use INTEGER or DECIMAL type. (The value -32,768 is a 16-bit value but
    is not acceptable; it indicates a null value in 4GL.)
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts