Focal Point
MS SQL stored procedurs

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

January 27, 2006, 08:50 AM
Motiejus
MS SQL stored procedurs
I am just curious, is it posible to use MS SQL stored procedures in WebFOCUS reports?

Like:

TABLE FILE CAR
PRINT my_stored_procedure(par1,par2)
END


Motiejus Jankevicius
January 27, 2006, 10:44 AM
k.lane
You can use MS SQL stored procs to retrieve data for display in WebFOCUS reports.

You can use:

SQL SQLMSS EX proc_name &VALUE;

to retrieve the data and then use the following to report:

TABLE FILE SQLOUT
PRINT *
END

Ken


Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.
January 28, 2006, 07:07 AM
Motiejus
Hei!!! That's great!!!! Smiler Smiler

Thanks Wink


Motiejus Jankevicius