RE: RE: Date type L :-)

["Jewel, Jerry" <jerry.jewel@xxxxxxxxxxxxxx>]

COME TO THINK OF IT... 

With your email address (venu_yamajala@goodyear.com) DB2/400 may
consider any value you wish to use valid. 

Jerry


> As the saying goes:  This is a feature, not a bug.
> 
> For native date fields, the default value is the current date.  You
> can use DDS similar to the following to use a different default:
> 
> .....A..........T.Name++++++RLen++TDpB......Functions++++++++++++
>                                                                  
>      A          R RFMT                                           
>      A            MYUSADATE       L         DATFMT(*USA)         
>      A                                      DFT('01/01/0001')    
>      A            MYISODATE       L         DATFMT(*ISO)         
>      A                                      DFT('0001-01-01')    
> 
> The above sets the default date to low values; zeros is not a valid
> date.
> 
> Regards,
> Jerry Jewel
> 
> Better living through fine code and hot coffee!
> jerry.jewel@nissan-usa.com
> 
> 
> 
> Original message...
>       ----------
>       From:   VENU YAMAJALA[SMTP:venu_yamajala@goodyear.com]
>       Sent:   Monday, June 29, 1998 2:04 PM
> 
>        I am doing some study on L type data values. I have created a
> test PF with 10
>       L data type fields. All 10 fields get different formats with
> different
>       separators. Now I tried to add data into the PF using SQL by
> INSERT statement.
>       I tried to add data into only one field (say Fld9 which is in
> ISO format). I
>       moved some value 2000-02-29. The record is added. But when I did
> a SELECT
>       statement, surprisingly I found data in all the other fields
> also. I didnot add
>       data into it. The otehr fields got current date as their values.
> This looked
>       something strange to me. I am not good at L type fields. So can
> anybody explain
>       me how this is possible and why it is happening like this?? 
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---