Re: Dumb SQL question...

[Don <dr2@xxxxxxxxxxxx>]

Rob,

simple, I'm in a user group meeting right now with 20 people in a hotel 
room and my AS400 is back at my home...and it was a question asked here 
and nobody knew it....and I was still recovering from the Packers loss 
last night....

And all my handouts/manuals/rtfm's/etc are back at the office...

Thanks

Don in DC


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

> What's so hard about testing?
>
> CREATE TABLE QTEMP/DONNY
> (MYCHAR CHAR (1 ) NOT NULL WITH DEFAULT,
> MYDATE DATE NOT NULL WITH DEFAULT)
>
> INSERT INTO QTEMP/DONNY (MYCHAR) VALUES('a')
>
> select * from qtemp/donny
>
> ....+....1....+...
> MYCHAR  MYDATE
>  a     2005-10-04
> ********  End of da
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
> --
> 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.