Salesforce

Cursors - SQL Considerations (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Cursors - SQL Considerations (Magic xpa 4.x)

The MSSQL gateway uses Dynamic cursors for Online tasks and KeySet cursors for Batch tasks.

Relevant Parameters

1. Setting the Cursor data source property to No disables the use of cursors on the specific table and uses DB command instead.

2. The Max. Connections DBMS property controls the maximum number of connections the gateway can use. The default value is 3 (plus 1 extra) connections. The extra connection is used by the gateway for commands that fetch a single record, or for a command without fetchable results, such as Update. This number is for the Server/User-name pairs. If you have defined several databases in Options/Settings/Databases, and some of them use different servers or different usernames, this number applies to each database that has a different server or user name.

Magic xpa enables the developer to use a Cursor for DSQL Statements in SQL Server Stored Procedures. Magic xpa supports using a cursor for DSQL statements that return a result set.

This can be done by adding “/*===CURSOR=Y ===*/” to the DSQL statement.

/*===CURSOR=Y ===*/ is applicable only for DSQL batch commands and Stored Procedures in Online and Batch tasks.

Reference
Attachment 
Attachment