|
We do NOT have null values in dates, or any other fields. There is a NULL INDICATOR, however. A really sucky implementation of nulls. You set ON a %NULLID(myDateFld) flag and then test if it's equal to ON. The date field can contain only valid dates, but the null indicator can be on or off. I am very disappointed in this implementation. ;-( Bob Cozzi Bob@RPGIV.COM www.rpgiv.com AS/400 Books: http://www.rpgiv.com/as400Books.html On Tuesday, September 09, 1997 2:20 PM, Vern Hamberg [SMTP:hambergv@goldengate.net] wrote: > At 12:35 PM 9/9/97 -0400, boothm@earth.goddard.edu wrote: > >Ok, we've had two, maybe three, people say the L-date field is the way to > >go. Any other voices? > > > >And John, you still haven't said what inaccurate date we should use to > >signify a date field that is unfilled yet. > > > >I am asking this because I really do want to use the L-date field, but I > >get hammered everytime I mention it to others. If performance really is > >no longer an issue then that is great, but if reading through an unkeyed > >file takes three times as long for every L-date field in it then L-date is > >not ready for primetime. > > booth > > Might as well add my 3-cents. I think someone mentioned NULL values inthis > thread. Is that an option? I mean, that's what NULL is for--something not > filled yet. > > Maybe? > > +--- > | This is the Midrange System Mailing List! > | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". > | To unsubscribe from this list send email to MAJORDOMO@midrange.com > | and specify 'unsubscribe MIDRANGE-L' in the body of your message. > | Questions should be directed to the list owner/operator: david@midrange.com > +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MAJORDOMO@midrange.com | and specify 'unsubscribe MIDRANGE-L' in the body of your message. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
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.