Session-status is a one byte field that designates the state of the session.
In this language... | The variable name for Session-status is... |
---|---|
COBOL | DBCAREA-SESS-STATUS |
PL/I | SESS_STATUS |
C, C++ | sess_status |
IBM Assembler | DBCOFLG1 |
This routine... | Does this for Session-status... |
---|---|
DBCHINI | writes |
DBCHCL | writes (FET) |
Session-status is used by... | To... |
---|---|
applications | read. |
DBCHCL places Session-status in the DBCAREA when the Fetch function initiates. If Wait-for-response is set to N, Session-status is available at the completion of the request.
There are four flags in Session-status:
Flag Name | Description | ||
---|---|---|---|
Pool session | This bit is set by FET at Connect completion. | ||
Set bit X‘80‘ to this... | If the session was... | ||
1 | assigned from a session pool. | ||
0 | not assigned from a session pool. | ||
In transaction | Set bit X‘40‘ to this... | If the session... | |
1 | had a transaction in progress when the bit was set. | ||
0 | did not have a transaction in progress when the bit was set. | ||
Cleanup needed | Set bit X‘20‘ to this... | If the default database... | |
1 | has changed or if there are still spool files. | ||
0 | has not changed or if there are not still spool files. | ||
In-Doubt | Set bit X‘10‘ to this... | If a Two-phase commit session is... | |
1 | in doubt. | ||
0 | not in doubt. |
The In transaction and Cleanup needed flags are dependent on timing.
A fetch is a request-level operation and the flag is a session-level report. Therefore, the current session state may be changed by a subsequent request.