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

Hi Chris,

He's not using 2011-00-00 as a date. It's a character field, and it's the unique key to the reporting period table. When you want a report, you tell it which reporting period you want by giving it the key to the reporting period table. The table entry has the actual start and end dates used to select records for the report.


--*
Peter Dow*/
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /



On 8/29/2011 8:37 AM, Wyatt, Chris (FGWA-IL) 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.