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?

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

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.