skip to main content
Part 4: The Connect XE Drivers : The Salesforce Driver : Catalog Tables : SYSTEM_SESSIONINFO Catalog Table
  
SYSTEM_SESSIONINFO Catalog Table
The system table named SYSTEM_SESSIONINFO describes details about your connection to Salesforce.
The following table defines the keys for the SYSTEM_SESSIONINFO table. The values change based on your data source settings.
Table 76. SYSTEM_SESSIONINFO Catalog Table
Key
Description
AUTOCOMMIT
Autocommit is always enabled.
DATABASE
The location and the filename prefix for the data mapping and configuration files.
DATABASE_ READONLY
Indicates whether the database the session is connected to is read only
DB_FILE_LOCATION
The fully qualified path to the directory or folder that contains the database and mapping files.
DB_FILE_PREFIX
The filename prefix of the database and mapping files the driver is using.
IDENTITY
Currently always zero
MAXROWS
Currently always zero
LOG_CONFIG_FILE
The fully qualified path to the directory or folder that contains the logging configuration file.
SCHEMA
The name of the remote Salesforce schema.
SESSION_ID
The ID for this session
SESSION_READONLY
Indicates whether the session is read only
USER
The user that is associated with this session.