Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: aetcognos on 09 Jun 2016 08:24:34 AM

Title: substring on prompt values
Post by: aetcognos on 09 Jun 2016 08:24:34 AM
Hello gurus,

Is there a way to split the prompt values from a multiselect text box prompt, based on character count.

I am forced to use the oracle INSTR function to compare values from a prompt with a database column. I can use it without issues, but when the no. of characters returned from the prompt exceeds 4000, I get an oracle error that the literal is too long.

So is there a way to split the prompt values to be of 4000 characters each..

Thanks
AETCOG
Text only | Text with Images