Reference → Data Service Macros → Object Macros → 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).
Copyright © 2003–2011 Serena Software, Inc. All rights reserved.