Error while validating Multi value prompt macro in cognos Framework manager

[Samrat]

Hi,

I am trying to validate below condition in cognos FM 11 againist DB2 datasource.

[table name].[Filed name] in  (#Promptmany('Enter Premise Nbr(s) or % for All:','string','[table name].[Filed name]')#)

I am getting below error

"XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:"

any help??

Thanks,
SM

[bus_pass_man]

That error is coming from DB2.  It doesn't like one of the ( symbols in your expression.

Just eyeballing the expression doesn't have anything that leaps out and shouts boo.   The ( in Nbr(s) in the title might be clearing its throat, though.

If you replaced Nbr(s) with some string without the brackets do you get the error?

[bdbits]

Another idea - Prompt macros can sometimes generate odd/misleading error messages if a problem occurs during prompt resolution. So, I would suggest renaming the prompt title to something a bit more ordinary, just a simple string, and see if the error goes away. If it does, add your punctuation back in one at a time until the error show up again.