×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
That is a difference between DATE implementations? He's writing the article for SQL Server users so SQL Server allows this date while DB2 doesn't?
I've also seen the use of 'last day of the month' dates in billing systems which like to relax the valid date rule to include 2011-02-31.
Paul Morgan
Principal Programmer Analyst
IT Supply Chain/Replenishment
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wyatt, Chris (FGWA-IL)
Sent: Monday, August 29, 2011 11:38 AM
To: Midrange Systems Technical Discussion
Subject: RE: Article by Joe Celko - Mimicking magnetic tape in SQL - A mustread for RPG'ers
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.
midrange.com
