INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How do you use date variables in DB2 SQL code?

How do you use date variables in DB2 SQL code?

(OP)
I am trying to get a DB2 pass thru query to work. I intend to pass two dates to a function and build a pass thru that utilizes the dates. However, how do I substitute
the date values for the hard coded values in the following SQL.... thanks  ... the following code works until I start playing with the date values!!!.


SELECT OPEN_DT, ACCOUNT_NO, BRANCH_NO FROM TB
WHERE OPEN_DT >= '11/1/2009' AND OPEN_DT <= '11/30/2009' GROUP BY OPEN_DT, ACCOUNT_NO, BRANCH_NO              HAVING BRANCH

RE: How do you use date variables in DB2 SQL code?

Where did the term "pass thru query" originate. . .?

Why not put the dates into host variables rather than literals if you want them to be dynamic?

RE: How do you use date variables in DB2 SQL code?

Toyfox,
Are you talking an MS Access front end connected to a DB2 database?

I'm guessing that you are as that's the only place I've come across the term 'passthru query' before.

If so, how are you building the SQL? VBA?

Marc

RE: How do you use date variables in DB2 SQL code?




Did you try CURRENT DATE???

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close