Set Input Parameter UPPERCASE

[kkirnbauer]

Hi,

in Cognos 10.2.2 i do native SQL Statements und i want to use Macro Prompts therefore. My Problem is, that the input Parameter should be uppercase. Is there any chance to achieve that?

I'm using the Prompt Macro like this:

select * from test
where 1=1 and #prompt('Artikelnummer','string',' ',' and koartn =')#

All fields in koartn are Uppercase, so i want the #prompt field also in uppercase.

Thanks

kind regards

[hespora]

Moin,


why would you have part of the select statemet inside your prompt macro, rather than outside? Let alone that the way you have it currently provides to "and"'s to the statment

Code Select Expand


select * from test
where 1=1 and koartn = #toupper(prompt('Artikelnummer','string',' '))#


Plus, if koartn accepts strings, you probably need single quotes, right? #sq(toupper(prompt('Artikelnummer','string',' ')))#