How to cycle sequence number.

I have created a sequence to generate unique numbers which are to be used as filenames. When I have filled up one folder with 50 files, I want to move the another folder and start the filename with the MinValue of the sequence.
Example:
folderA has files 1, 2, 3 ... 50
folderB has files 1, 2, 3, 4, ...50
folder C has files 1, 2, etc

This is how I created the sequence
create sequence GenFileName
increment by 1
start with 1
maxvalue 1000
minvalue 1
noCycle
order;

The reason I set it to NoCycle is because each file within the same folder must have unique filename.

Question: Is using the sequence the best way to accomplish this? What other methods should I look into? Received on Fri May 28 1993 - 20:52:43 CEST