Re: Large ":occurs" in a create array

["Derry, Denny" <Denny.Derry@NMB.NORWEST.COM>]

     Hi Eric,

        At one time we needed a report that required an array that was
too
     larger for our RISC/6000 to handle, so I created and used temporary

     tables in Sybase to mimic an array. I found it actually easier than

     the array processing SQR provides. There's a little extra overhead,

     but I have never used an array since...

     Hope this helps,
     -Denny


______________________________ Reply Separator
_________________________________
Subject: Large ":occurs" in a create array
Author:  Eric Dimick Eastman [SMTP:erice@ONTKO.COM]  at NMB
Date:    3/15/98 12:06 PM


Hello All,

Has anyone used very large values in a create-array command.  I am
thinking about trying to use something like:

create-array
  name=select_cache
  size=500
  field=num_rows:number
  field=field1:char:50000
  field=field2:char:50000
  field=field3:char:50000
.. . .
  field=field20:char:50000

SQR doesn't try to allocate 20 X 500 X 50000 = 500 million bytes of
memory does it?  And that doesn't even count the size of the data.

This array will be pretty sparce.  Probably only 5-6 of
the 500 records will get above 1000 occurances.

Am I crazy to try it?  Has anyone else tried something similar?

This will be running on a pretty hefty Sun box against Oracle.

Thanks in advance for your help,
Eric

------------------------------------------------------------------------

Eric Dimick Eastman |Ray Ontko & Co|About 6,000 years ago, in 7 days,
erice@ontko.com     |Richmond, IN  |God created the Earth, complete
http://www.ontko.com|              |with 5,000,000,000 years of history.