BUG: Server to Server RPC Fails Using COMPUTE and COMPUTE BY

• Microsoft SQL Server version 4.2 for OS/2
• Microsoft SQL Server, version 4.2

    OS/2: 1833 (4.2)

SYMPTOMS

When issuing a RPC to a remote NT SQL Server, the client application hangs. However, both the local and the remote server can be accessed normally, and server to server RPCs can still be executed between the two machines. Execution of the stored procedure locally, either by an EXEC statement or using DB-Library RPC functions, will return all results to the front-end without error.

CAUSE

If a stored procedure contains a SELECT statement that includes both a COMPUTE BY and a COMPUTE clause, and if that stored procedure is executed as a server to server RPC, the client workstation will hang after receiving all regular and COMPUTE BY results, but before receiving the grand total produced by the COMPUTE

WORKAROUND

The SELECT statement which produces the COMPUTE BY and COMPUTE results should be broken into two SELECTs. The first producing the COMPUTE BY results and the second producing the grand total.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.