RE: Embedded SQL newby question...

Thank you. That was it, along with Birgitta's inclusion of Timfmt. Now
to continue debugging!! 

-----Original Message-----
From: rpg400-l-bounces+dturnidge=oldrepublictitle.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+dturnidge=oldrepublictitle.com@xxxxxxxxxxxx] On
Behalf Of rob@xxxxxxxxx
Sent: Friday, October 27, 2006 10:07 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Embedded SQL newby question...

Could be an SQL vs rpg date format.  And, yes, it would be nice if it
was true that "a date is a date is a date".  However take a look at
adding the following, (especially the date format option):
     C/EXEC SQL
     C+ Set Option
     C+     Naming    = *Sys,
     C+     Commit    = *None,
     C+     UsrPrf    = *User,
     C+     DynUsrPrf = *User,
     C+     Datfmt    = *iso,
     C+     CloSqlCsr = *EndMod
     C/END-EXEC
This is the SQL equivalent of the H spec.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com