RE: Date type L

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

Venu,

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
+---