Re: displaying date data with DDS

["M. Lazarus" <mlazarus@xxxxxxxx>]

David, SImon,

 You need to add the CVTOPT(*DATETIME) keyword to the CRTRPGPGM 
compile statement.

 -mark


At 1/15/07 08:20 PM, you wrote:

> On 16/01/2007, at 11:20 AM, David Prowak wrote:
>
> > Are there any tricks to getting a RPG/400 program to display a true
> > date
> > field?
>
> This appears to be a DDS question. Are you on a release that supports
> Date, Time, and Timestamp data types in display files? If so, does SDA
> on your release support them?
>
> Note that RPG/400 does not support Date, Time, and Timestamp fields but
> it does tolerate them by converting them to character.
>
> > I have a true date field (data type L) from a database that I am
> > trying to
> > display in a subfile.  There is data in the field but none of it shows
> > up
> > via the display.  Other fields display fine.
> >
> > When I add the field to the display using SDA, I get the message:
> > *Field BZDTE will be defaulted to keyboard shift attribute type A*
> > **
> > Thanks for any help you can provide.
>
> Sounds like SDA does not support the Date data type and is converting
> it to character. What does the second-level text of the error message
> say?
>
> I know SDA at VRM510 supports Date, Time, and Timestamp. I think VRM510
> was when the system supported Date, Time, and Timestamp fields in
> display files.
>
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>     FlyByNight Software         OS/400, i5/OS Technical Specialists
>
>     http://www.flybynight.com.au/
>     Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>     Fax:   +61 3 9419 0175                                   \ /
>                                                               X
>                   ASCII Ribbon campaign against HTML E-Mail  / \
> --------------------------------------------------------------------
>
>
> --
> 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.