DSXchange

for the sequence number generate there is a function is there
but it is not work properly ,how is done it
please tell me

What does "not work properly" about it? How about some specifics - the exact routine you are using, your syntax and the problem you are having. That will help get us started.

There are at least four different ways to generate sequence numbers. You need to be quite specific about the technique that you are using.