Re: AW: Dumb SQL question... -- MIDRANGE-L

yeah, that's what I saw in your dsppfm...that's interesting and not what Ihad 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 datefield???


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.