Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gsc_sequence table — gscsq

> This is a generic sequence number and format table. All entries in this table are system-owned by their nature.

> When a sequence number must be generated, it is done at the end of the update as part of the transaction. This table is a potential bottleneck, so locks should be kept to an absolute minimum. Locks during user interaction should be avoided.

> If you want sequence numbers to be automatically generated, then there can be no holes in the sequence numbers. For this reason, a standard Progress 4GL sequence is not used.

> Example uses for this table are the automatic generation of document numbers or transaction references.

> Table 12–1 lists the table’s FLA, fields, and foreign keys.

> Table 12–1: gsc_sequence table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gscsq | sequence_obj (Decimal) company_organisation_obj (Decimal) owning_entity_mnemonic (Character) sequence_tla (Character) sequence_short_desc (Character) sequence_description (Character) min_value (Integer) max_value (Integer) sequence_format (Character) auto_generate (Logical) multi_transaction (Logical) next_value (Integer) number_of_sequences (Integer) sequence_active (Logical) | sequence_obj

> Table 12–2 gives details of the table’s indexes.

> Table 12–2: gsc_sequence index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgsc_sequence | sequence_obj | Primary Unique
> XAK1gsc_sequence | company_organisation_obj owning_entity_mnemonic sequence_tla | Unique
> XIE1gsc_sequence | sequence_description | Nonunique
> XIE2gsc_sequence | sequence_short_desc | Nonunique

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095