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
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?
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.