i know you can execute MAcros from within a Stored procedure. Looking in the SPL manual it says you can't execute the macro with EXECURE ...(); There is reference to DECLARE CURSOR (MACRO) form. It's not very clear but do I make this declaration, then when I open the cursor does it execute the macro and return the result(s) with my fetch? i.e. not to sure on teh 'mecanics' of the process. Any pointers would help and be much appreciated. If there is an 'example' - that would be even better.