RE: Date data type with embedded SQL

Birgitta,

Sorry, I forgot to add that to the post.  I found reference to the DATFMT set 
option in one of your archived posts.  It didn't seem to help however.  My 
current set statement follows. 

     c/Exec SQL         
     c+ Set Option      
     c+  Commit = *None,
     c+  DatFmt = *ISO  
     c/End-Exec         

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of HauserSSS
Sent: Friday, January 06, 2006 12:38 PM
To: RPG programming on the AS400 / iSeries
Subject: AW: Date data type with embedded SQL


Hi Rick,

add a set option statement to fix the date and time format used by SQL.
The date format must have a 4 digit year, that means you specify one of the
following formats *ISO, *EUR, *USA, *JIS.
The precompiler generates an extra field for each host variable used in an
SQL-Statement. (SQL...)
Date and time fields get the date/time format that is either specified in
the CRTSQLRPGI command option DATFMT and TIMEFMT or in the SET OPTION
statement. The default value in the CRTSQLRPGI is *JOB and the job date
format normally uses only a 2 digit year. In this way the field create by
the SQL precompiler only uses 8 bytes and not 10 as expected in your data
structure.

C/EXEC SQL  SET OPTION DATFMT = *ISO, TIMFMT = *ISO
C/END-EXEC

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.