DB2 function

pts.
Tags:
Development
Programming Languages
Software testing tools
SQL
T-SQL
Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,

Answer Wiki

Thanks. We'll let you know when a new response is added.

What is the filter you are contructing? What is the type of parameters1 and 2? You have parameter1 mentioned as both to and from?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TimHawkins
    And you might cut-and-paste the whole SQL statement for us as well because SQL sometimes complains about one part of the statement because another part has a syntax error. And, do you have the ability to show the resultant SQL statement (with the dates inserted), because the problem may be with that as well. And, I would recommend taking the whole SQL statement, and trying to run it in an interactive session.
    0 pointsBadges:
    report
  • PscJohnD
    Try replacing ((?Parameter1?) - 200) with (?Parameter2?) where the value of (?Parameter2?) is calculated before invoking the filter.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following