Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Informix SQL problem.

    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
    Nov 2003
    Provided Answers: 23
    I know nothing about Informix, but "Value too large to fit in a SMALLINT" seems pretty clear to me.

    A quick search with Google reveals the following page, that explains the max. values that you can store in a SMALLINT

    You need to change the datatype for the SMALLINT column to INTEGER, or store smaller number.

Posting Permissions

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