|
At 07:25 PM 9/9/97 -0500, Bob wrote: >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 Right on! DB2/400 has some kind of bit flag for NULL values. There's no reason not to have an %ISNULL BIF, like SQL does, 'if field = *NULL'. Let's here it for embedded SQL, or SQL-CLI, huh? Cheers +--- | 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-2025 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.