Understanding Sequence report

[Yuvapradeep]

Hi Team,

I would like to understand sequence report details.

In report below mentioned are the columns at sequence report

Sequence Name: Are these represent tables or Columns of table?

Initial Value: It is the starting point from where sequence begins? please confirm i am understanding this right?

Increment: value is 1 for this, it increments by one every time data inserted/

Max/Min Value: Max value the records can be stored. in my report i see '?' values, what is '?' means in report.

Cycle?: the same sequence number will be reused


Or please provide any document regarding sequence report.



Thanks,

 

[Rob Fitzpatrick]

These questions are answered in the documentation. Look at https://docs.progress.com/bundle/oemgt-configure-multitenancy/page/View-a-list-of-sequences.html. You can ignore the parts about multi-tenancy if you aren't using that feature.

Sequence definitions are stored in the _sequence system table. Sequence values are not stored in tables; they are stored in sequence blocks.