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.
> 
>