MVSFORUMS.com

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Hi all,

I need to create a column as a secuencial counter.
Let me explain, every time the table recieve a new row, this column grows up one (automaticly).

Someone told me in Oracle exist AUTONUMBER.

Thanks.

kolusu · Posted: Tue Aug 31, 2004 5:40 am Post subject:

Monaco,

Define the table with an Identity Column as GENERATED ALWAYS. check this link.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/1.2.3.1.3?SHELF=&DT=20010710165542&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Thanks Kolusu.
Its great.