<div>
Hi<br />
&nbsp; &nbsp;Can you please elaborate more on what you want.<br />
I guess if you want the sequence functionality then<br />
there is facility of auto genration of numbers in db2.<br />
For that you have to crate a table with a field which is<br />
populated by db2 itself. You can find detail about on db2<br />
manuals. <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If you want row number like functionality then<br />
you can use ROW_NUMBER() function.<br />
<br />
<br />
<br />
<br />
Hitachi<br />

</div>


Hi
   Can you please elaborate more on what you want.
I guess if you want the sequence functionality then
there is facility of auto genration of numbers in db2.
For that you have to crate a table with a field which is
populated by db2 itself. You can find detail about on db2
manuals.
          If you want row number like functionality then
you can use ROW_NUMBER() function.




Hitachi


<div>
I'm trying to create a view on existing tables. All these tables contains a column OID (because the application above is object oriented). I wanna combine all the OID's in one column in the view and exactly for this I need an additional sequence number.
</div>


I'm trying to create a view on existing tables. All these tables contains a column OID (because the application above is object oriented). I wanna combine all the OID's in one column in the view and exactly for this I need an additional sequence number.

<div>
<br />
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
&nbsp;- PAQ'd and pts refunded<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
Nic;o)
</div>



No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

<div>
<div class="content wysiwyg-content">
How can I create a sequence number like x=x+1 directly in select statement in db2.<br />
Sample SELECT x=x+1 || oid FROM tablename.
</div>
</div>


How can I create a sequence number like x=x+1 directly in select statement in db2.
Sample SELECT x=x+1 || oid FROM tablename.

sequence number in db2

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.