In PowerBuilder 10.5.2 and later, when you use the OLE DB database interface with a Microsoft SQL Server database and retrieve data into a DataWindow, or use an embedded SQL cursor in a SELECT statement, server-side cursors help to support multiple command execution.
If this has a negative impact on performance, try increasing the
size of the Block database parameter to 500 or more, or adding the
following line to the [Microsoft SQL Server] section in the PBODB
initialization file to turn off server-side cursors: ServerCursor
= 'NO'