Micros SQL Question

[Wildbar]

In Micros 3700 i am trying to pull information from 'spkds_R_course_performance.course_avg_prep'
from the stored procedure 'spkds_R_course_performance.course'
using SQL (dbisql) Was looking for some direction as i am unsure of how to call a stored procedure this way and return data
Thanks

 

[pmegan]

It depends on the version of 3700 you're using. Sybase was upgraded to ADA9 in Res4.6 and that lets you query a sproc as if it were a table.

 

[Wildbar]

4.7 we are at but cant seem to get it figured. Could you give an example of how to call one?

 

[pmegan]

This will dump the results from that sproc into a temporary table that you can then use to do whatever you have to. I don't know what kind of parameter it wants though so just used '. Looks like it takes an SQL snippet to extend the WHERE clause.

select * 
into #t_kds
from micros.spkds_R_course_performance(');

select * from #t_kds;