serial equivalent in DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Techie - 29 Sep 2004 22:17 GMT

If I want to create a table with a triggter to retrive data fast in DB2
database, how can I do that?
I know in informix we have serial as a data type. what is the equivalent in
DB2? what is the sql syntax of defining a column as the serial equivalent in
DB2?

Thanks

Reply to this Message

Madison Pruet - 30 Sep 2004 03:29 GMT

DB2 has the sequence data type, which provides much of the functionality of
the IDS serial.

You can automatically populate the serial column (I think) by using the
serial_name.nextval as the default value for the column. Someone correct me
if I'm wrong about this.

M.P.

> If I want to create a table with a triggter to retrive data fast in DB2
> database, how can I do that?
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Ian - 30 Sep 2004 06:27 GMT

> DB2 has the sequence data type, which provides much of the functionality of
> the IDS serial.
>
> You can automatically populate the serial column (I think) by using the
> serial_name.nextval as the default value for the column. Someone correct me
> if I'm wrong about this.

IDENTITY is closer to serial (at least that's what we implemented in an
IDS -> DB2 migration).

A sequence isn't a data type, it's an object (that is independent of a
table).

Reply to this Message