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.