× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. January 2007

Re: displaying date data with DDS


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  / \
--------------------------------------------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.