Tables limits in Easytrieve

aetinf5 · New User Joined: 10 Mar 2005 Posts: 1

Could anyone tell about the maximum size of tables that can be created in a Easytrieve program?

rakeshraut · Posted: Mon Jul 04, 2005 2:04 pm

Table Definition

Instream Tables

Instream tables are specified by the INSTREAM subparameter of the TABLE option on the FILE statement. Instream tables are created by coding the table data immediately following the associated library definition statements for the table
file. Table data is ended by the word ENDTABLE in the first eight positions of a
record. Instream data is 80 characters per record. Table size is limited only by the
amount of available memory. The next exhibit illustrates an instream table
definition.
FILE WEEKDAY TABLE INSTREAM
ARG 1 1 A
DESC 3 9 A
1 SUNDAY
2 MONDAY
3 TUESDAY
4 WEDNESDAY
5 THURSDAY
6 FRIDAY
7 SATURDAY
ENDTABLE

External Tables

If you specify the TABLE option with no subparameter, the file is an external table whose maximum number of entries is limited by a value in the options table established at installation.
Check with your data center to determine this value. If the number of entries in your external table is larger than the default value, you
can code a numeric literal as the subparameter of the TABLE option to specify
the maximum number of entries.
A file which meets the following criteria can be defined as an external table:
An existing file that is in ascending order by the field used as a search
argument
A file created by having its name specified as the TO parameter of a SORT
statement which is sorted into ascending order by the search argument.

Regards,
Rakesh

pkmainframe · New User Joined: 14 Jun 2005 Posts: 16 Location: India

Hi,
the size of the external table by default of CA-Eztrieve on any installation is 300,000 records as external table, should be in sorted order,
for the instream table i think it will be only 256 datalines i am not pretty much sure on the instream coorect me if i am wrong.

Tx
kumar