RE: Embedded SQL - fetching a date

I certainly learned a thing or two.  I had always set SQL date format to
*USA but left the program at default of *ISO.  I never ran into the "Date,
Time or Timestamp value is not valid" error before because I ended up not
using my date fields from my SQL statement (which pointed out to me that I
was using bloated result sets for no good reason because of external host
structures).  Back to those programs for some redesign soon I suspect. 

Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kurt Anderson
Sent: Tuesday, July 19, 2005 1:59 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL - fetching a date

Matt,

Thanks for sticking with me.
Apparently I had another field in the host data structure incorrectly
defined (Like(a non-existent field)).  This was a copy of some source I
was working with, but apparently was an old copy, which was the cause of
all of my confusion it seems.

I've now come to the same conclusion as you.  I can't explicitly define
a date format field in the host data structure, I need to use a Like().

Thanks again.

Kurt Anderson
Application Developer
Highsmith Inc