Re: displaying date data with DDS

["David Prowak" <prowak@xxxxxxxxx>]

Bingo!

Using CVTOPT(*DATETIME) allows the program to access and display date data.

Thanks Mark!


On 1/15/07, M. Lazarus <mlazarus@xxxxxxxx> wrote:
> 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.
>
> --
> 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.