PRSQL9110012: Inserting Using PREPARE and EXECUTE/USING Slows

ID Number: Q77190

1.11

OS/2

buglist1.11

Summary:

Problem ID: PRSQL9110012

SYMPTOMS

Repeatedly inserting a row into a table using Embedded SQL for

COBOL will cause SWAPPER.DAT to increase and the system to slow

down. Eventually the computer becomes unable to change screen

groups.

CAUSE

This problem is caused by using the PREPARE and EXECUTE/USING

clauses. The problem does not occur if the insert statement is

entirely PREPARE'd or if the insert statement is sent as a dynamic

statement (between EXEC SQL and END-EXEC).

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.11. We are researching this problem and will post new information

here as it becomes available.