Results 1 to 2 of 2

Thread: Error -1214

  1. #1
    Join Date
    Apr 2009
    Posts
    2

    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,
    AJ

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    http://publib.boulder.ibm.com/infocenter
    /idshelp/v115/topic/com.ibm.sqlr.doc/sii-02-23061.htm


    # 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
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - 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
  •