skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Alter Session (EXT)
 

Try DataDirect Cloud Now

Alter Session (EXT)

Purpose

The Alter Session statement is supported for Salesforce-type, Microsoft Dynamics CRM Online, Oracle Marketing Cloud, Oracle Service Cloud, Progress Rollbase, Google Analytics, and SugarCRM data stores. The Alter Session statement allows you to change various attributes of a connection session.

Syntax

ALTER SESSION SET attribute_name=value
where:
attribute_name
Specifies the name of the attribute to be changed.
value
Refers to the specific value setting for that attribute.
The following table lists session attributes and describes them.
Table 53. Alter Session Attributes
Attribute Name
Session Type
Description
Current_Schema
Database
Sets the current schema for the database session. The current schema is the schema used when an identifier in a SQL statement is unqualified. The string value must be the name of a schema visible in the session. For example:
ALTER SESSION SET CURRENT_SCHEMA=sforce
Stmt_Call_Limit
Database
Sets the maximum number of Web service calls the connectivity service can make in executing a statement. Setting the Stmt_Call_Limit attribute has the same effect as setting the StmtCallLimit connection option. It sets the default Web service call limit used by any statement on the connection. Executing this command on a statement overrides the previously set StmtCallLimit for the connection. The value specified must be a positive integer or 0. The value 0 means that no call limit exists. For example:
ALTER SESSION SET STMT_CALL_LIMIT=10
Ws_Call_Count
Remote
Resets the Web service call count of a session to the value specified. The value must be zero or a positive integer. WS_Call_Count represents the total number of Web service calls made to the data store instance for the current session. For example:
ALTER SESSION SET sforce.WS_CALL_COUNT=0
The current value of WS_Call_Count can be obtained by referring to the System_Remote_Sessions system table. For example:
SELECT * FROM information_schema.system_remote_sessions
WHERE session_id = cursessionid()