hi..i just want to know way to reset a specific sequence?? for example i want to reset sequence NextOrdNum.. thanks in advance
You want to use the 'CURRENT-VALUE' statement..
CURRENT-VALUE(NextOrdNum) = x.