RE: Embedded SQL - fetching a date

Nope. 


Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Friday, July 15, 2005 2:15 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL - fetching a date

Do you have DATFMT other than *ISO specified on the h-specs?

Charles Wilt
--
iSeries Systems Administrator / Developer Mitsubishi Electric Automotive
America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Kurt Anderson
> Sent: Friday, July 15, 2005 11:23 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Embedded SQL - fetching a date
> 
> 
> I can't seem to fetch a date format field and place it in a date 
> format field in a Data Structure.  If I change the field in the DS to 
> be 10A instead of D, then it works.
>  
> Is there something I can do so I can drop the value right into a date 
> format field instead of having to drop it into an Alpha field and then

> move it to a date format field myself?
>  
> I don't seem to have this problem when I do a simple Select Into 
> statement.
>  
> Thanks,
>  
> Kurt Anderson
> Application Developer
> Highsmith Inc.
> W5527 State Road 106, P.O. Box 800
> Fort Atkinson, WI 53538-0800
> TEL (920) 563-9571  FAX (920) 563-7395 EMAIL kjanderson@xxxxxxxxxxxxx
>  
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a 
> moment to review the archives at http://archive.midrange.com/rpg400-l.
> 
>