RE: Date fields not being retrieved

The date fields in the databse have a value(not NULL/BLANK and SHARE(*YES) is mentioned on the OVRDBF command. The date values are still being retrievd as NULL/BLANK.

Any suggestions.....> Subject: RE: Date fields not being retrieved> Date: Mon, 7 Jul 2008 10:11:18 -0400> From: jarnold@xxxxxxxxxxxxxxxxxxxxxxxxxx> To: rpg400-l@xxxxxxxxxxxx> > Are there blank date values in the data?> > > John Arnold> (301) 354-2939> > > -----Original Message-----> From: rpg400-l-bounces@xxxxxxxxxxxx> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of derek gonsalves> Sent: Monday, July 07, 2008 9:34 AM> To: rpg> Subject: Date fields not being retrieved> > > Hi ,> > I have a printer file Program Test. > Records for this program are selected with OPNQRYF> > OVRDBF FILE(ABC)> > OPNQRYF FILE(ABC) QRYSLT(SELECT WHERE DATE1 > '2006-07-01'> > CALL PGM(TEST) .> > All the date fields are being retrieved as Blanks.Other field values are> being retrieved correctly.> The Program is compiled with the CVTOPT *DATETIME.> > Any suggestions as to why the date fields are being retrieved as Blanks?> > > Thanks> Derek> _________________________________________________________________> Use video conversation to talk face-to-face with Windows Live Messenger.> http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGL> M_WL_Refresh_messenger_video_072008> --> 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.>
_________________________________________________________________
It’s a talkathon – but it’s not just talk.
http://www.imtalkathon.com/?source=EML_WLH_Talkathon_JustTalk