Using keyword "TODAY" in where clause

[jguoz]

Trying to use the keyword TODAY in the selection tab of InfmxCLI stage. When I use the statement : select * from <table> where load_date = today, directly on the database, I get the desired results. When I try this in datastage, I get zero rows returned.

I'm thinking that datastage doesn't recognize the keyword TODAY.

Any thoughts?

Jaime

I have Server version 7.5.1.A.

 

[jguoz]

I'm answering my own question so the next person will have the answer. When I had the selection criteria of (load_date between today and today -6), this returned zero records. But when I changed the syntax to be (load_date between today -6 and today)...it works.

This answer was resolved by IBM tech support.