Informix SQL problem.

laptop2000 · #1 (**permalink**) 04-06-09, 02:08

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

shammat · #2 (**permalink**) 04-06-09, 02:51

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech