Re: Date Field Printing

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Just a follow up on Jim's comment that date fields are not null capable.
This is not true for V4R4 as far as the database or RPG are concerned. I am
currently using null capable date fields under that release. I have no idea
if it is supported on earlier releases.

John Taylor
Canada



----- Original Message -----
From: "Jim Langston" <jlangston@conexfreight.com>
To: <RPG400-L@midrange.com>
Sent: Wednesday, January 19, 2000 12:56
Subject: Re: Date Field Printing


> There is actually no *NULL value for any field, it is something
> you can check for to see if the value should be considered null, but
> the field will always contain some data (even though it may be bad
> data, as in decimal data errors for numeric).
>
> Also, date fields are not yet *NULL capable.  So we don't even
> have something we can check to see if it's null or not.  But, regardless,
> checking for *LOVAL is exactly the same as checking for *NULL
> as far as I can tell, as long as *LOVAL is not an allowable entry.
>
> I have not actually used NULLs in RPG myself, but this is how I've
> heard they work.  Please correct me if I am wrong.
>
> Regards,
>
> Jim Langston
>
> Rob Berendt wrote:
>
> > I question 'the absence of a date is stored as 0001-01-01'.  Isn't
> > it stored as *null instead?  Does *null print this way?  Or is this
> > the effort of picking some arbitrary date to indicate the lack thereof?
> >
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---