Reg Sequence number physical storage location

saravanakumar

saravanakumar

Member
Hi Everybody,
Where exactly the sequence value gets stored physically??? A single sequence can be used by more than one table, so from where exactly the current-value function fetches the current value of the sequence?

Thanks in advance. :confused:
 
Hi,

The progress sequence values are stored in a separate file with default name "_seqvals.d" which contains the current value of the sequence. It can also be given a name but in most case they use the default name. you can check it whether the default name is used or not when you dump the sequence using the Data Administration Utility.:D:D



Regards,
Ram
 
_seqvals.d is where they are stored by the data dictionary dump process. But I believe the original question was to determine where they are "physically" stored in a live database. As the linked PEG thread says -- it depends on how the db was created and it may very well vary in the future. There is no single right answer no is there a simple answer and it is not an especially useful thing to know. If you need a sequence value then you should use CURRENT-VALUE( sequence-name ) or its related functions. Going after the physical location is pointless.
 
Hi,
Sure. I to go with ur point. But i hope there is nothing wrong in knowing extra things. Correct me if i am wrong?

I couldn't get a rite ans still for this thread yet. I hav posted this ques to so many progress developers, no one knows abt this. Even in hidden tables and meta data the information which i am in search is not available. So i am shocked where xactly it is being stored.

If i could get the ans i would have a gr8 satisfaction. Thanks in advance. :)
 
Sequences are stored as part of the Progress Schema. As far as I know they are stored as Sequences, being different from tables.

If you want to access Sequences through the Data Dictionary click on the Sequences button (in Windows). You can dump and load them separately from tables.

You can change the value stored in a sequence using the CURRENT-VALUE command. You get the next value using the NEXT-VALUE function.

Of course, it depends on what you mean by "Where exactly the sequence value gets stored physically??? ".

Do you mean "How is it stored?" or "Is it stored in a hidden table?" ?
 
saravanakumar said:
Hi,
Even in hidden tables and meta data the information which i am in search is not available. So i am shocked where xactly it is being stored.

If i could get the ans i would have a gr8 satisfaction. Thanks in advance. :)
Click to expand...

Well Maybe you didn't read it correctly, but the link Tom gave you revealed the 'exact' position you are referring to....

The 'position' of the sequence block is stored in the masterblock. If you know for your version of Progress the 'layout' of the masterblock then you can find the sequences....

But again, there is no need to know this exact location and this location can be changed anytime, same applies for the structure of the masterblock. This is the working area of PSC and not for ABL developpers. We got this nice ABL (AKA 4GL) to be able to use it and not think about it :awink:

Casper
 
You must log in or register to reply here.
Back
Top