Hi! Frnz Can any1 let me know that what is the relation between view and Sequence.i need it quick.Thanx.God Bless You

In short - A view contains part of or all rows and columns of a table. A sequence is used to insert values into a table or view.

Let me know if you need more info than that.

Both are not related at all. A sequence is a database object that you can use to generate new values in, well, sequence. A sequence is not tied to any table or view. You can use the values from a sequence for whatever you like.

A view is exactly what its name implies: a (different) view on the data in your database. A view can be created on tables or other views and it essentially encapsulates a query, including joins, subselects, olap functions, ... - whatever DB2 (or SQL in general) lets you do in a query.

Thanx Sir! Can u plz do me a favor again? i want to know that when we use ISAM????Thanx.i want immediate reply.Thanx alot

ISAM is a more general term that you used here. Can you elaborate your question more. Is this in regards to DB2 or mainframe...

The similarity is that both are sort of "virtual tables", i.e., not physically stored but their data is "generated" when they are interrogated.
Apart from that, not much similarity.

If by "relation" you mean: use one in the definition of the other:
it is *not* possible to define a view where one column contains all values ever generated by a sequence. If that's what you want, you have to "materialize" those values, i.e., create a table, not a view.
And if that's all the sequence would be used for, then an identity column would be the more appropriate thing to use.