RE: Date data type with embedded SQL

Matt,

That did the trick.  Is this behavior documented somewhere?  I never would have 
guessed to use like on the date and time fields.  Here's what I ended up with.

      // Data Structure for returning Application information from SQL  
     d RtnDtaSet       ds                  Occurs(1280) Based(RtnDtaSet@)
     d  AWrkQ                         3a                                
     d  ASysId                        1a                                
     d  ATrans                        7a                                
     d  AUser                        10a                                
     d  ALdDate                            Like(ixTDat)                 
     d  ALdTime                            Like(ixTTim)                 
     d  AAppl#                       12s 0                              
     d  ADlr#                         5s 0                              
     d  ALName                       30a                                
     d  AUpdt                         1a                                
     d  AApnd                         1a                                
     d  AHowR                         3a                                
     d  AGfxId                        8s 0                              
     d  ABrnch                        3s 0                              

Thanks,

Rick

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


Rick,
        that is close. 

        You cannot define a MODS with explicit date field definitions
and use FETCH ... FOR x ROWS INTO ...  The compiler only allows you to
use LIKE() for date fields in MODS (at least on V5.2).  The sample code
I sent I can get it to fail if I reference REC1 with an explicit date
field definition. 

Put the date, time definitions in stand alone fields and then use them
as definition references in the MODS.

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


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.