RE: Why cannot use Current date in this query?

IOW you really need to tell us the two fields you are comparing. But,
I'll take a guess, as Paul did, that you are trying to compare a true date
field (current date) against a packed decimal column from your database.

There's many ways to slay this dragon. There's a big performance
difference in it.

Converting current date to numeric
will often perform better than
converting db2 column to a date field
because it can continue to use existing indexes and whatnot. That, and
there's only one conversion involved.

See idate at
http://www.think400.dk/downloads.htm
For easy date conversions with error checking.


Rob Berendt