Re: AW: Dumb SQL question...

[Don <dr2@xxxxxxxxxxxx>]

yeah, that's what I saw in your dsppfm...that's interesting and not what I 
had heard or expected.  I had expected the 1/1/1 date...

is there a keyword I've missed for defining the default of a not null date 
field???

Don in DC

On Tue, 4 Oct 2005, rob@xxxxxxxxx wrote:

> My earlier testing showed that on a NOT NULL WITH DEFAULT I got today's
> date.
>
> You ought to see the @#$% I got with a simple NOT NULL:
>
> drop table qtemp/donny
>
> CREATE TABLE QTEMP/DONNY
> (MYCHAR CHAR ( 1) NOT NULL WITH DEFAULT,
> MYDATE DATE NOT NULL)
>
> INSERT INTO QTEMP/DONNY (MYCHAR) VALUES('a')
> Not authorized to object DONNY in QTEMP type *FILE.
>
> Special authority  . . . . . . . . . . . . :   *ALLOBJ
>                                               *AUDIT
>                                               *IOSYSCFG
>                                               *JOBCTL
>                                               *SAVSYS
>                                               *SECADM
>                                               *SERVICE
>                                               *SPLCTL
>
> Evidently IBM is totally off their nut.  Probably a QTEMP issue.  Let me
> retry:
> drop table qtemp/donny
> CREATE TABLE rob/DONNY
> (MYCHAR CHAR ( 1) NOT NULL WITH DEFAULT,
> MYDATE DATE NOT NULL)
>
> INSERT INTO rob/DONNY (MYCHAR) VALUES('a')
> Null values not allowed in column or variable MYDATE.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 10/04/2005 08:12 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> AW: Dumb SQL question...
>
>
>
>
>
>
> Hi Don,
>
> The default value for a NOT NULL Date-Field is  '00001-01-01'
>
> Birgitta
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Don
> Gesendet: Dienstag, 4. Oktober 2005 15:04
> An: midrange-l@xxxxxxxxxxxx
> Betreff: Dumb SQL question...
>
>
> Anyone know off hand what the default of a NOT NULL on a DATE field is in
> SQL?
>
> thanks...
>
> Don in DC
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.