SQL0413N Overflow occurred during numeric data type conversion.

[hellocuhk]

CREATE TABLE Branch(
name varchar(15) NOT NULL,
city varchar(15) NOT NULL,
asset NUMERIC NOT NULL,
PRIMARY KEY(name));
INSERT INTO Branch VALUES('Downtown', 'Brooklyn', 900000);

一个很简单的指令吧，为什么出现错误呢？

insert into branch values ('Redwood', 'Palo Alto', 2100000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0413N Overflow occurred during numeric data type conversion.
SQLSTATE=22003

SQL0413N Overflow occurred during numeric data type conversion.

Explanation:

During processing of the SQL statement, an overflow condition arose when
converting from one numeric type to another. Numeric conversion is
performed according to the standard rules of SQL.

Federated system users: numeric conversion can occur at the federated
server, at data sources, or both.

The statement cannot be processed. No data was retrieved, updated, or
deleted.

请问如何解决？

[liyan93834183]

Overflow occurred during numeric data type conversion
数据溢出

[liyan93834183]

NUMERIC是数值类型的统称，不是具体的数据类型

[quiettown]

你定义明确吧，numeric数据类型默认的不超过99999.