PES_MACRO_VSPROC

PES_MACRO_VSPROC wraps the output of a virtual stored procedure into a macro, which allows the results to be manipulated by traditional SQL operations.

The parameters for this macro are:

Temporary table name
VSPROC Query surrounded by parenthesis, such as (SPGetPESObject1)
List of columns from the vsproc to be return back by the macro. If the column name from the vsproc is not a valid name for column in database then the as operator must be used to give a different name. For example if a column for the vsproc is "Column With Space" you query might look like this "SELECT CWS FROM PES_MACRO_VSPROC(tmp, (SPGetPESObject 1), Column With Space as CWS).