Functions used in Local processing

[supak]

Hello.
Would somebody pls help me to get list of functions in Cognos report studio which can be used for LOCAL processing ?
I use Cognos report studio 10.1.1. My problem is that when I query metadata I can use basically any function....for example substr() and also substring(). But when I use already queried output (metadata) as basis for new query then I can't use substr() function.
I can only use substring() function.
When I try to use substr() I get following well known message >>
UDA-SQL-0219 The function "substr" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.RSV-SRV-0042

My understanding is that Report Studio is trying to use only local functions, but substr() function (or instr()) isn't simply available.

I am not database admin, so I don't want to change any settings. But it would very help me how to get those functions which are available for Report studio locally.

Thanks a lot.

[stan.parker]

Change the processing property on the query to Limited Local.

[bdbits]

Try to use the Cognos functions whenever possible, rather than database-specific functions. You can see which are database specific in the expression editor.

Cognos will often translate native functions to a database-specific function as needed when building the SQL for the database to process, and if not supported there will process it locally. If you use a database-specific function, it cannot make choices and there are restrictions, as you have seen.