Re: displaying date data with DDS

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.