Executing MS-SQL2000 Stored Procedures from WebFOCUS

[LeonelSanchezJr]

I have a Stored Procedure which sits on a MS-SQL2000 server.

Is it possible to EXECute a stored procedure which returns records and produce a report?

Here is my fex:

SQL SQLMSS SET SERVER ABC_SITE
SET SQLENGINE=SQLMSS
SQL SQLMSS
EXEC dbo.DataMart_Missing_Data_Report ;
TABLE FILE SQLOUT
PRINT ABCSOURCE
ON TABLE PCHOLD AS RPTHLD
END
-RUN
TABLE FILE RPTHLD
PRINT HAWBSOURCE
END

-*************
I get an error that says that RPTHLD can not be found.

Thanks,

Leo ;-)

 

[brianw49]

Try This.


ENGINE SQLMSS SET DEFAULT_CONNECTION QUICKIEWF;
ENGINE SQLMSS SET CURSORS CLIENT;
-RUN

SQL SQLMSS
EX DATASTORAGE.dbo.TESTSP;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS WBW
END
-RUN
TABLE FILE WBW
PRINT *
END
-EXIT

First section is simply telling WebFocus what server to use.

You can not get the output from the stored procedure directly you have to grab it from the table named sqlout, i save it to a table named wbw which you can then use anywhere.

-Brian