Multi-Currency Query Parameters

If your organization has enabled support for multi-currencies, accessing currency information data using data services macros requires two additional query parameters. These query parameters must be prefixed to any query intended to return multi-currency data. The parameters are:
For example, if you run the a SQL SELECT statement calling PES_MACRO_INVESTMENT and want to return currency values in Yen, the query would be prefixed as follows:
# currency = JPY
# currency_effective_date = 1/1/2004

Specifying a currency value as part of running a virtual stored procedure should not cause an error if there is no currency information available. If multi-currency support is not enabled, you do not need to prefix your query with the parameters above.