Hi
I have a stored procedure I created and runs fine in SQL Server . No Parameters are required and returns two rows, one for prev month and current month
Created the synonym and ran it in WebFocus, does not find any rows (RECORDS=0)

Here is the code in SQL when I run, returns two rows

Thanks

  
USE [WFReports]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[prc_Mktcode]

SELECT	'Return Value' = @return_value

GO

WebFocus Fex
TABLE FILE prc_Mktcode
PRINT
fld1 
fld2
..
END
-* does not return any records

This message has been edited. Last edited by: <Kathryn Henning>,

I faced the same returning 0 records from WebFOCUS, almost 2 years ago. As far as I remembered, when you use SP, it must adhere to some IBI rules. Once done that, we're good to go. There are few posts in this forum, please search. I'm not good at PL/SQL, but data folks helped me.

All the best!

Thanks Rifaz