skip to main content
Using the Driver : Catalog Tables : SYSTEM_SESSIONINFO Catalog Table
  

Try DataDirect Drivers Now

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 10. 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.