Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gst_session table — gstss

> This table records a session and is only applicable for the duration of a session. It records session activity and manages the context for the session in the child table, `gsm_server_context`.

> Table 13–25 lists the table’s FLA, fields, and foreign keys.

> Table 13–25: gst_session table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gstss | session_obj (Decimal) session_id (Character) session_type_obj (Decimal) user_obj (Decimal) session_creation_date (Date) session_creation_time (Integer) last_access_date (Date) last_access_time (Integer) client_date_format (Character) client_numeric_format (Character) year_offset (Integer) session_complete (Logical) default_context_scope_obj (Decimal) render_type_obj (Decimal) | render_type_obj session_obj session_type_obj user_obj

> Table 13–26 gives details of the table’s indexes.

> Table 13–26: gst_session index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgst_session | session_obj | Primary Unique
> XAK1gst_session | session_id | Unique
> XIE1gst_session | session_type_obj | Nonunique
> XIE2gst_session | user_obj | Nonunique
> XIE3gst_session | last_access_date last_access_time | Nonunique
> XIE5gst_session | session_complete | Nonunique
> XIE6gst_session | default_context_scope_obj | Nonunique
> XIE7gst_session | render_type_obj | Nonunique

> The information in this table is all client related. In the case of a WebSpeed Agent, the agent is also the client.

> The session id field from `gsm_server_context` table is now on this table, so the session id only exists in one place for the session. The object id for the session record is carried down onto the individual context records. This improves the efficiency of fixing the context id when a session is dropped and reconnected. That restores the context for the new session from the old session. For the AppServer, a record is created in this table at connection time and checked or updated in the activate procedure. To ensure that it updates as efficiently as possible, this table must not have a write trigger.

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