Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: String Constant not valid error

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You wouldn't mind posting the code for the SP? Also supply your Db2 version and OS.

    Andy

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •