Joined: 17 May 2005 Posts: 3 Location: mumbai,india
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
FILE WEEKDAY TABLE INSTREAM
ARG 1 1 A
DESC 3 9 A
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
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.
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.