Error -1214

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

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

ceinma · #2 (**permalink**) 04-06-09, 07:56

http://publib.boulder.ibm.com/infocenter
/idshelp/v115/topic/com.ibm.sqlr.doc/sii-02-23061.htm

Quote:

# 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.)

Internet Services

Web Development

Digital Marketing

Consumer Tech