DB2如何实现字段的自动增一,一定要救救我,真的散分

[michael_yi]

在oracle中有sequence,在sqlserver中有identity（应该也是完成相同功能的吧？）,我不太想使用trigger来完成,是否还有直接的或其他的方法类似identity？我是db2新手,希望能给我解释详细一些。不胜感激.

[michael_yi]

db2高手，快来帮帮我，只要有价值，一定给分。

[michael_yi]

IronPromises(铁诺)哪里去了？数据库高手吧。帮帮我。

[michael_yi]

to superjj2002():
有一次你给别人回答过此类问题，但我没弄明白是怎么回事。能给我再回答一次吗？

[netyao]

我找一找

[panther_totem]

没有用过，不知道，可以找一找。

[levin_li]

Create Table table_name
(
SERIALNO BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ),
.....
)

[netyao]

When connected to a DB2 version 7.1 or higher database, ei-O uses the IDENTITY property to replicate the functionality of Access AutoNumber fields. The "GENERATED ALWAYS AS INDENTITY (START WITH x, INCREMENT BY y, CACHE z)" usage is specified when new DB2 tables are created and either the Access table contains no data or the "Data" option is not checked. In all other cases, "GENERATED BY DEFAULT AS IDENTITY (START WITH x, INCREMENT BY y, CACHE z)" is used.

The START WITH value can be any positive or negative value that could be assigned to this column. The default is 1.

The INCREMENT BY parameter cannot be zero or exceed the value of a large integer. The default is 1.

The CACHE value must be in the range of 2 to 32,767 and defaults to 20. Set the CACHE to 0 for NO CACHE.

[netyao]

When connected to a DB2 version 7.1 or higher database, ei-O uses the IDENTITY property to replicate the functionality of Access AutoNumber fields. The "GENERATED ALWAYS AS INDENTITY (START WITH x, INCREMENT BY y, CACHE z)" usage is specified when new DB2 tables are created and either the Access table contains no data or the "Data" option is not checked. In all other cases, "GENERATED BY DEFAULT AS IDENTITY (START WITH x, INCREMENT BY y, CACHE z)" is used.

The START WITH value can be any positive or negative value that could be assigned to this column. The default is 1.

The INCREMENT BY parameter cannot be zero or exceed the value of a large integer. The default is 1.

The CACHE value must be in the range of 2 to 32,767 and defaults to 20. Set the CACHE to 0 for NO CACHE.

[michael_yi]

我想给netyao(笑一笑:-) )，levin_li(levin)分，但怎么也找不到怎么给分，我以前给过的，但现在怎么找不到了。急死我了。