Re: Date performance

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Luc,

Thanks.

It is definitely described in the V3R1 and V3R2 manuals.  I could not find it 
in V4R1 or V4R2.  I assumed it 
would be in the V3R6 and V3R7 manuals.  Perhaps it was only described in the 
IMPI manuals.

It would be nice but I guess not really necessary.  The size of date fields on 
disk only affects the amount of 
DASD required and disk is cheap.  The date manipulation benefits are what 
should drive using 
date/time/timestamp fields not disk space.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Microsoft Outlook Express 4.71.1712.3
> Date: Mon, 26 Oct 98 20:59:06 +0100
> From: "Brigitte Caura" <Caura@club.innet.be>
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: Re: Date performance

> 
> Thanks a lot , Simon
> 
> A nice clear explanation.
> 
> 2 small remarks:
> . V3R7 manual does mention storage of 10 chars, just as V4R2.
> . It would have been nice if this difference of 'program storage (what s in
> a name)' and 'storage storage' was explained explicitly.
> 
>  Regards
> Luc

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---