January 27, 2006, 08:50 AM
MotiejusMS 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
January 27, 2006, 10:44 AM
k.laneYou 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
January 28, 2006, 07:07 AM
MotiejusHei!!! That's great!!!!
Thanks