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

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

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    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

    http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ddi.doc/ddi159.htm

    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
  •