RE: Date Field block size

Tony,

I don't know for sure, but...I believe you'll want to figure on the date
as being 10 bytes.

As I understand it, the 4 byte date is very low level.  By the time the
record is passed up out of the DB it has been expanded to the 10 bytes
your RPG program is expecting.

Heck, try it both ways, one should be faster than the other right?

Merry Christmas to all...I'm going home!

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tony Carolla
> Sent: Friday, December 23, 2005 12.50
> To: RPG programming on the AS400 / iSeries
> Subject: Date Field block size
> 
> Okay, first off,
> 
> MERRY CHRISTMAS!!!  May the holiday spirit hit you like a 
> model B50 falling
> off a loading dock ;-)
> 
> I have a question.  I am trying to calculate the optimum 
> block size to use
> with OVRDBF SEQONLY(YES XXXX), for an input file from which I 
> will read all
> records.  The file contains the following layout:
> 
> FMACRO  3A
> FMNUM  9P 0
> FMUPDAT  L
> 
> DSPFD indicates that the record length is 18.  Now, I know 
> once I READ, the
> field that will be created to represent FMUPDAT is a length 
> 10 (ISO) field.
> But on disk, it is a four-byte field.  So my question is this:  My
> understanding is that a size of I/O from disk is 128K.  If 
> this is to be
> read directly from disk, into the buffer when the READ op 
> executes, will
> there be a need for ten bytes to store this field?  I know 
> that the single
> variable inside the program will never see that four-byte 
> value directly,
> but why would a disk buffer need to know anything else other 
> than the four
> bytes?
> 
> --
> "Enter any 11-digit prime number to continue..."
> "In Hebrew SQL, how do you use right() and left()?..." - 
> Random Thought
> "If all you have is a hammer, all your problems begin to look 
> like nails"
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>