Re: Article by Joe Celko - Mimicking magnetic tape in SQL - A must read for RPG'ers

Chris,

You cannot use '00' as a value for month or day in iSeries SQL. That date
would translate as '2011-01-01'. In the same venue, the minimum value you
can use for a date is '0001-01-01' (I think that must conform to the ANSI
SQL standard).

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Aug 29, 2011 at 11:07 AM, Wyatt, Chris (FGWA-IL) <
Chris.Wyatt@xxxxxxxx> wrote:

I'm curious...

Did anyone try the sample SQL in his article? My System i didn't like
'2011-00-00' as a date. I liked his reason for using it, tho.

cw

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Monday, August 29, 2011 8:08 AM
To: Midrange Systems Technical Discussion
Subject: Article by Joe Celko - Mimicking magnetic tape in SQL - A must
read for RPG'ers

All,

If you're using or trying to use more SQL, I highly recommend just about
_anything_ written by Joe Celko.

Got a link to this in my inbox this morning...


http://www.simple-talk.com/sql/t-sql-programming/mimicking-magnetic-tape-in-sql/


Charles
--
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.