Hi everyone I got this error on my procedure and can't figure out the problem.

Create stored procedure returns SQLCODE: -105, SQLSTATE: 42604.

DWH.AMJ_CRMCONTACTEXTRACT: 182: The string constant beginning with "B' where Revenue >= '" is not valid.

The string constant beginning with "B' where Revenue >= '" is not valid.

Not quite sure what's causing this issue, any help or idea where to start would be highly appreciated! Thank you

You wouldn't mind posting the code for the SP? Also supply your Db2 version and OS.

Andy

Perhaps, you forgot some quotation marks("'") or put extra quotation marks.
This must be one of popular programming error which made by most peoples in many program codes not only on SQL(including me from about 40 years ago of PL/I programs).