Maximum Array Sizes

The following is a list of maximum array sizes defined by the Sequential Updates processor [U0411] during End of Period processing.

The Sequential Updates module combines many different modules, all of which require a sequential read through the data files in order to complete their function. In other words, each module must process all Master Financial (RLS) records and/or all Asset (REQ) records in the portfolio. The grouping of individual modules into the Sequential Updates [U0411] is done to reduce the processing time of End of Period by limiting the number of passes through the database. That is, instead of reading through the database multiple times for each of the individual functions that may be required, a single pass through the database is performed with multiple functions performed on each record as accessed.

For more detailed information on the Sequential Updates processor [U0411], refer to End of Period [U04]: Sequential Updates.

In order to store data for processing purposes, a number of arrays are used by the Sequential Updates program. The size limits of these arrays limit the number of corresponding items that may exist in the user's database. Exceeding these numbers causes a failure of the Sequential Updates processor [U0411] during End of Period. Exceeding these numbers also causes a failure of the Collection Initialization module, which is executed when all submitted portfolios have completed End of Period processing.