RE: Dynamic Arrays

["Booth Martin" <Booth@xxxxxxxxxxxx>]

--
--
[ Picked text/plain from multipart/alternative ]
ah!  yes, Himasnhu, you understand the problem perfectly!

As you do more in the AS/400 World you will come to realize that what you
describe happening is very typical.  5 records today, 2,000 next year, 150
000 five years from now.  Yes, nearly all of us would recommend  "Should I
go for one more database file" solution because we have all seen sudden
changes happen.

Think *NOMAX in all your planning.

---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: rpg400-l@midrange.com
Date: Wednesday, October 16, 2002 10:59:16 AM
To: rpg400-l@midrange.com
Subject: RE: Dynamic Arrays

Booth,

A fine day I start coding one program, in which I am fetching records from
database file and based on certain conditions I am storing in array to
process in a batch.(Today I have only 5 records satisfying the criterion).
what you feel. Should I go for one more database file to store all selected
records if not what dimension I can choose for array ?? Say 500 but what
about a year after when the selection criterion start selecting 1000
records. I feel only solution is REDIM array if possible with RPGLE.

Don't suggest any other way to store records like open query or something..
my requirement may be to use arrays only.

Himasnhu
--
[ IMSTP.gif of type image/gif deleted ]
--