Resolving "A008 TOO MANY TABLE ENTRIES" runtime error

book

Article ID: 18482

calendar_today

Updated On:

Products

CA PanAudit Plus CA Easytrieve Report Generator CA PAN/SQL CA Endevor Software Change Manager (SCM) CA Endevor Software Change Manager - Natural Integration (SCM) CA Endevor Software Change Manager - ECLIPSE Plugin (SCM) CA Endevor Software Change Manager - Enterprise Workbench (SCM)

Issue/Introduction

Description:

Please see page D-24 of the Reference Guide for CA Easytrieve Report Generator release 6.4:


 	TBLMAX=nnnnn 

Specifies the maximum number of entries for a table that is loaded from an external file (not instream). The valid range is 0 to 32767.

Override is through the TABLE parameter of the FILE statement.

If the value that you specify for TBLMAX is excessively high, then the total amount of storage required is inflated. If the value that you specify for TBLMAX is too low, then a diagnostic message is issued as the file is loaded. Specify a value that is adequate for90 percent to 95 percent of the tables, then use the FILE statement override for particularly large tables.

Solution:

On the FILE statement, you may specify up to 32,767 for the number of table entries:

FILE name of the table TABLE 32767

Otherwise, if the number of entries is still too large, then KSDS VSAM file must be created.

Environment

Release: EDBMSU00200-6.4-Easytrieve-Report Generator-Option for DB2-MSU
Component: