RE: can't get date with sqlrpg

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

> -----Message d'origine-----
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de 
> Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
>
> Remove the space between the colon and WMAJDL on you SET statement...

Huh? That line works. It's the format of the date that's wrong.









> Hi all
>
> This was giving me '30/11/10  '
>
> C/EXEC SQL 
> C+ SET : WMAJDL = CURRENT DATE
> C/END-EXEC 
>
> I wanted '30.11.2010'
>
> So I tried :
>
> C/EXEC SQL 
> C+ SET OPTION DATFMT = *EUR 
> C/END-EXEC
>
> the editor accepts this but the compiler says position 9 not 
> admitted. 
> Where is position 9 anyway? 
>
> Thanks for your help.
>  
> -- 
> This is the RPG programming on the IBM i / System i 
> (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.
>
>
> -- 
> This is the RPG programming on the IBM i / System i 
> (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.