RE: How to chase down SQL0181 - Value in date, time, or timestamp string not valid.

[Richard Theis <theis_richard@xxxxxxxxxx>]

<snip>
And why when I try to test TranDate in a Where clause that it
spits out "Column TRANDATE not in specified tables"?
</snip>
It's a rule : the SELECT statement uses the WHERE clause to populate a
result table.  You can rename the resulting columns, but you cannot use the
resulting name in the WHERE clause (catch 22 situation) !  However, you can
use it in the ORDER BY clause, as the ORDER BY is applied on the result
table.
HTH

Bonne réception/Best regards
Richard THEIS
  iSeries Education, France
  theis_richard@xxxxxxxxxx