SQL Server Stored Produre - multiple recordsets

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6741056992

September 17, 2008, 10:31 AM

mbedford

SQL Server Stored Produre - multiple recordsets

When running a SQL stored procdure, can Webfocus read multiple recordsets output by the stored procedure. If so, how do you tell Webfocus which recordset to read?

September 17, 2008, 06:04 PM

TexasStingray

I do not believe so. If you need to return multiple record set then you need to break it in to serpeate stored procedures

Scott

September 18, 2008, 03:56 PM

Carol Dobson

I pass along a TABLE ID to the stored procedure and grab one recordset at a time from the one stored procedure, then put each into a hold file for creating the output. But we call the same stored procedure more than once.

WebFOCUS 7.6.6/TomCat/Win2k3